PREVIEW / futures_1hour / 2017-02-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-28.parquet
  size:    55 KB
  rows:    1,648

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-02-28 00:00:00	ES	Futures	2583.67	2583.94	2582.03	2582.03	4594.0
2017-02-28 01:00:00	ES	Futures	2582.03	2582.3	2581.21	2581.76	3159.0
2017-02-28 02:00:00	ES	Futures	2581.76	2583.67	2581.49	2583.12	4400.0
2017-02-28 03:00:00	ES	Futures	2582.85	2583.67	2581.49	2582.85	20308.0
2017-02-28 04:00:00	ES	Futures	2583.12	2584.21	2581.49	2583.39	19685.0
2017-02-28 05:00:00	ES	Futures	2583.39	2584.49	2582.03	2582.58	12270.0
2017-02-28 06:00:00	ES	Futures	2582.58	2584.49	2582.58	2583.67	13150.0
2017-02-28 07:00:00	ES	Futures	2583.67	2583.67	2581.21	2581.49	11689.0
2017-02-28 08:00:00	ES	Futures	2581.76	2582.03	2580.39	2581.76	23961.0
2017-02-28 09:00:00	ES	Futures	2582.03	2582.03	2578.76	2579.85	137801.0
2017-02-28 10:00:00	ES	Futures	2579.85	2582.58	2579.3	2582.03	138706.0
2017-02-28 11:00:00	ES	Futures	2582.3	2582.58	2580.39	2580.94	95646.0
2017-02-28 12:00:00	ES	Futures	2580.94	2580.94	2572.21	2576.3	187331.0
2017-02-28 13:00:00	ES	Futures	2576.58	2579.03	2575.76	2579.03	131236.0
2017-02-28 14:00:00	ES	Futures	2579.03	2579.3	2574.67	2577.39	144499.0
2017-02-28 15:00:00	ES	Futures	2577.67	2579.85	2573.85	2577.67	388167.0
2017-02-28 16:00:00	ES	Futures	2577.94	2580.39	2575.76	2580.12	188214.0
2017-02-28 17:00:00	ES	Futures	2580.39	2580.39	2580.39	2580.39	12.0
2017-02-28 18:00:00	ES	Futures	2579.85	2581.21	2578.48	2580.12	14538.0
2017-02-28 19:00:00	ES	Futures	2580.39	2582.85	2579.85	2582.58	9703.0
2017-02-28 20:00:00	ES	Futures	2582.58	2588.85	2582.03	2586.4	25470.0
2017-02-28 21:00:00	ES	Futures	2586.67	2588.3	2581.49	2583.39	30350.0
2017-02-28 22:00:00	ES	Futures	2583.39	2585.03	2581.76	2582.85	10386.0
2017-02-28 23:00:00	ES	Futures	2582.85	2585.3	2582.85	2583.67	6152.0
2017-02-28 00:00:00	NQ	Futures	6381.36	6381.66	6376.59	6376.59	830.0
2017-02-28 01:00:00	NQ	Futures	6376.59	6377.48	6373.9	6374.5	1146.0
2017-02-28 02:00:00	NQ	Futures	6374.8	6378.97	6374.8	6376.88	1038.0
2017-02-28 03:00:00	NQ	Futures	6377.18	6378.97	6374.2	6376.59	2173.0
2017-02-28 04:00:00	NQ	Futures	6376.59	6379.57	6373.01	6378.08	1604.0
2017-02-28 05:00:00	NQ	Futures	6378.38	6380.76	6375.69	6377.18	1506.0
2017-02-28 06:00:00	NQ	Futures	6377.48	6382.85	6377.48	6381.66	1622.0
2017-02-28 07:00:00	NQ	Futures	6381.36	6383.15	6379.87	6380.46	1650.0
2017-02-28 08:00:00	NQ	Futures	6380.46	6382.55	6378.08	6381.36	3237.0
2017-02-28 09:00:00	NQ	Futures	6381.36	6384.04	6370.32	6373.01	22596.0
2017-02-28 10:00:00	NQ	Futures	6373.01	6376.88	6367.04	6373.9	19503.0
2017-02-28 11:00:00	NQ	Futures	6374.2	6378.38	6370.32	6370.92	13649.0
2017-02-28 12:00:00	NQ	Futures	6370.62	6371.51	6344.67	6356.0	25919.0
2017-02-28 13:00:00	NQ	Futures	6356.0	6364.65	6354.81	6364.65	14716.0
2017-02-28 14:00:00	NQ	Futures	6364.36	6365.85	6354.81	6360.78	15031.0
2017-02-28 15:00:00	NQ	Futures	6360.78	6365.55	6350.93	6362.57	30338.0
2017-02-28 16:00:00	NQ	Futures	6362.86	6367.94	6360.18	6367.94	6349.0
2017-02-28 18:00:00	NQ	Futures	6365.55	6368.23	6362.57	6363.46	1935.0
2017-02-28 19:00:00	NQ	Futures	6363.46	6373.6	6363.46	6372.11	2127.0
2017-02-28 20:00:00	NQ	Futures	6371.81	6384.34	6371.22	6378.08	5606.0
2017-02-28 21:00:00	NQ	Futures	6378.08	6382.25	6364.95	6368.23	7509.0
2017-02-28 22:00:00	NQ	Futures	6367.94	6372.71	6365.25	6368.23	2076.0
2017-02-28 23:00:00	NQ	Futures	6368.53	6375.09	6368.53	6371.81	1496.0
2017-02-28 00:00:00	YM	Futures	22585.9	22588.1	22575.1	22575.1	858.0
2017-02-28 01:00:00	YM	Futures	22574.0	22577.2	22570.7	22574.0	1031.0
2017-02-28 02:00:00	YM	Futures	22574.0	22587.0	22572.9	22582.7	1062.0

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

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