Data output

Excel

Table 1 BTC/USD - 1 minute

Open	Close	High	Low	Volume	Ticker	YMD	Time
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

Table 2 BTC/USD - 1 minute in SQL (the timestamp is shown in milliseconds)

ID	Timestamp	Open	Close	High	Low	Volume	Ticker	Interval
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