PREVIEW / futures_1hour / 2017-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-10.parquet
  size:    52 KB
  rows:    1,599

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-10 00:00:00	ES	Futures	2574.92	2576.28	2574.65	2575.47	3145.0
2017-04-10 01:00:00	ES	Futures	2575.47	2576.01	2573.83	2574.37	3467.0
2017-04-10 02:00:00	ES	Futures	2574.37	2574.65	2573.28	2573.55	6822.0
2017-04-10 03:00:00	ES	Futures	2573.55	2573.83	2571.37	2572.19	21845.0
2017-04-10 04:00:00	ES	Futures	2572.19	2573.55	2571.37	2571.91	9296.0
2017-04-10 05:00:00	ES	Futures	2571.64	2572.46	2568.36	2568.36	10619.0
2017-04-10 06:00:00	ES	Futures	2568.36	2570.82	2567.27	2570.0	11033.0
2017-04-10 07:00:00	ES	Futures	2570.28	2573.55	2570.0	2572.73	12491.0
2017-04-10 08:00:00	ES	Futures	2572.73	2573.55	2570.28	2570.28	14233.0
2017-04-10 09:00:00	ES	Futures	2570.55	2578.74	2570.28	2578.74	134590.0
2017-04-10 10:00:00	ES	Futures	2578.47	2582.02	2576.83	2577.1	161267.0
2017-04-10 11:00:00	ES	Futures	2577.1	2579.02	2568.36	2570.82	187863.0
2017-04-10 12:00:00	ES	Futures	2571.09	2575.74	2564.81	2575.47	188602.0
2017-04-10 13:00:00	ES	Futures	2575.19	2578.47	2574.37	2576.83	98921.0
2017-04-10 14:00:00	ES	Futures	2576.56	2577.65	2572.46	2576.56	122022.0
2017-04-10 15:00:00	ES	Futures	2576.83	2578.74	2569.46	2571.64	244714.0
2017-04-10 16:00:00	ES	Futures	2571.37	2572.19	2568.64	2572.19	72730.0
2017-04-10 18:00:00	ES	Futures	2572.19	2573.83	2571.37	2572.73	3972.0
2017-04-10 19:00:00	ES	Futures	2572.73	2572.73	2570.55	2570.82	2646.0
2017-04-10 20:00:00	ES	Futures	2570.55	2572.19	2568.91	2570.82	8400.0
2017-04-10 21:00:00	ES	Futures	2570.55	2571.91	2570.28	2570.55	5742.0
2017-04-10 22:00:00	ES	Futures	2570.55	2570.82	2564.81	2566.45	12424.0
2017-04-10 23:00:00	ES	Futures	2566.45	2568.36	2565.63	2567.82	5063.0
2017-04-10 00:00:00	NQ	Futures	6473.52	6476.2	6472.92	6475.01	624.0
2017-04-10 01:00:00	NQ	Futures	6475.01	6475.9	6471.13	6472.92	688.0
2017-04-10 02:00:00	NQ	Futures	6472.33	6475.61	6471.13	6473.22	1195.0
2017-04-10 03:00:00	NQ	Futures	6472.92	6473.52	6466.96	6468.15	3064.0
2017-04-10 04:00:00	NQ	Futures	6468.15	6472.92	6465.47	6467.56	1456.0
2017-04-10 05:00:00	NQ	Futures	6467.56	6469.05	6461.0	6461.29	1321.0
2017-04-10 06:00:00	NQ	Futures	6461.29	6467.26	6458.61	6464.57	1642.0
2017-04-10 07:00:00	NQ	Futures	6464.57	6472.62	6464.57	6470.83	2211.0
2017-04-10 08:00:00	NQ	Futures	6470.54	6472.03	6465.17	6465.17	2133.0
2017-04-10 09:00:00	NQ	Futures	6465.17	6486.04	6464.87	6483.65	24349.0
2017-04-10 10:00:00	NQ	Futures	6483.36	6492.0	6474.71	6475.9	27857.0
2017-04-10 11:00:00	NQ	Futures	6475.61	6481.27	6456.23	6461.89	28024.0
2017-04-10 12:00:00	NQ	Futures	6461.89	6476.8	6446.69	6475.31	28465.0
2017-04-10 13:00:00	NQ	Futures	6475.31	6484.85	6474.11	6479.78	18103.0
2017-04-10 14:00:00	NQ	Futures	6479.78	6480.38	6466.36	6477.99	18636.0
2017-04-10 15:00:00	NQ	Futures	6477.69	6483.06	6461.0	6466.66	25340.0
2017-04-10 16:00:00	NQ	Futures	6466.66	6471.73	6460.1	6471.43	5517.0
2017-04-10 18:00:00	NQ	Futures	6471.73	6474.71	6469.05	6471.73	985.0
2017-04-10 19:00:00	NQ	Futures	6472.33	6473.22	6465.47	6466.66	718.0
2017-04-10 20:00:00	NQ	Futures	6466.36	6471.43	6462.19	6466.96	2064.0
2017-04-10 21:00:00	NQ	Futures	6466.66	6470.83	6466.06	6466.36	1163.0
2017-04-10 22:00:00	NQ	Futures	6466.36	6466.36	6453.24	6455.93	2829.0
2017-04-10 23:00:00	NQ	Futures	6455.93	6461.0	6453.84	6459.8	2055.0
2017-04-10 00:00:00	YM	Futures	22429.2	22434.6	22425.9	22430.3	614.0
2017-04-10 01:00:00	YM	Futures	22429.2	22433.5	22416.2	22421.6	818.0
2017-04-10 02:00:00	YM	Futures	22421.6	22422.7	22406.4	22410.7	1256.0
2017-04-10 03:00:00	YM	Futures	22410.7	22415.1	22395.5	22405.3	2629.0

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

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