Xcalibra Market Data

timestamp Timestamp	open Open	high High	low Low	close Close	count Count	volume Volume	quantity Quantity
2020-05-19 00:00:00+00:00	1100000	1100000	1100000	1100000	1	110	0.0001
2020-05-18 00:00:00+00:00	1199999.99999999	1199999.99999999	1000000	1100000	6	20280.438	0.01876878
2020-05-17 00:00:00+00:00	1199999.99999999	1199999.99999999	1199999.99999999	1199999.99999999	2	239.999999999998	0.0002
2020-05-16 00:00:00+00:00	1199999.99999999	1199999.99999999	1199999.99999999	1199999.99999999	2	239.999999999998	0.0002
2020-05-15 00:00:00+00:00	1199999.99999999	1199999.99999999	1199999.99999999	1199999.99999999	3	1217.5559999999898	0.00101463
2020-05-14 00:00:00+00:00	1199999.99999999	1199999.99999999	1199999.99999999	1199999.99999999	2	239.999999999998	0.0002
2020-05-13 00:00:00+00:00	1100000	1199999.99999999	1100000	1199999.99999999	7	30398.50639999989	0.02644387
2020-05-12 00:00:00+00:00	950000	1199999.99999999	950000	1100000	3	2310.815899999999	0.00208256
2020-05-11 00:00:00+00:00	1100000	1199999.99999999	950000	950000	8	57303.69677114	0.05952023
2020-05-10 00:00:00+00:00	1190000	1199999	1010001	1100000	13	53232.11586185	0.05016619


CREATE TABLE btc_rsd_day (
  "timestamp" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "count" BIGINT,
  "volume" DOUBLE,
  "quantity" DOUBLE
);