Data output
===========

Excel
~~~~~

.. csv-table:: **BTC/USD - 1 minute**
   :header: "Open", "Close", "High", "Low", "Volume", "Ticker", "YMD", "Time"
   :widths: 20, 20, 20, 20, 20, 20, 20, 10

   7203, 7201, 7203.7, 7200.1, 9.404174, BTC/USD, 12/31/2019, 16:00:00
   7203, 7223.6, 7223.6, 7201, 7.9037398, BTC/USD,12/31/2019, 16:01:00
   7224.4,	7225, 7225.5, 7224.4, 0.47992977, BTC/USD, 12/31/2019, 16:02:00
   7224.980953,	7225.9,	7225.9,	7224.980953, 0.92945729,	BTC/USD,	12/31/2019,	16:03:00
   7225.86202,	7225.72953,	7225.9,	7225.72953,	0.29132017,	BTC/USD,	12/31/2019,	16:04:00
   7225.7,	7225.867273,	7225.9,	7225.297252,	1.03197044,	BTC/USD,	12/31/2019,	16:05:00
   7225.9,	7225.9,	7225.9,	7225.8,	0.9328,	BTC/USD,	12/31/2019,	16:06:00
   7225.9,	7225.521797,	7225.9,	7225.5,	0.98563711,	BTC/USD,	12/31/2019,	16:07:00
   7225.521797,	7221.112632,	7225.521797,	7221.112632,	0.73935526,	BTC/USD,	12/31/2019,	16:08:00
   7221.112632,	7223,	7223,	7221.112632,	0.12223545,	BTC/USD,	12/31/2019,	16:09:00

SQL
~~~

.. csv-table:: **BTC/USD - 1 minute in SQL (the timestamp is shown in milliseconds)**
   :header: "ID", "Timestamp", "Open", "Close", "High", "Low", "Volume", "Ticker", "Interval"
   :widths: 20, 20, 20, 20, 20, 20, 20, 10, 10

   1,	1577868000000.0,	7205.7,	7205.8,	7205.8,	7205.7,	0.07137942,	BTCUSD,	1m
   2,	1577867940000.0,	7205.70155305,	7205.8,	7205.8,	7205.70155305,	0.035,	BTCUSD,	1m
   3,	1577867880000.0,	7205.7,	7205.70155305,	7205.70155305,	7205.7,	0.025,	BTCUSD,	1m
   4,	1577867820000.0,	7205.7,	7205.75299748,	7205.75299748,	7205.7,	0.075,	BTCUSD,	1m
   5,	1577867760000.0,	7205.75299748,	7205.75299748,	7205.75299748,	7205.75299748,	0.005,	BTCUSD,	1m
   6,	1577867700000.0,	7205.75299748,	7205.2,	7206.3,	7205.2,	4.5802,	BTCUSD,	1m
   7,	1577867640000.0,	7205.2,	7205.2,	7205.2,	7205.2,	0.02180065,	BTCUSD,	1m
   8,	1577867580000.0,	7205.19214247,	7205.19217136,	7205.19217136,	7205.19214247,	0.01602554,	BTCUSD,	1m
   9,	1577867520000.0,	7205.12752306,	7205.1819341,	7205.1819341,	7205.12752306,	0.01346836,	BTCUSD,	1m
   10,	1577867460000.0,	7205.1,	7205.1,	7205.1,	7205.1,	0.66592911,	BTCUSD,	1m