PREVIEW / futures_1hour / 2016-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-18.parquet
  size:    52 KB
  rows:    1,613

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-18 00:00:00	ES	Futures	2366.92	2366.92	2365.83	2366.64	2296.0
2016-08-18 01:00:00	ES	Futures	2366.64	2367.46	2365.29	2365.83	3843.0
2016-08-18 02:00:00	ES	Futures	2366.1	2367.19	2365.29	2366.64	8847.0
2016-08-18 03:00:00	ES	Futures	2366.37	2367.73	2364.2	2364.75	18936.0
2016-08-18 04:00:00	ES	Futures	2364.75	2365.83	2364.47	2365.02	12970.0
2016-08-18 05:00:00	ES	Futures	2364.75	2366.1	2363.39	2363.39	10137.0
2016-08-18 06:00:00	ES	Futures	2363.66	2364.75	2363.39	2363.93	9760.0
2016-08-18 07:00:00	ES	Futures	2363.66	2364.2	2360.68	2361.22	20922.0
2016-08-18 08:00:00	ES	Futures	2361.22	2362.85	2360.68	2362.03	24473.0
2016-08-18 09:00:00	ES	Futures	2362.03	2366.64	2361.76	2365.02	194298.0
2016-08-18 10:00:00	ES	Futures	2365.02	2369.36	2363.93	2368.81	204378.0
2016-08-18 11:00:00	ES	Futures	2369.08	2369.08	2366.1	2366.37	121711.0
2016-08-18 12:00:00	ES	Futures	2366.64	2366.64	2362.58	2363.93	119220.0
2016-08-18 13:00:00	ES	Futures	2364.2	2367.46	2363.93	2366.37	85792.0
2016-08-18 14:00:00	ES	Futures	2366.37	2367.46	2365.02	2366.37	83337.0
2016-08-18 15:00:00	ES	Futures	2366.37	2369.63	2366.37	2369.36	182608.0
2016-08-18 16:00:00	ES	Futures	2369.36	2369.63	2368.0	2368.0	60928.0
2016-08-18 18:00:00	ES	Futures	2368.54	2369.36	2368.27	2368.81	2275.0
2016-08-18 19:00:00	ES	Futures	2368.81	2369.36	2368.27	2368.81	1132.0
2016-08-18 20:00:00	ES	Futures	2368.81	2369.08	2367.73	2368.27	3709.0
2016-08-18 21:00:00	ES	Futures	2368.54	2369.36	2366.92	2367.46	5723.0
2016-08-18 22:00:00	ES	Futures	2367.19	2367.46	2366.1	2366.92	7061.0
2016-08-18 23:00:00	ES	Futures	2367.19	2368.0	2366.37	2367.73	2660.0
2016-08-18 00:00:00	NQ	Futures	5735.7	5736.0	5733.62	5735.7	388.0
2016-08-18 01:00:00	NQ	Futures	5735.41	5736.9	5732.43	5732.43	609.0
2016-08-18 02:00:00	NQ	Futures	5733.02	5735.11	5730.64	5733.92	1081.0
2016-08-18 03:00:00	NQ	Futures	5733.32	5736.3	5724.38	5724.97	3985.0
2016-08-18 04:00:00	NQ	Futures	5725.57	5729.15	5724.08	5725.27	1994.0
2016-08-18 05:00:00	NQ	Futures	5725.27	5728.25	5720.5	5721.4	1195.0
2016-08-18 06:00:00	NQ	Futures	5721.7	5724.97	5721.4	5722.89	799.0
2016-08-18 07:00:00	NQ	Futures	5723.19	5724.08	5715.14	5717.52	1904.0
2016-08-18 08:00:00	NQ	Futures	5717.23	5722.59	5714.84	5720.8	3500.0
2016-08-18 09:00:00	NQ	Futures	5720.8	5733.92	5717.23	5728.85	30276.0
2016-08-18 10:00:00	NQ	Futures	5728.55	5739.28	5725.87	5737.79	25747.0
2016-08-18 11:00:00	NQ	Futures	5738.09	5738.39	5730.64	5732.43	15325.0
2016-08-18 12:00:00	NQ	Futures	5732.43	5733.02	5713.95	5721.7	17107.0
2016-08-18 13:00:00	NQ	Futures	5721.4	5733.92	5721.4	5730.64	10217.0
2016-08-18 14:00:00	NQ	Futures	5730.34	5731.83	5726.46	5730.64	9156.0
2016-08-18 15:00:00	NQ	Futures	5730.94	5736.0	5727.66	5731.53	15420.0
2016-08-18 16:00:00	NQ	Futures	5731.53	5734.81	5730.64	5731.83	4353.0
2016-08-18 18:00:00	NQ	Futures	5732.13	5734.51	5730.34	5732.43	596.0
2016-08-18 19:00:00	NQ	Futures	5732.43	5735.11	5731.83	5733.62	189.0
2016-08-18 20:00:00	NQ	Futures	5733.32	5733.32	5730.64	5732.72	378.0
2016-08-18 21:00:00	NQ	Futures	5733.02	5736.0	5727.66	5727.66	980.0
2016-08-18 22:00:00	NQ	Futures	5727.66	5728.85	5723.78	5725.57	1666.0
2016-08-18 23:00:00	NQ	Futures	5725.27	5729.15	5724.08	5727.66	427.0
2016-08-18 00:00:00	YM	Futures	19974.4	19975.4	19969.0	19973.3	336.0
2016-08-18 01:00:00	YM	Futures	19973.3	19979.7	19962.5	19964.7	576.0
2016-08-18 02:00:00	YM	Futures	19965.8	19973.3	19959.3	19971.1	1642.0
2016-08-18 03:00:00	YM	Futures	19970.1	19980.8	19953.9	19960.4	1891.0

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

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