PREVIEW / futures_1hour / 2016-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-31.parquet
  size:    50 KB
  rows:    1,600

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-31 00:00:00	ES	Futures	2359.59	2360.41	2359.32	2360.41	2075.0
2016-08-31 01:00:00	ES	Futures	2360.41	2360.41	2358.24	2359.05	4207.0
2016-08-31 02:00:00	ES	Futures	2358.78	2359.32	2356.61	2357.42	8466.0
2016-08-31 03:00:00	ES	Futures	2357.42	2360.41	2356.88	2360.14	23153.0
2016-08-31 04:00:00	ES	Futures	2360.14	2360.41	2358.51	2358.51	12481.0
2016-08-31 05:00:00	ES	Futures	2358.78	2360.41	2358.51	2359.86	10290.0
2016-08-31 06:00:00	ES	Futures	2359.86	2359.86	2357.69	2359.05	9627.0
2016-08-31 07:00:00	ES	Futures	2358.78	2360.14	2358.78	2359.05	8695.0
2016-08-31 08:00:00	ES	Futures	2358.78	2359.32	2355.53	2356.34	26334.0
2016-08-31 09:00:00	ES	Futures	2356.34	2357.15	2353.36	2355.25	169845.0
2016-08-31 10:00:00	ES	Futures	2355.53	2356.61	2349.29	2349.56	250592.0
2016-08-31 11:00:00	ES	Futures	2349.29	2350.92	2348.2	2349.02	165312.0
2016-08-31 12:00:00	ES	Futures	2348.75	2349.02	2342.51	2345.22	258271.0
2016-08-31 13:00:00	ES	Futures	2345.22	2348.2	2343.32	2347.12	145633.0
2016-08-31 14:00:00	ES	Futures	2347.12	2351.46	2346.85	2347.93	188909.0
2016-08-31 15:00:00	ES	Futures	2347.93	2354.98	2347.66	2352.54	388443.0
2016-08-31 16:00:00	ES	Futures	2352.27	2354.98	2351.73	2352.27	128118.0
2016-08-31 18:00:00	ES	Futures	2352.81	2353.36	2352.27	2352.81	3057.0
2016-08-31 19:00:00	ES	Futures	2352.81	2353.9	2352.27	2353.08	2385.0
2016-08-31 20:00:00	ES	Futures	2353.08	2353.9	2352.27	2353.36	5268.0
2016-08-31 21:00:00	ES	Futures	2353.36	2353.9	2352.0	2353.36	6582.0
2016-08-31 22:00:00	ES	Futures	2353.63	2356.34	2353.36	2355.8	5176.0
2016-08-31 23:00:00	ES	Futures	2355.8	2358.24	2355.53	2357.97	6476.0
2016-08-31 00:00:00	NQ	Futures	5692.49	5694.57	5692.19	5693.68	456.0
2016-08-31 01:00:00	NQ	Futures	5693.98	5694.28	5688.91	5691.0	504.0
2016-08-31 02:00:00	NQ	Futures	5690.7	5691.29	5684.44	5686.82	1413.0
2016-08-31 03:00:00	NQ	Futures	5686.82	5696.06	5684.74	5694.87	3245.0
2016-08-31 04:00:00	NQ	Futures	5695.17	5695.77	5690.7	5691.59	1615.0
2016-08-31 05:00:00	NQ	Futures	5691.59	5695.77	5689.51	5693.68	1012.0
2016-08-31 06:00:00	NQ	Futures	5693.38	5693.68	5688.02	5692.19	1613.0
2016-08-31 07:00:00	NQ	Futures	5692.19	5696.36	5691.89	5694.28	1705.0
2016-08-31 08:00:00	NQ	Futures	5693.98	5694.28	5684.74	5686.23	3129.0
2016-08-31 09:00:00	NQ	Futures	5686.23	5693.98	5680.56	5691.59	29670.0
2016-08-31 10:00:00	NQ	Futures	5691.59	5695.17	5677.58	5683.25	28981.0
2016-08-31 11:00:00	NQ	Futures	5683.25	5689.21	5678.78	5684.74	18830.0
2016-08-31 12:00:00	NQ	Futures	5684.44	5684.44	5664.77	5674.9	28956.0
2016-08-31 13:00:00	NQ	Futures	5674.6	5682.05	5671.33	5678.48	12204.0
2016-08-31 14:00:00	NQ	Futures	5678.48	5688.91	5674.31	5676.69	17505.0
2016-08-31 15:00:00	NQ	Futures	5676.69	5694.57	5675.8	5688.91	35113.0
2016-08-31 16:00:00	NQ	Futures	5688.61	5694.87	5687.42	5688.91	8672.0
2016-08-31 18:00:00	NQ	Futures	5691.59	5692.78	5690.1	5691.29	898.0
2016-08-31 19:00:00	NQ	Futures	5691.59	5693.38	5689.51	5692.19	393.0
2016-08-31 20:00:00	NQ	Futures	5692.19	5694.57	5690.7	5693.68	693.0
2016-08-31 21:00:00	NQ	Futures	5693.38	5693.98	5688.91	5692.19	968.0
2016-08-31 22:00:00	NQ	Futures	5692.19	5699.34	5692.19	5698.15	917.0
2016-08-31 23:00:00	NQ	Futures	5697.85	5707.39	5697.55	5706.79	1369.0
2016-08-31 00:00:00	YM	Futures	19849.5	19856.0	19847.4	19852.8	403.0
2016-08-31 01:00:00	YM	Futures	19853.8	19853.8	19840.9	19846.3	545.0
2016-08-31 02:00:00	YM	Futures	19845.2	19846.3	19822.6	19830.2	1464.0
2016-08-31 03:00:00	YM	Futures	19830.2	19852.8	19824.8	19850.6	2708.0

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

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