PREVIEW / futures_1hour / 2016-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-22.parquet
  size:    52 KB
  rows:    1,607

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-22 00:00:00	ES	Futures	2258.17	2259.53	2257.9	2258.17	3072.0
2016-06-22 01:00:00	ES	Futures	2258.44	2259.25	2257.36	2258.44	4120.0
2016-06-22 02:00:00	ES	Futures	2258.71	2259.8	2257.63	2259.53	8619.0
2016-06-22 03:00:00	ES	Futures	2259.8	2260.88	2254.64	2255.19	27726.0
2016-06-22 04:00:00	ES	Futures	2255.19	2256.81	2254.37	2255.73	12653.0
2016-06-22 05:00:00	ES	Futures	2255.73	2259.53	2255.73	2258.71	10978.0
2016-06-22 06:00:00	ES	Futures	2258.98	2260.07	2257.9	2260.07	11979.0
2016-06-22 07:00:00	ES	Futures	2259.8	2261.69	2257.08	2258.44	23879.0
2016-06-22 08:00:00	ES	Futures	2258.17	2259.53	2257.63	2258.98	20316.0
2016-06-22 09:00:00	ES	Futures	2258.98	2262.24	2258.44	2259.53	127591.0
2016-06-22 10:00:00	ES	Futures	2259.53	2268.47	2258.17	2266.3	232139.0
2016-06-22 11:00:00	ES	Futures	2266.58	2268.47	2260.88	2263.59	190051.0
2016-06-22 12:00:00	ES	Futures	2263.59	2264.41	2256.0	2258.71	144056.0
2016-06-22 13:00:00	ES	Futures	2258.98	2259.8	2252.47	2258.71	155611.0
2016-06-22 14:00:00	ES	Futures	2258.98	2260.61	2255.19	2257.08	103256.0
2016-06-22 15:00:00	ES	Futures	2257.08	2260.07	2251.12	2252.47	231375.0
2016-06-22 16:00:00	ES	Futures	2252.47	2254.1	2251.93	2253.02	71103.0
2016-06-22 18:00:00	ES	Futures	2259.53	2266.85	2259.53	2263.32	18503.0
2016-06-22 19:00:00	ES	Futures	2263.59	2264.14	2261.69	2262.78	3415.0
2016-06-22 20:00:00	ES	Futures	2263.05	2266.03	2261.69	2263.59	6990.0
2016-06-22 21:00:00	ES	Futures	2263.59	2265.76	2263.32	2264.68	4408.0
2016-06-22 22:00:00	ES	Futures	2264.41	2265.22	2263.32	2263.86	2977.0
2016-06-22 23:00:00	ES	Futures	2263.59	2263.86	2261.15	2263.32	3818.0
2016-06-22 00:00:00	NQ	Futures	5248.09	5250.77	5246.9	5247.5	505.0
2016-06-22 01:00:00	NQ	Futures	5247.5	5249.58	5245.11	5249.28	684.0
2016-06-22 02:00:00	NQ	Futures	5249.28	5252.86	5246.01	5252.26	1043.0
2016-06-22 03:00:00	NQ	Futures	5251.97	5254.95	5239.15	5241.83	3393.0
2016-06-22 04:00:00	NQ	Futures	5241.83	5246.01	5239.15	5244.81	1839.0
2016-06-22 05:00:00	NQ	Futures	5244.81	5255.84	5244.52	5254.65	1701.0
2016-06-22 06:00:00	NQ	Futures	5254.65	5257.03	5251.07	5257.03	1411.0
2016-06-22 07:00:00	NQ	Futures	5256.74	5260.61	5252.86	5255.54	2547.0
2016-06-22 08:00:00	NQ	Futures	5255.84	5257.03	5253.46	5256.14	1855.0
2016-06-22 09:00:00	NQ	Futures	5256.14	5258.82	5246.6	5246.6	18963.0
2016-06-22 10:00:00	NQ	Futures	5246.6	5279.69	5243.92	5274.32	29781.0
2016-06-22 11:00:00	NQ	Futures	5274.62	5286.24	5269.25	5274.02	23353.0
2016-06-22 12:00:00	NQ	Futures	5274.32	5275.81	5246.9	5256.44	23904.0
2016-06-22 13:00:00	NQ	Futures	5256.74	5262.4	5236.47	5259.12	26466.0
2016-06-22 14:00:00	NQ	Futures	5259.42	5264.48	5244.52	5251.37	14783.0
2016-06-22 15:00:00	NQ	Futures	5251.07	5258.23	5234.98	5239.75	26680.0
2016-06-22 16:00:00	NQ	Futures	5239.45	5243.62	5237.66	5238.85	6388.0
2016-06-22 18:00:00	NQ	Futures	5257.33	5269.25	5255.25	5263.89	1896.0
2016-06-22 19:00:00	NQ	Futures	5264.19	5264.78	5259.42	5262.7	496.0
2016-06-22 20:00:00	NQ	Futures	5262.99	5269.25	5260.31	5264.48	979.0
2016-06-22 21:00:00	NQ	Futures	5263.89	5269.25	5263.89	5265.38	417.0
2016-06-22 22:00:00	NQ	Futures	5265.98	5267.17	5262.7	5264.19	310.0
2016-06-22 23:00:00	NQ	Futures	5264.48	5264.48	5259.12	5263.89	255.0
2016-06-22 00:00:00	YM	Futures	19104.8	19113.4	19103.7	19104.8	566.0
2016-06-22 01:00:00	YM	Futures	19104.8	19111.2	19097.3	19109.1	667.0
2016-06-22 02:00:00	YM	Futures	19109.1	19118.8	19102.6	19115.6	942.0
2016-06-22 03:00:00	YM	Futures	19115.6	19126.3	19079.0	19084.3	3664.0

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

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