PREVIEW / futures_1hour / 2016-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-16.parquet
  size:    53 KB
  rows:    1,608

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-16 00:00:00	ES	Futures	2368.81	2369.36	2368.27	2369.08	2078.0
2016-08-16 01:00:00	ES	Futures	2369.08	2369.36	2368.0	2368.0	5184.0
2016-08-16 02:00:00	ES	Futures	2368.27	2369.36	2368.0	2368.81	7822.0
2016-08-16 03:00:00	ES	Futures	2369.08	2369.08	2365.83	2367.19	26977.0
2016-08-16 04:00:00	ES	Futures	2367.19	2368.0	2365.83	2366.64	13289.0
2016-08-16 05:00:00	ES	Futures	2366.92	2371.25	2366.64	2370.17	19452.0
2016-08-16 06:00:00	ES	Futures	2370.17	2370.17	2366.64	2368.81	15575.0
2016-08-16 07:00:00	ES	Futures	2369.08	2369.63	2366.92	2367.46	12897.0
2016-08-16 08:00:00	ES	Futures	2367.73	2368.0	2365.02	2366.37	45408.0
2016-08-16 09:00:00	ES	Futures	2366.37	2367.19	2361.49	2364.2	216218.0
2016-08-16 10:00:00	ES	Futures	2364.2	2367.46	2362.3	2363.39	223045.0
2016-08-16 11:00:00	ES	Futures	2363.12	2366.92	2362.85	2365.02	130397.0
2016-08-16 12:00:00	ES	Futures	2365.29	2366.37	2363.39	2366.1	74992.0
2016-08-16 13:00:00	ES	Futures	2366.1	2366.37	2361.76	2362.85	115099.0
2016-08-16 14:00:00	ES	Futures	2362.85	2364.75	2360.68	2364.2	155074.0
2016-08-16 15:00:00	ES	Futures	2364.2	2364.47	2359.59	2359.59	199226.0
2016-08-16 16:00:00	ES	Futures	2359.59	2363.12	2359.59	2362.85	98324.0
2016-08-16 18:00:00	ES	Futures	2362.03	2363.12	2361.76	2362.03	4239.0
2016-08-16 19:00:00	ES	Futures	2362.3	2363.39	2362.03	2362.85	1837.0
2016-08-16 20:00:00	ES	Futures	2362.85	2364.75	2362.85	2363.66	5780.0
2016-08-16 21:00:00	ES	Futures	2363.66	2364.2	2362.85	2363.66	4663.0
2016-08-16 22:00:00	ES	Futures	2363.66	2363.93	2362.85	2363.39	2361.0
2016-08-16 23:00:00	ES	Futures	2363.39	2363.66	2362.85	2363.12	1901.0
2016-08-16 00:00:00	NQ	Futures	5744.35	5746.73	5744.05	5746.14	253.0
2016-08-16 01:00:00	NQ	Futures	5746.14	5746.14	5743.75	5744.05	349.0
2016-08-16 02:00:00	NQ	Futures	5743.75	5744.94	5743.16	5744.05	1234.0
2016-08-16 03:00:00	NQ	Futures	5744.05	5744.65	5736.3	5742.56	3523.0
2016-08-16 04:00:00	NQ	Futures	5742.86	5743.45	5738.09	5739.88	1895.0
2016-08-16 05:00:00	NQ	Futures	5739.88	5751.8	5739.88	5749.12	2226.0
2016-08-16 06:00:00	NQ	Futures	5748.82	5748.82	5740.77	5746.14	1599.0
2016-08-16 07:00:00	NQ	Futures	5745.84	5747.03	5740.18	5740.77	1397.0
2016-08-16 08:00:00	NQ	Futures	5741.07	5742.56	5736.3	5739.28	5307.0
2016-08-16 09:00:00	NQ	Futures	5739.58	5741.37	5718.42	5729.45	32952.0
2016-08-16 10:00:00	NQ	Futures	5729.45	5738.68	5724.08	5727.06	22971.0
2016-08-16 11:00:00	NQ	Futures	5726.76	5736.0	5724.97	5731.83	14265.0
2016-08-16 12:00:00	NQ	Futures	5731.53	5737.49	5727.95	5736.9	9918.0
2016-08-16 13:00:00	NQ	Futures	5736.9	5737.19	5723.48	5726.76	11185.0
2016-08-16 14:00:00	NQ	Futures	5727.06	5731.23	5719.61	5729.15	14813.0
2016-08-16 15:00:00	NQ	Futures	5729.15	5732.43	5718.42	5719.91	17194.0
2016-08-16 16:00:00	NQ	Futures	5719.61	5725.27	5719.61	5724.68	6819.0
2016-08-16 18:00:00	NQ	Futures	5723.48	5725.27	5722.59	5722.89	788.0
2016-08-16 19:00:00	NQ	Futures	5723.19	5726.17	5723.19	5724.68	328.0
2016-08-16 20:00:00	NQ	Futures	5724.68	5730.34	5724.68	5728.25	688.0
2016-08-16 21:00:00	NQ	Futures	5727.66	5729.15	5725.57	5726.76	563.0
2016-08-16 22:00:00	NQ	Futures	5727.66	5728.85	5726.46	5727.95	362.0
2016-08-16 23:00:00	NQ	Futures	5727.95	5727.95	5725.57	5727.06	257.0
2016-08-16 00:00:00	YM	Futures	19978.7	19986.2	19976.5	19984.1	434.0
2016-08-16 01:00:00	YM	Futures	19984.1	19985.1	19976.5	19976.5	464.0
2016-08-16 02:00:00	YM	Futures	19975.4	19983.0	19973.3	19983.0	1133.0
2016-08-16 03:00:00	YM	Futures	19983.0	19983.0	19952.8	19964.7	3628.0

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

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