PREVIEW / futures_1hour / 2015-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-08.parquet
  size:    45 KB
  rows:    1,306

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-05-08 00:00:00	ES	Futures	2204.86	2205.38	2204.06	2204.33	1311.0
2015-05-08 01:00:00	ES	Futures	2204.59	2204.86	2203.27	2204.59	2220.0
2015-05-08 02:00:00	ES	Futures	2204.86	2208.02	2204.33	2207.5	14644.0
2015-05-08 03:00:00	ES	Futures	2207.5	2209.35	2204.06	2206.18	21896.0
2015-05-08 04:00:00	ES	Futures	2206.18	2206.97	2203.01	2204.86	16803.0
2015-05-08 05:00:00	ES	Futures	2204.59	2205.38	2203.53	2203.8	6283.0
2015-05-08 06:00:00	ES	Futures	2203.8	2206.7	2203.01	2205.38	8899.0
2015-05-08 07:00:00	ES	Futures	2205.38	2206.97	2204.33	2205.91	15532.0
2015-05-08 08:00:00	ES	Futures	2205.91	2225.72	2204.59	2222.29	167216.0
2015-05-08 09:00:00	ES	Futures	2222.55	2228.1	2220.44	2226.51	271167.0
2015-05-08 10:00:00	ES	Futures	2226.51	2229.95	2225.98	2228.1	178458.0
2015-05-08 11:00:00	ES	Futures	2228.1	2232.85	2227.83	2231.53	153768.0
2015-05-08 12:00:00	ES	Futures	2231.53	2232.32	2229.15	2230.21	82283.0
2015-05-08 13:00:00	ES	Futures	2230.21	2231.8	2227.83	2228.1	75278.0
2015-05-08 14:00:00	ES	Futures	2228.36	2229.95	2226.78	2229.68	87714.0
2015-05-08 15:00:00	ES	Futures	2229.95	2231.8	2228.36	2230.21	165173.0
2015-05-08 16:00:00	ES	Futures	2229.95	2230.21	2226.51	2227.31	87024.0
2015-05-08 17:00:00	ES	Futures	2227.31	2227.57	2226.78	2226.78	1180.0
2015-05-08 00:00:00	NQ	Futures	5187.87	5188.75	5186.1	5187.57	213.0
2015-05-08 01:00:00	NQ	Futures	5187.28	5187.87	5183.16	5185.22	331.0
2015-05-08 02:00:00	NQ	Futures	5185.81	5196.4	5185.22	5196.1	1708.0
2015-05-08 03:00:00	NQ	Futures	5196.4	5201.4	5188.16	5196.1	5462.0
2015-05-08 04:00:00	NQ	Futures	5195.81	5197.57	5186.69	5191.4	3027.0
2015-05-08 05:00:00	NQ	Futures	5191.4	5192.87	5187.87	5187.87	1661.0
2015-05-08 06:00:00	NQ	Futures	5187.87	5195.51	5185.81	5191.99	2010.0
2015-05-08 07:00:00	NQ	Futures	5191.99	5195.51	5182.28	5188.75	4902.0
2015-05-08 08:00:00	NQ	Futures	5189.05	5237.57	5184.05	5230.51	24325.0
2015-05-08 09:00:00	NQ	Futures	5230.51	5242.27	5218.75	5234.92	48674.0
2015-05-08 10:00:00	NQ	Futures	5234.92	5240.8	5231.1	5234.62	25706.0
2015-05-08 11:00:00	NQ	Futures	5234.62	5249.33	5233.74	5246.68	23870.0
2015-05-08 12:00:00	NQ	Futures	5246.68	5248.74	5238.15	5239.62	13729.0
2015-05-08 13:00:00	NQ	Futures	5239.62	5243.45	5233.74	5234.92	9946.0
2015-05-08 14:00:00	NQ	Futures	5235.21	5238.15	5229.92	5236.39	13405.0
2015-05-08 15:00:00	NQ	Futures	5236.68	5243.45	5232.57	5236.68	26043.0
2015-05-08 16:00:00	NQ	Futures	5236.39	5237.86	5229.92	5233.15	8018.0
2015-05-08 17:00:00	NQ	Futures	5232.86	5233.15	5230.8	5230.8	153.0
2015-05-08 00:00:00	YM	Futures	18781.6	18783.7	18776.4	18778.5	308.0
2015-05-08 01:00:00	YM	Futures	18777.4	18779.5	18763.8	18776.4	658.0
2015-05-08 02:00:00	YM	Futures	18774.3	18811.0	18773.2	18809.9	1922.0
2015-05-08 03:00:00	YM	Futures	18809.9	18826.7	18777.4	18796.3	4593.0
2015-05-08 04:00:00	YM	Futures	18795.3	18803.6	18773.2	18783.7	3422.0
2015-05-08 05:00:00	YM	Futures	18783.7	18790.0	18774.3	18774.3	1152.0
2015-05-08 06:00:00	YM	Futures	18775.3	18803.6	18771.1	18794.2	1824.0
2015-05-08 07:00:00	YM	Futures	18795.3	18805.7	18782.7	18797.3	2393.0
2015-05-08 08:00:00	YM	Futures	18797.3	18968.3	18785.8	18933.7	24750.0
2015-05-08 09:00:00	YM	Futures	18934.7	19010.2	18921.1	18998.7	34026.0
2015-05-08 10:00:00	YM	Futures	18998.7	19020.7	18983.0	19010.2	23451.0
2015-05-08 11:00:00	YM	Futures	19010.2	19038.5	18996.6	19026.0	15851.0
2015-05-08 12:00:00	YM	Futures	19026.0	19031.2	19006.0	19019.7	6926.0
2015-05-08 13:00:00	YM	Futures	19018.6	19032.2	19008.1	19008.1	5589.0

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

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