Beispiel #1
0
        private void insertToBigQuery(DateTime currSecond, BinanceOrderBook record)
        {
            string baseCurrency   = SYMBOL_MAP[symbol].baseCurrency;
            string targetCurrency = SYMBOL_MAP[symbol].targetCurrency;

            BigQueryInsertRow row = new BigQueryInsertRow(insertId: currSecond.ToString())
            {
                { "t", addOneSecond(currSecond) },
                { "bid", BigQueryNumeric.Parse(record.Bids.ToArray()[0].Price.ToString()) },
                { "ask", BigQueryNumeric.Parse(record.Asks.ToArray()[0].Price.ToString()) },
                { "base", baseCurrency },
                { "target", targetCurrency },
                { "s", symbol },
                { "localTime", DateTime.UtcNow }
            };

            bqClient.InsertRow("firebase-lispace", "binance_orderbooks", getTableName(addOneSecond(currSecond)), row);
        }