PREVIEW / futures_1hour / 2015-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-23.parquet
  size:    50 KB
  rows:    1,561

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-23 00:00:00	ES	Futures	2254.86	2256.45	2254.59	2256.45	3862.0
2015-06-23 01:00:00	ES	Futures	2256.19	2257.52	2255.66	2257.25	4471.0
2015-06-23 02:00:00	ES	Futures	2257.25	2258.32	2256.19	2256.45	11761.0
2015-06-23 03:00:00	ES	Futures	2256.72	2256.99	2253.53	2255.39	18122.0
2015-06-23 04:00:00	ES	Futures	2255.39	2255.92	2253.53	2254.06	13339.0
2015-06-23 05:00:00	ES	Futures	2254.06	2254.06	2252.46	2253.53	9013.0
2015-06-23 06:00:00	ES	Futures	2253.53	2255.39	2252.46	2254.32	12401.0
2015-06-23 07:00:00	ES	Futures	2254.06	2256.45	2252.73	2255.92	16045.0
2015-06-23 08:00:00	ES	Futures	2255.66	2256.99	2251.4	2252.46	26696.0
2015-06-23 09:00:00	ES	Futures	2252.19	2256.45	2251.66	2255.92	100886.0
2015-06-23 10:00:00	ES	Futures	2255.66	2258.05	2250.06	2251.66	163427.0
2015-06-23 11:00:00	ES	Futures	2251.66	2253.53	2250.06	2251.4	121316.0
2015-06-23 12:00:00	ES	Futures	2251.66	2251.66	2248.47	2249.8	71500.0
2015-06-23 13:00:00	ES	Futures	2249.53	2252.46	2248.73	2252.19	41518.0
2015-06-23 14:00:00	ES	Futures	2251.93	2254.86	2251.4	2253.79	54938.0
2015-06-23 15:00:00	ES	Futures	2253.79	2255.12	2252.46	2253.53	95320.0
2015-06-23 16:00:00	ES	Futures	2253.53	2255.92	2252.73	2254.59	53840.0
2015-06-23 17:00:00	ES	Futures	2254.59	2255.39	2254.32	2255.12	1667.0
2015-06-23 18:00:00	ES	Futures	2255.12	2256.19	2254.32	2255.12	2559.0
2015-06-23 19:00:00	ES	Futures	2255.12	2255.39	2253.79	2255.12	2021.0
2015-06-23 20:00:00	ES	Futures	2255.12	2255.39	2254.32	2254.59	3405.0
2015-06-23 21:00:00	ES	Futures	2254.59	2254.86	2252.99	2253.26	2839.0
2015-06-23 22:00:00	ES	Futures	2253.26	2254.06	2252.99	2253.26	1021.0
2015-06-23 23:00:00	ES	Futures	2253.26	2254.06	2253.26	2253.79	1477.0
2015-06-23 00:00:00	NQ	Futures	5375.09	5378.34	5374.2	5377.45	453.0
2015-06-23 01:00:00	NQ	Futures	5377.45	5380.11	5376.56	5379.82	533.0
2015-06-23 02:00:00	NQ	Futures	5379.82	5381.89	5377.16	5378.04	652.0
2015-06-23 03:00:00	NQ	Futures	5378.93	5379.52	5371.54	5375.97	1813.0
2015-06-23 04:00:00	NQ	Futures	5375.68	5376.56	5372.42	5374.2	1091.0
2015-06-23 05:00:00	NQ	Futures	5373.9	5374.49	5370.06	5373.31	909.0
2015-06-23 06:00:00	NQ	Futures	5373.01	5376.27	5370.65	5374.2	1262.0
2015-06-23 07:00:00	NQ	Futures	5373.9	5378.93	5370.94	5378.63	2077.0
2015-06-23 08:00:00	NQ	Futures	5377.75	5380.11	5368.58	5370.35	3173.0
2015-06-23 09:00:00	NQ	Futures	5370.35	5378.34	5364.44	5365.92	18150.0
2015-06-23 10:00:00	NQ	Futures	5365.92	5373.9	5351.13	5359.11	27549.0
2015-06-23 11:00:00	NQ	Futures	5358.82	5367.99	5357.04	5364.44	16268.0
2015-06-23 12:00:00	NQ	Futures	5364.44	5365.03	5356.15	5358.82	8218.0
2015-06-23 13:00:00	NQ	Futures	5358.52	5367.99	5355.86	5365.62	6508.0
2015-06-23 14:00:00	NQ	Futures	5365.62	5373.01	5363.85	5371.54	7282.0
2015-06-23 15:00:00	NQ	Futures	5371.83	5376.27	5367.99	5373.01	11744.0
2015-06-23 16:00:00	NQ	Futures	5373.31	5378.34	5369.76	5374.2	4354.0
2015-06-23 17:00:00	NQ	Futures	5374.49	5376.27	5374.49	5375.68	121.0
2015-06-23 18:00:00	NQ	Futures	5375.68	5378.04	5374.2	5375.38	437.0
2015-06-23 19:00:00	NQ	Futures	5375.68	5376.27	5373.31	5375.09	158.0
2015-06-23 20:00:00	NQ	Futures	5375.09	5375.38	5373.31	5374.49	217.0
2015-06-23 21:00:00	NQ	Futures	5374.49	5374.79	5370.94	5371.54	239.0
2015-06-23 22:00:00	NQ	Futures	5371.54	5372.72	5369.76	5370.35	318.0
2015-06-23 23:00:00	NQ	Futures	5370.65	5372.13	5369.76	5372.13	376.0
2015-06-23 00:00:00	YM	Futures	19025.5	19043.4	19024.4	19038.1	628.0
2015-06-23 01:00:00	YM	Futures	19035.0	19046.6	19033.9	19044.5	483.0

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

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