PREVIEW / futures_1hour / 2017-04-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	2570.28	2570.55	2568.09	2569.73	6175.0
2017-04-04 01:00:00	ES	Futures	2569.73	2570.55	2568.36	2568.91	5775.0
2017-04-04 02:00:00	ES	Futures	2568.91	2569.18	2566.72	2567.54	10062.0
2017-04-04 03:00:00	ES	Futures	2567.54	2569.73	2564.81	2566.72	21993.0
2017-04-04 04:00:00	ES	Futures	2566.45	2567.82	2564.54	2566.18	10731.0
2017-04-04 05:00:00	ES	Futures	2566.18	2566.72	2564.81	2566.72	9451.0
2017-04-04 06:00:00	ES	Futures	2566.72	2569.46	2566.45	2568.91	11309.0
2017-04-04 07:00:00	ES	Futures	2568.64	2569.18	2562.63	2563.72	24439.0
2017-04-04 08:00:00	ES	Futures	2563.72	2565.63	2561.81	2565.63	29747.0
2017-04-04 09:00:00	ES	Futures	2565.63	2572.46	2565.63	2569.46	182222.0
2017-04-04 10:00:00	ES	Futures	2569.46	2570.28	2563.72	2567.27	215464.0
2017-04-04 11:00:00	ES	Futures	2567.27	2574.37	2566.72	2572.19	140011.0
2017-04-04 12:00:00	ES	Futures	2572.46	2573.28	2568.91	2569.73	101479.0
2017-04-04 13:00:00	ES	Futures	2569.73	2572.46	2568.09	2571.64	61002.0
2017-04-04 14:00:00	ES	Futures	2571.64	2574.65	2571.09	2571.37	87473.0
2017-04-04 15:00:00	ES	Futures	2571.37	2575.19	2569.73	2574.37	189678.0
2017-04-04 16:00:00	ES	Futures	2574.37	2577.1	2574.1	2577.1	67376.0
2017-04-04 18:00:00	ES	Futures	2577.1	2578.2	2576.83	2576.83	4430.0
2017-04-04 19:00:00	ES	Futures	2577.1	2577.38	2576.83	2576.83	1666.0
2017-04-04 20:00:00	ES	Futures	2576.83	2577.1	2575.19	2575.47	5585.0
2017-04-04 21:00:00	ES	Futures	2575.47	2576.56	2574.1	2574.92	6566.0
2017-04-04 22:00:00	ES	Futures	2574.92	2575.19	2573.55	2573.83	4749.0
2017-04-04 23:00:00	ES	Futures	2573.83	2573.83	2570.55	2571.37	5627.0
2017-04-04 00:00:00	NQ	Futures	6474.41	6475.31	6467.85	6473.82	1925.0
2017-04-04 01:00:00	NQ	Futures	6473.52	6475.31	6469.94	6472.33	1040.0
2017-04-04 02:00:00	NQ	Futures	6472.62	6472.62	6466.96	6468.45	1873.0
2017-04-04 03:00:00	NQ	Futures	6468.45	6473.52	6461.29	6465.77	4281.0
2017-04-04 04:00:00	NQ	Futures	6465.47	6466.36	6459.8	6462.49	2543.0
2017-04-04 05:00:00	NQ	Futures	6462.49	6463.08	6458.01	6461.29	2092.0
2017-04-04 06:00:00	NQ	Futures	6461.59	6467.85	6460.4	6465.47	2020.0
2017-04-04 07:00:00	NQ	Futures	6465.47	6466.66	6451.75	6453.54	3618.0
2017-04-04 08:00:00	NQ	Futures	6453.24	6455.33	6447.88	6455.33	6664.0
2017-04-04 09:00:00	NQ	Futures	6455.03	6482.16	6455.03	6472.03	36192.0
2017-04-04 10:00:00	NQ	Futures	6472.03	6476.8	6458.31	6466.06	34859.0
2017-04-04 11:00:00	NQ	Futures	6466.06	6483.65	6464.57	6475.61	24012.0
2017-04-04 12:00:00	NQ	Futures	6475.61	6480.67	6470.83	6472.33	17549.0
2017-04-04 13:00:00	NQ	Futures	6472.33	6481.27	6468.15	6477.39	11591.0
2017-04-04 14:00:00	NQ	Futures	6477.39	6486.93	6477.1	6479.78	12876.0
2017-04-04 15:00:00	NQ	Futures	6480.08	6490.81	6477.99	6489.62	20763.0
2017-04-04 16:00:00	NQ	Futures	6489.02	6497.07	6488.43	6496.47	5231.0
2017-04-04 18:00:00	NQ	Futures	6495.88	6497.07	6493.79	6495.28	876.0
2017-04-04 19:00:00	NQ	Futures	6495.28	6496.18	6494.39	6494.39	345.0
2017-04-04 20:00:00	NQ	Futures	6494.39	6495.88	6491.7	6492.6	1027.0
2017-04-04 21:00:00	NQ	Futures	6492.9	6496.18	6490.51	6492.6	1217.0
2017-04-04 22:00:00	NQ	Futures	6492.9	6493.49	6489.32	6490.51	1192.0
2017-04-04 23:00:00	NQ	Futures	6490.21	6490.81	6483.06	6484.25	1338.0
2017-04-04 00:00:00	YM	Futures	22344.4	22345.5	22324.9	22337.9	1276.0
2017-04-04 01:00:00	YM	Futures	22336.8	22344.4	22327.0	22334.6	1098.0
2017-04-04 02:00:00	YM	Futures	22335.7	22335.7	22319.4	22326.0	1979.0
2017-04-04 03:00:00	YM	Futures	22324.9	22342.3	22302.0	22317.3	4337.0

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

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