PREVIEW / futures_1hour / 2015-06-22

all futures 1-hour files

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

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
2015-06-22 00:00:00	ES	Futures	2243.67	2244.21	2243.41	2243.67	1126.0
2015-06-22 01:00:00	ES	Futures	2243.94	2245.27	2242.88	2245.01	4259.0
2015-06-22 02:00:00	ES	Futures	2245.01	2250.6	2244.47	2250.06	21489.0
2015-06-22 03:00:00	ES	Futures	2250.06	2252.46	2249.0	2251.93	25568.0
2015-06-22 04:00:00	ES	Futures	2252.19	2255.66	2251.4	2254.32	25941.0
2015-06-22 05:00:00	ES	Futures	2254.32	2255.12	2252.46	2252.73	15347.0
2015-06-22 06:00:00	ES	Futures	2252.73	2253.79	2248.47	2249.0	21005.0
2015-06-22 07:00:00	ES	Futures	2248.73	2252.46	2248.47	2251.66	25801.0
2015-06-22 08:00:00	ES	Futures	2251.66	2251.93	2247.4	2248.73	30863.0
2015-06-22 09:00:00	ES	Futures	2248.73	2255.12	2248.2	2254.06	158554.0
2015-06-22 10:00:00	ES	Futures	2254.06	2258.32	2252.99	2256.99	166982.0
2015-06-22 11:00:00	ES	Futures	2256.99	2259.92	2254.86	2255.12	116780.0
2015-06-22 12:00:00	ES	Futures	2255.12	2255.39	2249.53	2253.26	112908.0
2015-06-22 13:00:00	ES	Futures	2253.26	2253.53	2249.8	2252.73	63882.0
2015-06-22 14:00:00	ES	Futures	2252.73	2255.12	2251.13	2253.79	56578.0
2015-06-22 15:00:00	ES	Futures	2254.06	2254.32	2250.6	2252.46	143548.0
2015-06-22 16:00:00	ES	Futures	2252.46	2252.99	2248.47	2252.46	78667.0
2015-06-22 17:00:00	ES	Futures	2252.19	2252.46	2251.93	2252.19	885.0
2015-06-22 18:00:00	ES	Futures	2252.19	2253.53	2251.66	2253.53	2852.0
2015-06-22 19:00:00	ES	Futures	2253.26	2255.12	2253.26	2254.06	3059.0
2015-06-22 20:00:00	ES	Futures	2253.79	2254.59	2252.73	2254.06	2965.0
2015-06-22 21:00:00	ES	Futures	2254.06	2254.86	2253.53	2254.59	2188.0
2015-06-22 22:00:00	ES	Futures	2254.59	2255.39	2254.06	2254.59	1683.0
2015-06-22 23:00:00	ES	Futures	2254.59	2255.12	2254.06	2254.59	2104.0
2015-06-22 00:00:00	NQ	Futures	5344.03	5344.62	5343.44	5344.32	66.0
2015-06-22 01:00:00	NQ	Futures	5344.03	5346.69	5341.07	5346.39	440.0
2015-06-22 02:00:00	NQ	Futures	5346.39	5360.89	5345.21	5360.0	1486.0
2015-06-22 03:00:00	NQ	Futures	5359.7	5366.8	5357.04	5365.32	3506.0
2015-06-22 04:00:00	NQ	Futures	5365.32	5380.41	5363.85	5376.86	4614.0
2015-06-22 05:00:00	NQ	Futures	5376.86	5377.45	5371.83	5372.13	2276.0
2015-06-22 06:00:00	NQ	Futures	5372.13	5374.79	5363.55	5363.55	3851.0
2015-06-22 07:00:00	NQ	Futures	5364.44	5372.13	5363.85	5369.17	3191.0
2015-06-22 08:00:00	NQ	Futures	5369.17	5369.47	5359.41	5362.37	3718.0
2015-06-22 09:00:00	NQ	Futures	5362.37	5378.63	5361.48	5372.13	26544.0
2015-06-22 10:00:00	NQ	Futures	5371.83	5379.23	5367.1	5373.31	24962.0
2015-06-22 11:00:00	NQ	Futures	5373.31	5386.03	5368.87	5377.16	20066.0
2015-06-22 12:00:00	NQ	Futures	5377.16	5378.34	5359.7	5368.87	17055.0
2015-06-22 13:00:00	NQ	Futures	5368.87	5369.17	5357.04	5367.99	9534.0
2015-06-22 14:00:00	NQ	Futures	5367.99	5374.49	5362.96	5372.72	8084.0
2015-06-22 15:00:00	NQ	Futures	5373.01	5374.79	5362.66	5367.99	17964.0
2015-06-22 16:00:00	NQ	Futures	5367.99	5369.76	5358.82	5367.39	6291.0
2015-06-22 17:00:00	NQ	Futures	5367.69	5369.17	5367.39	5369.17	242.0
2015-06-22 18:00:00	NQ	Futures	5370.06	5371.24	5367.69	5370.35	290.0
2015-06-22 19:00:00	NQ	Futures	5370.94	5373.61	5370.06	5370.65	288.0
2015-06-22 20:00:00	NQ	Futures	5371.24	5373.31	5368.87	5372.42	290.0
2015-06-22 21:00:00	NQ	Futures	5373.01	5375.68	5371.83	5375.38	427.0
2015-06-22 22:00:00	NQ	Futures	5374.79	5376.86	5373.61	5374.79	220.0
2015-06-22 23:00:00	NQ	Futures	5374.79	5375.38	5372.72	5374.49	189.0
2015-06-22 00:00:00	YM	Futures	18941.2	18941.2	18938.1	18940.2	67.0
2015-06-22 01:00:00	YM	Futures	18941.2	18950.7	18933.8	18949.6	529.0

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

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