PREVIEW / futures_1hour / 2016-06-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	2263.51	2265.13	2263.24	2263.51	2689.0
2016-06-01 01:00:00	ES	Futures	2263.78	2264.05	2260.0	2260.81	9782.0
2016-06-01 02:00:00	ES	Futures	2260.81	2263.51	2260.27	2260.81	9974.0
2016-06-01 03:00:00	ES	Futures	2260.54	2261.62	2255.68	2259.73	34665.0
2016-06-01 04:00:00	ES	Futures	2259.73	2262.97	2256.49	2256.76	23191.0
2016-06-01 05:00:00	ES	Futures	2256.76	2258.38	2255.41	2255.95	21041.0
2016-06-01 06:00:00	ES	Futures	2256.22	2256.49	2254.06	2255.95	15906.0
2016-06-01 07:00:00	ES	Futures	2255.95	2256.22	2253.25	2255.41	20754.0
2016-06-01 08:00:00	ES	Futures	2255.14	2256.49	2253.52	2254.06	25213.0
2016-06-01 09:00:00	ES	Futures	2253.79	2254.33	2249.74	2251.9	132127.0
2016-06-01 10:00:00	ES	Futures	2251.9	2259.19	2250.55	2258.11	254523.0
2016-06-01 11:00:00	ES	Futures	2258.38	2262.43	2257.57	2259.19	173634.0
2016-06-01 12:00:00	ES	Futures	2259.19	2263.24	2258.92	2262.97	97746.0
2016-06-01 13:00:00	ES	Futures	2263.24	2264.05	2258.38	2261.35	89189.0
2016-06-01 14:00:00	ES	Futures	2261.35	2265.4	2258.92	2265.4	126953.0
2016-06-01 15:00:00	ES	Futures	2265.67	2267.02	2263.24	2264.59	161212.0
2016-06-01 16:00:00	ES	Futures	2264.59	2266.21	2264.32	2264.59	52907.0
2016-06-01 18:00:00	ES	Futures	2264.32	2265.67	2264.05	2265.13	2625.0
2016-06-01 19:00:00	ES	Futures	2265.13	2265.94	2264.86	2265.13	1853.0
2016-06-01 20:00:00	ES	Futures	2265.4	2265.67	2262.16	2263.24	6390.0
2016-06-01 21:00:00	ES	Futures	2263.51	2264.05	2262.16	2262.7	5584.0
2016-06-01 22:00:00	ES	Futures	2262.43	2262.7	2259.73	2260.27	7798.0
2016-06-01 23:00:00	ES	Futures	2260.27	2261.89	2260.0	2260.54	3681.0
2016-06-01 00:00:00	NQ	Futures	5393.32	5397.78	5393.02	5394.51	1031.0
2016-06-01 01:00:00	NQ	Futures	5394.81	5395.4	5383.8	5386.78	1534.0
2016-06-01 02:00:00	NQ	Futures	5386.78	5393.92	5385.29	5386.48	1517.0
2016-06-01 03:00:00	NQ	Futures	5386.18	5389.16	5374.58	5383.5	5079.0
2016-06-01 04:00:00	NQ	Futures	5383.8	5391.24	5372.49	5373.68	2921.0
2016-06-01 05:00:00	NQ	Futures	5373.68	5378.74	5370.71	5373.09	2071.0
2016-06-01 06:00:00	NQ	Futures	5373.09	5374.28	5368.92	5372.2	1775.0
2016-06-01 07:00:00	NQ	Futures	5372.2	5372.2	5365.35	5369.52	2749.0
2016-06-01 08:00:00	NQ	Futures	5369.22	5373.68	5367.14	5368.33	3348.0
2016-06-01 09:00:00	NQ	Futures	5368.03	5368.92	5359.7	5362.38	20744.0
2016-06-01 10:00:00	NQ	Futures	5363.27	5387.67	5358.81	5384.4	38879.0
2016-06-01 11:00:00	NQ	Futures	5384.69	5392.13	5373.39	5382.31	26458.0
2016-06-01 12:00:00	NQ	Futures	5382.61	5390.35	5379.63	5389.75	14498.0
2016-06-01 13:00:00	NQ	Futures	5389.75	5390.64	5374.58	5379.93	12609.0
2016-06-01 14:00:00	NQ	Futures	5379.93	5392.43	5374.87	5387.37	19043.0
2016-06-01 15:00:00	NQ	Futures	5387.67	5388.56	5373.09	5379.93	23010.0
2016-06-01 16:00:00	NQ	Futures	5379.93	5387.37	5378.44	5381.72	5191.0
2016-06-01 18:00:00	NQ	Futures	5379.93	5384.1	5379.63	5382.31	517.0
2016-06-01 19:00:00	NQ	Futures	5382.61	5383.5	5381.12	5381.42	239.0
2016-06-01 20:00:00	NQ	Futures	5381.42	5382.61	5373.68	5376.96	875.0
2016-06-01 21:00:00	NQ	Futures	5376.66	5380.53	5375.47	5376.66	621.0
2016-06-01 22:00:00	NQ	Futures	5376.66	5377.25	5369.82	5370.11	740.0
2016-06-01 23:00:00	NQ	Futures	5370.41	5374.28	5369.52	5370.71	447.0
2016-06-01 00:00:00	YM	Futures	19042.2	19054.0	19042.2	19044.4	510.0
2016-06-01 01:00:00	YM	Futures	19043.3	19045.4	19014.4	19018.7	1992.0
2016-06-01 02:00:00	YM	Futures	19018.7	19039.0	19013.3	19013.3	1374.0
2016-06-01 03:00:00	YM	Futures	19013.3	19021.9	18973.7	19006.9	4830.0

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

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