PREVIEW / futures_1hour / 2016-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-25.parquet
  size:    49 KB
  rows:    1,556

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
2016-08-25 00:00:00	ES	Futures	2359.86	2359.86	2359.05	2359.32	1991.0
2016-08-25 01:00:00	ES	Futures	2359.59	2360.14	2358.78	2359.86	1954.0
2016-08-25 02:00:00	ES	Futures	2360.14	2360.41	2357.97	2358.78	6837.0
2016-08-25 03:00:00	ES	Futures	2359.05	2359.05	2355.25	2356.61	30464.0
2016-08-25 04:00:00	ES	Futures	2356.88	2356.88	2353.63	2354.17	24400.0
2016-08-25 05:00:00	ES	Futures	2354.17	2359.32	2353.63	2356.61	23489.0
2016-08-25 06:00:00	ES	Futures	2356.61	2357.15	2353.36	2354.44	17141.0
2016-08-25 07:00:00	ES	Futures	2354.44	2354.98	2352.81	2354.98	27610.0
2016-08-25 08:00:00	ES	Futures	2354.98	2355.53	2353.36	2353.63	26015.0
2016-08-25 09:00:00	ES	Futures	2353.36	2356.88	2351.46	2355.53	207769.0
2016-08-25 10:00:00	ES	Futures	2355.25	2359.05	2353.9	2357.97	221498.0
2016-08-25 11:00:00	ES	Futures	2357.69	2361.76	2357.69	2359.32	165198.0
2016-08-25 12:00:00	ES	Futures	2359.32	2360.14	2356.61	2359.05	92981.0
2016-08-25 13:00:00	ES	Futures	2359.05	2359.86	2353.36	2354.98	135355.0
2016-08-25 14:00:00	ES	Futures	2354.98	2356.07	2351.46	2352.54	179052.0
2016-08-25 15:00:00	ES	Futures	2352.27	2356.07	2351.19	2355.8	215417.0
2016-08-25 16:00:00	ES	Futures	2355.8	2358.78	2355.8	2358.78	86534.0
2016-08-25 18:00:00	ES	Futures	2358.24	2359.32	2357.97	2358.78	3448.0
2016-08-25 19:00:00	ES	Futures	2359.05	2359.32	2357.97	2358.78	2125.0
2016-08-25 20:00:00	ES	Futures	2358.78	2358.78	2357.15	2357.15	4209.0
2016-08-25 21:00:00	ES	Futures	2357.15	2359.05	2356.88	2358.78	4198.0
2016-08-25 22:00:00	ES	Futures	2359.05	2359.86	2358.24	2358.78	4659.0
2016-08-25 23:00:00	ES	Futures	2358.78	2359.32	2357.97	2358.51	2082.0
2016-08-25 00:00:00	NQ	Futures	5709.18	5709.18	5706.79	5707.69	414.0
2016-08-25 01:00:00	NQ	Futures	5707.69	5710.67	5706.2	5710.37	390.0
2016-08-25 02:00:00	NQ	Futures	5710.37	5710.97	5705.3	5708.88	1680.0
2016-08-25 03:00:00	NQ	Futures	5708.88	5708.88	5695.17	5699.04	4011.0
2016-08-25 04:00:00	NQ	Futures	5699.34	5699.64	5690.1	5692.19	3124.0
2016-08-25 05:00:00	NQ	Futures	5692.19	5704.71	5690.1	5696.96	2903.0
2016-08-25 06:00:00	NQ	Futures	5696.66	5699.04	5690.7	5693.08	1613.0
2016-08-25 07:00:00	NQ	Futures	5692.78	5695.77	5690.7	5694.87	2596.0
2016-08-25 08:00:00	NQ	Futures	5694.57	5697.85	5692.49	5693.68	3349.0
2016-08-25 09:00:00	NQ	Futures	5693.68	5702.02	5684.74	5694.57	34386.0
2016-08-25 10:00:00	NQ	Futures	5694.28	5705.9	5689.51	5701.73	29407.0
2016-08-25 11:00:00	NQ	Futures	5701.73	5715.44	5701.73	5708.88	22986.0
2016-08-25 12:00:00	NQ	Futures	5709.18	5712.16	5701.43	5708.58	10892.0
2016-08-25 13:00:00	NQ	Futures	5708.88	5712.16	5695.17	5698.75	16479.0
2016-08-25 14:00:00	NQ	Futures	5698.75	5701.13	5687.42	5689.51	21659.0
2016-08-25 15:00:00	NQ	Futures	5689.21	5699.04	5685.33	5695.77	24358.0
2016-08-25 16:00:00	NQ	Futures	5696.06	5703.22	5695.77	5702.92	5165.0
2016-08-25 18:00:00	NQ	Futures	5702.92	5705.0	5701.73	5702.92	474.0
2016-08-25 19:00:00	NQ	Futures	5703.22	5704.11	5699.94	5702.02	361.0
2016-08-25 20:00:00	NQ	Futures	5701.73	5701.73	5696.36	5697.26	928.0
2016-08-25 21:00:00	NQ	Futures	5697.55	5705.0	5696.96	5704.11	1096.0
2016-08-25 22:00:00	NQ	Futures	5704.71	5705.6	5702.02	5702.32	655.0
2016-08-25 23:00:00	NQ	Futures	5702.62	5704.11	5700.24	5702.92	445.0
2016-08-25 00:00:00	YM	Futures	19882.9	19884.0	19877.5	19881.8	271.0
2016-08-25 01:00:00	YM	Futures	19881.8	19888.3	19877.5	19888.3	406.0
2016-08-25 02:00:00	YM	Futures	19888.3	19890.4	19868.9	19875.4	1251.0
2016-08-25 03:00:00	YM	Futures	19875.4	19875.4	19843.1	19852.8	4119.0

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

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