PREVIEW / futures_1hour / 2016-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-15.parquet
  size:    51 KB
  rows:    1,587

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-15 00:00:00	ES	Futures	2368.81	2368.81	2368.0	2368.54	1667.0
2016-08-15 01:00:00	ES	Futures	2368.54	2369.08	2368.0	2368.0	1815.0
2016-08-15 02:00:00	ES	Futures	2368.0	2369.08	2368.0	2368.27	5200.0
2016-08-15 03:00:00	ES	Futures	2368.54	2370.98	2366.92	2369.9	17302.0
2016-08-15 04:00:00	ES	Futures	2369.63	2370.44	2368.0	2368.27	7173.0
2016-08-15 05:00:00	ES	Futures	2368.0	2368.81	2367.73	2368.27	14975.0
2016-08-15 06:00:00	ES	Futures	2368.27	2369.08	2368.0	2368.81	5395.0
2016-08-15 07:00:00	ES	Futures	2368.81	2369.9	2368.54	2369.63	16042.0
2016-08-15 08:00:00	ES	Futures	2369.36	2370.98	2368.81	2369.9	22022.0
2016-08-15 09:00:00	ES	Futures	2369.9	2373.69	2369.63	2371.8	199325.0
2016-08-15 10:00:00	ES	Futures	2372.07	2376.14	2371.53	2375.32	195612.0
2016-08-15 11:00:00	ES	Futures	2375.32	2376.41	2374.51	2374.78	118809.0
2016-08-15 12:00:00	ES	Futures	2374.78	2376.41	2374.51	2375.05	83663.0
2016-08-15 13:00:00	ES	Futures	2375.32	2376.14	2374.24	2374.78	71275.0
2016-08-15 14:00:00	ES	Futures	2375.05	2375.86	2373.97	2375.05	75061.0
2016-08-15 15:00:00	ES	Futures	2375.32	2375.59	2371.8	2372.34	167588.0
2016-08-15 16:00:00	ES	Futures	2372.34	2372.34	2370.71	2370.71	57147.0
2016-08-15 18:00:00	ES	Futures	2371.25	2371.53	2370.17	2370.71	3461.0
2016-08-15 19:00:00	ES	Futures	2370.71	2370.98	2370.17	2370.17	2160.0
2016-08-15 20:00:00	ES	Futures	2370.17	2370.98	2369.36	2369.36	6713.0
2016-08-15 21:00:00	ES	Futures	2369.36	2370.44	2368.27	2368.27	6114.0
2016-08-15 22:00:00	ES	Futures	2368.27	2368.81	2368.0	2368.27	3604.0
2016-08-15 23:00:00	ES	Futures	2368.27	2369.08	2368.0	2368.54	3284.0
2016-08-15 00:00:00	NQ	Futures	5737.49	5738.09	5736.0	5736.9	230.0
2016-08-15 01:00:00	NQ	Futures	5737.19	5738.09	5736.6	5736.9	171.0
2016-08-15 02:00:00	NQ	Futures	5736.9	5738.68	5735.7	5736.3	614.0
2016-08-15 03:00:00	NQ	Futures	5736.6	5744.65	5733.32	5741.96	2410.0
2016-08-15 04:00:00	NQ	Futures	5742.26	5743.75	5737.19	5737.19	1442.0
2016-08-15 05:00:00	NQ	Futures	5737.49	5738.68	5735.7	5738.39	1236.0
2016-08-15 06:00:00	NQ	Futures	5738.09	5740.18	5737.79	5738.39	697.0
2016-08-15 07:00:00	NQ	Futures	5738.39	5739.88	5737.79	5738.98	1227.0
2016-08-15 08:00:00	NQ	Futures	5738.98	5740.47	5736.9	5737.19	2186.0
2016-08-15 09:00:00	NQ	Futures	5737.49	5753.89	5731.83	5748.22	31951.0
2016-08-15 10:00:00	NQ	Futures	5748.22	5760.14	5746.43	5757.76	21894.0
2016-08-15 11:00:00	NQ	Futures	5757.76	5763.72	5756.87	5759.25	13831.0
2016-08-15 12:00:00	NQ	Futures	5759.25	5762.83	5757.76	5761.63	8470.0
2016-08-15 13:00:00	NQ	Futures	5761.63	5764.62	5758.06	5759.55	8456.0
2016-08-15 14:00:00	NQ	Futures	5759.55	5760.44	5755.97	5757.76	8688.0
2016-08-15 15:00:00	NQ	Futures	5757.76	5758.65	5750.31	5751.5	17569.0
2016-08-15 16:00:00	NQ	Futures	5751.2	5752.99	5747.92	5750.01	4460.0
2016-08-15 18:00:00	NQ	Futures	5749.71	5751.8	5749.12	5751.5	643.0
2016-08-15 19:00:00	NQ	Futures	5751.2	5751.8	5749.12	5749.71	535.0
2016-08-15 20:00:00	NQ	Futures	5749.71	5750.31	5746.73	5747.33	1124.0
2016-08-15 21:00:00	NQ	Futures	5747.03	5749.71	5742.86	5743.16	1302.0
2016-08-15 22:00:00	NQ	Futures	5743.16	5745.54	5743.16	5743.75	631.0
2016-08-15 23:00:00	NQ	Futures	5743.75	5744.94	5743.45	5744.35	386.0
2016-08-15 00:00:00	YM	Futures	19973.3	19974.4	19970.1	19971.1	334.0
2016-08-15 01:00:00	YM	Futures	19971.1	19976.5	19970.1	19971.1	315.0
2016-08-15 02:00:00	YM	Futures	19970.1	19976.5	19967.9	19969.0	858.0
2016-08-15 03:00:00	YM	Futures	19967.9	19993.7	19958.2	19981.9	2546.0

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

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