PREVIEW / futures_1hour / 2016-08-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	2362.58	2362.85	2361.22	2362.03	2134.0
2016-08-22 01:00:00	ES	Futures	2362.3	2362.85	2361.49	2362.03	2255.0
2016-08-22 02:00:00	ES	Futures	2362.03	2362.3	2361.22	2362.3	5266.0
2016-08-22 03:00:00	ES	Futures	2362.3	2366.64	2359.86	2366.1	35503.0
2016-08-22 04:00:00	ES	Futures	2366.1	2369.08	2366.1	2368.0	20382.0
2016-08-22 05:00:00	ES	Futures	2368.0	2369.63	2365.02	2366.1	27493.0
2016-08-22 06:00:00	ES	Futures	2365.83	2366.37	2360.95	2361.22	23295.0
2016-08-22 07:00:00	ES	Futures	2361.22	2362.03	2360.14	2361.49	25369.0
2016-08-22 08:00:00	ES	Futures	2361.22	2363.66	2360.95	2362.03	22249.0
2016-08-22 09:00:00	ES	Futures	2362.03	2363.12	2357.69	2360.95	229493.0
2016-08-22 10:00:00	ES	Futures	2360.68	2367.73	2358.78	2366.1	183591.0
2016-08-22 11:00:00	ES	Futures	2366.1	2367.19	2359.32	2361.76	178507.0
2016-08-22 12:00:00	ES	Futures	2361.76	2368.54	2360.14	2364.75	155878.0
2016-08-22 13:00:00	ES	Futures	2365.02	2365.83	2359.59	2364.47	174338.0
2016-08-22 14:00:00	ES	Futures	2364.47	2366.37	2362.03	2363.39	174414.0
2016-08-22 15:00:00	ES	Futures	2363.39	2365.83	2363.39	2365.29	188292.0
2016-08-22 16:00:00	ES	Futures	2365.29	2366.64	2364.75	2365.83	62556.0
2016-08-22 18:00:00	ES	Futures	2365.56	2366.1	2364.75	2365.29	3112.0
2016-08-22 19:00:00	ES	Futures	2365.29	2365.29	2364.2	2364.75	1221.0
2016-08-22 20:00:00	ES	Futures	2364.47	2365.29	2363.93	2365.02	3135.0
2016-08-22 21:00:00	ES	Futures	2365.02	2366.92	2364.75	2365.56	6774.0
2016-08-22 22:00:00	ES	Futures	2365.56	2365.83	2365.02	2365.56	2701.0
2016-08-22 23:00:00	ES	Futures	2365.56	2367.73	2365.56	2367.46	3794.0
2016-08-22 00:00:00	NQ	Futures	5721.4	5721.7	5717.82	5719.91	233.0
2016-08-22 01:00:00	NQ	Futures	5719.91	5721.4	5718.12	5720.5	339.0
2016-08-22 02:00:00	NQ	Futures	5720.21	5721.4	5718.12	5721.4	744.0
2016-08-22 03:00:00	NQ	Futures	5721.4	5733.62	5713.95	5732.72	5056.0
2016-08-22 04:00:00	NQ	Futures	5732.72	5740.47	5732.72	5738.09	2671.0
2016-08-22 05:00:00	NQ	Futures	5738.09	5743.16	5729.45	5731.23	3679.0
2016-08-22 06:00:00	NQ	Futures	5731.23	5731.53	5718.12	5719.01	3507.0
2016-08-22 07:00:00	NQ	Futures	5719.01	5720.8	5715.44	5719.01	3051.0
2016-08-22 08:00:00	NQ	Futures	5718.72	5724.68	5718.42	5721.99	2669.0
2016-08-22 09:00:00	NQ	Futures	5721.7	5725.87	5710.07	5723.19	28759.0
2016-08-22 10:00:00	NQ	Futures	5723.19	5744.05	5717.23	5735.41	32109.0
2016-08-22 11:00:00	NQ	Futures	5735.41	5738.39	5712.16	5718.72	28014.0
2016-08-22 12:00:00	NQ	Futures	5718.72	5737.19	5714.84	5729.74	20360.0
2016-08-22 13:00:00	NQ	Futures	5729.45	5733.62	5713.35	5728.85	21389.0
2016-08-22 14:00:00	NQ	Futures	5728.85	5733.32	5719.61	5724.97	15557.0
2016-08-22 15:00:00	NQ	Futures	5725.27	5733.32	5725.27	5732.72	17164.0
2016-08-22 16:00:00	NQ	Futures	5732.72	5738.98	5732.43	5736.6	6108.0
2016-08-22 18:00:00	NQ	Futures	5733.62	5736.9	5733.62	5734.81	553.0
2016-08-22 19:00:00	NQ	Futures	5735.11	5735.11	5732.13	5732.72	272.0
2016-08-22 20:00:00	NQ	Futures	5733.02	5735.7	5731.83	5735.41	521.0
2016-08-22 21:00:00	NQ	Futures	5735.41	5741.37	5733.92	5736.3	1370.0
2016-08-22 22:00:00	NQ	Futures	5736.9	5738.09	5735.11	5737.19	468.0
2016-08-22 23:00:00	NQ	Futures	5737.49	5740.77	5736.3	5740.47	561.0
2016-08-22 00:00:00	YM	Futures	19920.6	19921.6	19907.6	19915.2	323.0
2016-08-22 01:00:00	YM	Futures	19914.1	19919.5	19908.7	19915.2	350.0
2016-08-22 02:00:00	YM	Futures	19915.2	19917.3	19906.6	19913.0	1386.0
2016-08-22 03:00:00	YM	Futures	19914.1	19949.6	19894.7	19946.4	4652.0

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

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