PREVIEW / futures_1hour / 2016-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-21.parquet
  size:    53 KB
  rows:    1,610

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-06-21 00:00:00	ES	Futures	2256.27	2257.63	2255.73	2257.36	2632.0
2016-06-21 01:00:00	ES	Futures	2257.63	2259.25	2256.27	2257.36	5955.0
2016-06-21 02:00:00	ES	Futures	2257.36	2259.25	2256.81	2257.08	10024.0
2016-06-21 03:00:00	ES	Futures	2257.08	2261.15	2254.92	2259.53	29208.0
2016-06-21 04:00:00	ES	Futures	2259.53	2260.88	2257.36	2258.71	18620.0
2016-06-21 05:00:00	ES	Futures	2258.71	2259.25	2256.81	2257.63	16902.0
2016-06-21 06:00:00	ES	Futures	2257.63	2262.78	2257.08	2261.15	22031.0
2016-06-21 07:00:00	ES	Futures	2260.88	2261.69	2259.25	2260.61	15957.0
2016-06-21 08:00:00	ES	Futures	2260.34	2260.61	2253.02	2256.27	57278.0
2016-06-21 09:00:00	ES	Futures	2256.27	2257.36	2251.66	2254.1	185834.0
2016-06-21 10:00:00	ES	Futures	2253.83	2256.0	2249.76	2253.56	221003.0
2016-06-21 11:00:00	ES	Futures	2253.83	2259.25	2252.47	2255.19	188790.0
2016-06-21 12:00:00	ES	Futures	2255.46	2258.17	2253.83	2254.92	76874.0
2016-06-21 13:00:00	ES	Futures	2255.19	2256.81	2252.2	2255.46	95041.0
2016-06-21 14:00:00	ES	Futures	2255.73	2262.51	2254.37	2258.71	121784.0
2016-06-21 15:00:00	ES	Futures	2258.71	2261.42	2255.73	2256.54	219003.0
2016-06-21 16:00:00	ES	Futures	2256.54	2258.17	2254.92	2255.46	60118.0
2016-06-21 18:00:00	ES	Futures	2255.46	2256.0	2253.29	2254.64	3907.0
2016-06-21 19:00:00	ES	Futures	2254.64	2255.46	2254.1	2254.1	2880.0
2016-06-21 20:00:00	ES	Futures	2254.1	2256.0	2253.02	2254.64	6361.0
2016-06-21 21:00:00	ES	Futures	2254.92	2256.0	2254.37	2255.19	3810.0
2016-06-21 22:00:00	ES	Futures	2255.46	2256.27	2254.37	2256.0	3277.0
2016-06-21 23:00:00	ES	Futures	2256.27	2258.44	2256.0	2257.9	3436.0
2016-06-21 00:00:00	NQ	Futures	5245.71	5249.28	5243.62	5249.28	401.0
2016-06-21 01:00:00	NQ	Futures	5248.99	5252.86	5246.3	5248.69	806.0
2016-06-21 02:00:00	NQ	Futures	5248.69	5252.86	5246.3	5247.5	1082.0
2016-06-21 03:00:00	NQ	Futures	5247.5	5258.52	5241.83	5254.95	3473.0
2016-06-21 04:00:00	NQ	Futures	5254.35	5258.23	5247.79	5253.46	2681.0
2016-06-21 05:00:00	NQ	Futures	5253.46	5254.65	5248.09	5251.37	1553.0
2016-06-21 06:00:00	NQ	Futures	5250.77	5264.48	5250.77	5260.91	2985.0
2016-06-21 07:00:00	NQ	Futures	5260.91	5262.1	5256.74	5260.01	2169.0
2016-06-21 08:00:00	NQ	Futures	5260.01	5261.21	5242.13	5248.99	5574.0
2016-06-21 09:00:00	NQ	Futures	5248.69	5259.12	5240.94	5256.44	31184.0
2016-06-21 10:00:00	NQ	Futures	5256.44	5257.33	5237.36	5239.45	30534.0
2016-06-21 11:00:00	NQ	Futures	5239.45	5254.05	5237.06	5247.2	23892.0
2016-06-21 12:00:00	NQ	Futures	5247.5	5257.33	5241.83	5242.43	12556.0
2016-06-21 13:00:00	NQ	Futures	5242.43	5248.39	5232.59	5241.83	15889.0
2016-06-21 14:00:00	NQ	Futures	5242.13	5259.72	5239.15	5251.07	16405.0
2016-06-21 15:00:00	NQ	Futures	5251.37	5263.29	5243.32	5250.77	30703.0
2016-06-21 16:00:00	NQ	Futures	5250.77	5252.56	5242.13	5242.13	5358.0
2016-06-21 18:00:00	NQ	Futures	5242.43	5242.73	5235.87	5239.75	876.0
2016-06-21 19:00:00	NQ	Futures	5240.04	5242.13	5237.96	5237.96	368.0
2016-06-21 20:00:00	NQ	Futures	5237.96	5242.43	5235.28	5240.04	928.0
2016-06-21 21:00:00	NQ	Futures	5238.85	5242.73	5238.85	5242.43	556.0
2016-06-21 22:00:00	NQ	Futures	5242.73	5244.52	5238.85	5244.52	408.0
2016-06-21 23:00:00	NQ	Futures	5244.52	5248.09	5244.22	5247.5	385.0
2016-06-21 00:00:00	YM	Futures	19106.9	19116.6	19099.4	19115.6	543.0
2016-06-21 01:00:00	YM	Futures	19116.6	19127.4	19106.9	19115.6	902.0
2016-06-21 02:00:00	YM	Futures	19116.6	19127.4	19102.6	19105.9	1648.0
2016-06-21 03:00:00	YM	Futures	19105.9	19137.1	19087.6	19125.2	3845.0

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

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