PREVIEW / futures_1hour / 2017-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-27.parquet
  size:    52 KB
  rows:    1,651

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-27 00:00:00	ES	Futures	2584.21	2584.49	2581.49	2582.3	5134.0
2017-02-27 01:00:00	ES	Futures	2582.58	2582.85	2580.94	2582.03	2644.0
2017-02-27 02:00:00	ES	Futures	2582.03	2584.49	2580.94	2583.94	7812.0
2017-02-27 03:00:00	ES	Futures	2583.94	2585.85	2582.58	2582.58	37027.0
2017-02-27 04:00:00	ES	Futures	2582.58	2583.94	2579.85	2580.67	27933.0
2017-02-27 05:00:00	ES	Futures	2580.39	2580.94	2578.76	2579.85	15236.0
2017-02-27 06:00:00	ES	Futures	2580.12	2580.94	2579.03	2580.12	11593.0
2017-02-27 07:00:00	ES	Futures	2580.39	2580.67	2578.21	2579.03	15449.0
2017-02-27 08:00:00	ES	Futures	2579.03	2579.85	2577.39	2578.76	26387.0
2017-02-27 09:00:00	ES	Futures	2578.76	2581.49	2576.03	2581.21	154624.0
2017-02-27 10:00:00	ES	Futures	2581.49	2584.21	2577.12	2581.49	197375.0
2017-02-27 11:00:00	ES	Futures	2581.49	2583.67	2579.58	2579.85	93412.0
2017-02-27 12:00:00	ES	Futures	2579.85	2582.3	2579.03	2580.12	64004.0
2017-02-27 13:00:00	ES	Futures	2580.39	2584.21	2580.12	2583.12	77644.0
2017-02-27 14:00:00	ES	Futures	2583.12	2585.58	2582.3	2584.49	79090.0
2017-02-27 15:00:00	ES	Futures	2584.76	2586.67	2583.67	2584.49	188717.0
2017-02-27 16:00:00	ES	Futures	2584.76	2585.03	2580.12	2580.94	89716.0
2017-02-27 18:00:00	ES	Futures	2581.21	2582.3	2580.94	2581.21	4914.0
2017-02-27 19:00:00	ES	Futures	2581.49	2582.58	2581.21	2581.49	4496.0
2017-02-27 20:00:00	ES	Futures	2581.49	2583.39	2581.49	2582.85	4724.0
2017-02-27 21:00:00	ES	Futures	2582.85	2582.85	2582.3	2582.3	561.0
2017-02-27 22:00:00	ES	Futures	2582.58	2583.39	2582.3	2583.39	1528.0
2017-02-27 23:00:00	ES	Futures	2583.39	2584.21	2583.39	2583.94	2780.0
2017-02-27 00:00:00	NQ	Futures	6383.75	6384.34	6375.39	6378.67	1150.0
2017-02-27 01:00:00	NQ	Futures	6378.67	6378.97	6374.8	6378.38	669.0
2017-02-27 02:00:00	NQ	Futures	6378.08	6382.55	6375.09	6380.76	1701.0
2017-02-27 03:00:00	NQ	Futures	6381.06	6384.64	6375.69	6375.69	3188.0
2017-02-27 04:00:00	NQ	Futures	6375.99	6379.87	6368.53	6370.02	3174.0
2017-02-27 05:00:00	NQ	Futures	6370.02	6371.81	6365.55	6368.23	1671.0
2017-02-27 06:00:00	NQ	Futures	6367.94	6372.41	6366.15	6370.02	1717.0
2017-02-27 07:00:00	NQ	Futures	6370.32	6370.92	6364.36	6366.44	1918.0
2017-02-27 08:00:00	NQ	Futures	6366.44	6366.74	6361.37	6362.57	4605.0
2017-02-27 09:00:00	NQ	Futures	6362.86	6367.34	6352.12	6367.34	25222.0
2017-02-27 10:00:00	NQ	Futures	6367.04	6370.32	6355.7	6365.85	26958.0
2017-02-27 11:00:00	NQ	Futures	6366.15	6374.5	6366.15	6367.04	16281.0
2017-02-27 12:00:00	NQ	Futures	6366.74	6370.92	6365.25	6365.85	10284.0
2017-02-27 13:00:00	NQ	Futures	6366.15	6374.8	6365.55	6374.2	10208.0
2017-02-27 14:00:00	NQ	Futures	6374.2	6378.08	6371.51	6375.69	10171.0
2017-02-27 15:00:00	NQ	Futures	6375.69	6382.85	6375.09	6382.25	20464.0
2017-02-27 16:00:00	NQ	Futures	6382.25	6382.55	6374.2	6376.59	4147.0
2017-02-27 18:00:00	NQ	Futures	6378.08	6379.57	6376.29	6377.48	918.0
2017-02-27 19:00:00	NQ	Futures	6377.78	6379.57	6375.39	6377.78	978.0
2017-02-27 20:00:00	NQ	Futures	6377.48	6381.36	6377.18	6378.38	1243.0
2017-02-27 21:00:00	NQ	Futures	6378.38	6378.67	6376.59	6377.48	273.0
2017-02-27 22:00:00	NQ	Futures	6377.78	6381.06	6377.48	6380.76	404.0
2017-02-27 23:00:00	NQ	Futures	6380.76	6383.45	6380.76	6381.06	780.0
2017-02-27 00:00:00	YM	Futures	22580.5	22580.5	22552.3	22559.9	1504.0
2017-02-27 01:00:00	YM	Futures	22559.9	22563.1	22549.0	22557.7	845.0
2017-02-27 02:00:00	YM	Futures	22557.7	22580.5	22549.0	22576.1	2089.0
2017-02-27 03:00:00	YM	Futures	22577.2	22588.1	22558.8	22559.9	3934.0

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

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