PREVIEW / futures_1hour / 2015-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-19.parquet
  size:    43 KB
  rows:    1,286

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-19 00:00:00	ES	Futures	2249.8	2250.6	2249.27	2250.6	1127.0
2015-06-19 01:00:00	ES	Futures	2250.33	2251.4	2250.33	2250.33	3224.0
2015-06-19 02:00:00	ES	Futures	2250.33	2250.86	2248.73	2250.86	9383.0
2015-06-19 03:00:00	ES	Futures	2250.86	2253.79	2249.0	2252.19	18044.0
2015-06-19 04:00:00	ES	Futures	2252.46	2255.39	2251.13	2252.46	15465.0
2015-06-19 05:00:00	ES	Futures	2252.46	2255.39	2252.19	2253.53	14242.0
2015-06-19 06:00:00	ES	Futures	2253.53	2254.86	2253.53	2254.59	9995.0
2015-06-19 07:00:00	ES	Futures	2254.86	2255.39	2252.73	2254.32	23223.0
2015-06-19 08:00:00	ES	Futures	2254.59	2254.59	2250.86	2251.13	32904.0
2015-06-19 09:00:00	ES	Futures	2251.13	2251.13	2243.94	2246.6	224659.0
2015-06-19 10:00:00	ES	Futures	2246.6	2248.73	2245.27	2247.93	148343.0
2015-06-19 11:00:00	ES	Futures	2248.2	2248.2	2243.41	2244.21	117740.0
2015-06-19 12:00:00	ES	Futures	2244.21	2244.47	2242.08	2243.94	77970.0
2015-06-19 13:00:00	ES	Futures	2243.94	2245.8	2242.34	2245.01	50954.0
2015-06-19 14:00:00	ES	Futures	2245.01	2245.01	2238.88	2239.95	97431.0
2015-06-19 15:00:00	ES	Futures	2239.95	2242.61	2236.22	2236.49	209699.0
2015-06-19 16:00:00	ES	Futures	2236.22	2238.35	2233.56	2236.75	128003.0
2015-06-19 17:00:00	ES	Futures	2237.02	2237.28	2233.29	2233.29	4586.0
2015-06-19 00:00:00	NQ	Futures	5357.34	5358.82	5356.45	5358.82	260.0
2015-06-19 01:00:00	NQ	Futures	5358.52	5360.0	5357.93	5358.23	441.0
2015-06-19 02:00:00	NQ	Futures	5357.93	5360.3	5354.38	5359.7	866.0
2015-06-19 03:00:00	NQ	Futures	5359.7	5367.39	5355.56	5362.96	1988.0
2015-06-19 04:00:00	NQ	Futures	5363.25	5369.76	5360.3	5363.25	1425.0
2015-06-19 05:00:00	NQ	Futures	5362.96	5370.35	5362.66	5365.62	1428.0
2015-06-19 06:00:00	NQ	Futures	5365.32	5368.58	5365.32	5367.39	989.0
2015-06-19 07:00:00	NQ	Futures	5367.69	5369.17	5364.73	5368.87	1723.0
2015-06-19 08:00:00	NQ	Futures	5369.17	5371.24	5364.73	5365.32	4665.0
2015-06-19 09:00:00	NQ	Futures	5365.32	5366.8	5338.7	5342.84	37321.0
2015-06-19 10:00:00	NQ	Futures	5342.84	5348.46	5336.93	5347.87	22116.0
2015-06-19 11:00:00	NQ	Futures	5347.58	5352.9	5338.11	5339.59	17370.0
2015-06-19 12:00:00	NQ	Futures	5339.29	5340.77	5333.08	5340.18	13459.0
2015-06-19 13:00:00	NQ	Futures	5340.18	5346.99	5337.52	5344.32	7780.0
2015-06-19 14:00:00	NQ	Futures	5344.62	5345.21	5331.9	5334.27	12584.0
2015-06-19 15:00:00	NQ	Futures	5333.97	5342.25	5327.17	5327.76	22912.0
2015-06-19 16:00:00	NQ	Futures	5327.46	5332.49	5322.43	5328.35	9172.0
2015-06-19 17:00:00	NQ	Futures	5329.24	5329.24	5319.77	5319.77	148.0
2015-06-19 00:00:00	YM	Futures	18999.2	19005.5	18996.0	19004.4	217.0
2015-06-19 01:00:00	YM	Futures	19003.4	19008.6	19002.3	19006.5	443.0
2015-06-19 02:00:00	YM	Futures	19004.4	19008.6	18991.8	19008.6	1118.0
2015-06-19 03:00:00	YM	Futures	19008.6	19032.9	18993.9	19020.2	1574.0
2015-06-19 04:00:00	YM	Futures	19018.1	19040.2	19009.7	19016.0	1374.0
2015-06-19 05:00:00	YM	Futures	19016.0	19042.3	19012.8	19029.7	1787.0
2015-06-19 06:00:00	YM	Futures	19029.7	19039.2	19028.7	19037.1	1053.0
2015-06-19 07:00:00	YM	Futures	19038.1	19041.3	19017.1	19029.7	2146.0
2015-06-19 08:00:00	YM	Futures	19029.7	19029.7	18997.0	18998.1	3250.0
2015-06-19 09:00:00	YM	Futures	18997.0	19000.2	18951.7	18966.5	18884.0
2015-06-19 10:00:00	YM	Futures	18966.5	18990.7	18956.0	18977.0	13874.0
2015-06-19 11:00:00	YM	Futures	18977.0	18978.1	18938.1	18946.5	11305.0
2015-06-19 12:00:00	YM	Futures	18946.5	18952.8	18932.8	18940.2	7647.0
2015-06-19 13:00:00	YM	Futures	18942.3	18960.2	18933.8	18945.4	4799.0

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

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