PREVIEW / futures_1hour / 2017-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-12.parquet
  size:    54 KB
  rows:    1,638

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-04-12 00:00:00	ES	Futures	2564.54	2565.91	2564.54	2564.81	2724.0
2017-04-12 01:00:00	ES	Futures	2565.09	2567.27	2564.27	2567.0	5666.0
2017-04-12 02:00:00	ES	Futures	2567.0	2569.18	2565.91	2568.91	8971.0
2017-04-12 03:00:00	ES	Futures	2568.91	2574.65	2567.0	2573.01	34432.0
2017-04-12 04:00:00	ES	Futures	2573.01	2573.01	2569.73	2570.0	17655.0
2017-04-12 05:00:00	ES	Futures	2570.28	2571.64	2568.36	2568.91	12527.0
2017-04-12 06:00:00	ES	Futures	2568.64	2569.46	2565.36	2566.72	21610.0
2017-04-12 07:00:00	ES	Futures	2566.45	2567.27	2563.72	2565.09	21058.0
2017-04-12 08:00:00	ES	Futures	2564.81	2565.63	2562.9	2563.72	23494.0
2017-04-12 09:00:00	ES	Futures	2563.99	2566.18	2560.44	2563.45	185115.0
2017-04-12 10:00:00	ES	Futures	2563.45	2567.0	2558.53	2559.62	215040.0
2017-04-12 11:00:00	ES	Futures	2559.62	2561.53	2553.89	2556.62	171770.0
2017-04-12 12:00:00	ES	Futures	2556.89	2559.35	2554.43	2555.8	103409.0
2017-04-12 13:00:00	ES	Futures	2555.8	2563.99	2555.8	2563.45	140062.0
2017-04-12 14:00:00	ES	Futures	2563.45	2563.99	2555.8	2558.8	114604.0
2017-04-12 15:00:00	ES	Futures	2558.8	2560.72	2554.98	2557.71	296418.0
2017-04-12 16:00:00	ES	Futures	2557.98	2560.99	2555.53	2555.8	100921.0
2017-04-12 18:00:00	ES	Futures	2555.25	2558.53	2555.25	2557.71	7268.0
2017-04-12 19:00:00	ES	Futures	2557.44	2558.53	2556.35	2556.35	3978.0
2017-04-12 20:00:00	ES	Futures	2556.35	2557.71	2554.98	2555.25	11277.0
2017-04-12 21:00:00	ES	Futures	2555.53	2557.16	2550.61	2554.71	24474.0
2017-04-12 22:00:00	ES	Futures	2554.71	2556.89	2554.16	2555.25	6193.0
2017-04-12 23:00:00	ES	Futures	2555.53	2557.16	2555.25	2556.62	6146.0
2017-04-12 00:00:00	NQ	Futures	6426.71	6432.08	6426.11	6428.5	932.0
2017-04-12 01:00:00	NQ	Futures	6428.2	6433.87	6426.11	6432.97	869.0
2017-04-12 02:00:00	NQ	Futures	6433.57	6439.53	6430.29	6438.34	1443.0
2017-04-12 03:00:00	NQ	Futures	6438.34	6455.03	6433.57	6450.86	5978.0
2017-04-12 04:00:00	NQ	Futures	6450.86	6451.46	6444.3	6445.49	2703.0
2017-04-12 05:00:00	NQ	Futures	6445.49	6450.26	6444.0	6445.19	2366.0
2017-04-12 06:00:00	NQ	Futures	6445.19	6447.28	6435.95	6440.13	3110.0
2017-04-12 07:00:00	NQ	Futures	6439.83	6441.02	6430.88	6432.97	2735.0
2017-04-12 08:00:00	NQ	Futures	6432.67	6435.06	6428.8	6432.97	2861.0
2017-04-12 09:00:00	NQ	Futures	6432.97	6440.72	6424.03	6433.57	37982.0
2017-04-12 10:00:00	NQ	Futures	6433.87	6438.93	6416.87	6419.85	44472.0
2017-04-12 11:00:00	NQ	Futures	6419.55	6426.71	6403.75	6411.21	26761.0
2017-04-12 12:00:00	NQ	Futures	6411.21	6416.87	6403.46	6407.33	19104.0
2017-04-12 13:00:00	NQ	Futures	6407.03	6428.2	6405.54	6427.31	21628.0
2017-04-12 14:00:00	NQ	Futures	6427.01	6428.5	6407.63	6416.57	20403.0
2017-04-12 15:00:00	NQ	Futures	6416.57	6420.15	6404.95	6411.21	41080.0
2017-04-12 16:00:00	NQ	Futures	6411.21	6415.98	6402.86	6403.75	6949.0
2017-04-12 18:00:00	NQ	Futures	6402.86	6412.1	6402.86	6409.12	1304.0
2017-04-12 19:00:00	NQ	Futures	6409.12	6410.91	6406.14	6406.14	725.0
2017-04-12 20:00:00	NQ	Futures	6406.14	6410.01	6401.67	6402.56	2335.0
2017-04-12 21:00:00	NQ	Futures	6402.26	6409.12	6392.72	6402.56	4509.0
2017-04-12 22:00:00	NQ	Futures	6402.26	6407.63	6400.18	6403.75	1384.0
2017-04-12 23:00:00	NQ	Futures	6403.46	6408.82	6403.46	6407.33	1342.0
2017-04-12 00:00:00	YM	Futures	22344.4	22354.2	22342.3	22344.4	541.0
2017-04-12 01:00:00	YM	Futures	22344.4	22367.2	22337.9	22365.1	1388.0
2017-04-12 02:00:00	YM	Futures	22366.2	22384.6	22358.6	22380.3	1701.0
2017-04-12 03:00:00	YM	Futures	22381.4	22430.3	22367.2	22416.2	5812.0

> showing 50 of 1,638 rows — these rows as CSV

> unlock the full archive -- $79 one-time