PREVIEW / futures_1hour / 2015-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-01.parquet
  size:    52 KB
  rows:    1,538

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-07-01 00:00:00	ES	Futures	2195.22	2196.81	2194.95	2195.48	2199.0
2015-07-01 01:00:00	ES	Futures	2195.75	2197.88	2194.15	2197.08	5221.0
2015-07-01 02:00:00	ES	Futures	2197.08	2201.61	2197.08	2199.74	16161.0
2015-07-01 03:00:00	ES	Futures	2199.74	2201.34	2195.75	2198.94	25777.0
2015-07-01 04:00:00	ES	Futures	2198.68	2206.13	2197.08	2205.33	29510.0
2015-07-01 05:00:00	ES	Futures	2205.33	2212.52	2203.47	2205.87	83603.0
2015-07-01 06:00:00	ES	Futures	2205.87	2208.53	2203.74	2205.87	27307.0
2015-07-01 07:00:00	ES	Futures	2206.13	2207.2	2202.94	2204.0	28812.0
2015-07-01 08:00:00	ES	Futures	2204.0	2206.93	2203.74	2204.8	33545.0
2015-07-01 09:00:00	ES	Futures	2205.07	2208.26	2202.14	2206.93	192770.0
2015-07-01 10:00:00	ES	Futures	2206.67	2209.33	2197.61	2201.87	286525.0
2015-07-01 11:00:00	ES	Futures	2201.61	2204.27	2199.74	2200.28	133055.0
2015-07-01 12:00:00	ES	Futures	2200.01	2202.41	2195.75	2196.55	130993.0
2015-07-01 13:00:00	ES	Futures	2196.28	2201.34	2194.68	2196.55	114638.0
2015-07-01 14:00:00	ES	Futures	2196.55	2198.68	2193.62	2197.61	107254.0
2015-07-01 15:00:00	ES	Futures	2197.61	2204.54	2197.35	2203.74	164814.0
2015-07-01 16:00:00	ES	Futures	2203.74	2206.67	2202.94	2206.4	79579.0
2015-07-01 17:00:00	ES	Futures	2206.13	2206.4	2205.87	2206.4	1262.0
2015-07-01 18:00:00	ES	Futures	2206.13	2206.4	2204.8	2205.07	2094.0
2015-07-01 19:00:00	ES	Futures	2205.07	2205.6	2203.74	2204.54	2204.0
2015-07-01 20:00:00	ES	Futures	2204.54	2204.54	2202.41	2202.67	4281.0
2015-07-01 21:00:00	ES	Futures	2202.67	2203.47	2202.14	2202.67	2732.0
2015-07-01 22:00:00	ES	Futures	2202.94	2204.27	2202.14	2203.74	2683.0
2015-07-01 23:00:00	ES	Futures	2203.47	2205.6	2203.47	2203.74	2931.0
2015-07-01 00:00:00	NQ	Futures	5210.63	5213.58	5210.33	5211.81	451.0
2015-07-01 01:00:00	NQ	Futures	5211.51	5214.47	5208.26	5213.58	767.0
2015-07-01 02:00:00	NQ	Futures	5213.29	5225.71	5212.99	5219.2	1834.0
2015-07-01 03:00:00	NQ	Futures	5218.91	5224.82	5211.81	5219.2	3495.0
2015-07-01 04:00:00	NQ	Futures	5218.91	5236.66	5216.54	5235.18	3981.0
2015-07-01 05:00:00	NQ	Futures	5235.18	5255.29	5232.51	5241.39	13921.0
2015-07-01 06:00:00	NQ	Futures	5241.68	5245.83	5236.36	5240.8	4512.0
2015-07-01 07:00:00	NQ	Futures	5240.8	5242.87	5233.7	5236.06	3527.0
2015-07-01 08:00:00	NQ	Futures	5235.77	5241.39	5235.47	5238.73	4153.0
2015-07-01 09:00:00	NQ	Futures	5238.73	5249.37	5230.44	5247.3	34363.0
2015-07-01 10:00:00	NQ	Futures	5247.9	5251.45	5220.68	5231.04	34643.0
2015-07-01 11:00:00	NQ	Futures	5231.33	5235.47	5222.46	5224.53	13738.0
2015-07-01 12:00:00	NQ	Futures	5224.23	5228.97	5211.22	5212.7	14491.0
2015-07-01 13:00:00	NQ	Futures	5212.7	5225.71	5208.26	5212.7	15402.0
2015-07-01 14:00:00	NQ	Futures	5213.29	5219.8	5205.6	5216.84	14126.0
2015-07-01 15:00:00	NQ	Futures	5217.13	5231.04	5216.84	5229.56	17480.0
2015-07-01 16:00:00	NQ	Futures	5229.26	5235.18	5228.37	5233.99	6298.0
2015-07-01 17:00:00	NQ	Futures	5233.99	5234.29	5233.11	5234.29	101.0
2015-07-01 18:00:00	NQ	Futures	5233.99	5235.18	5230.74	5230.74	338.0
2015-07-01 19:00:00	NQ	Futures	5231.04	5232.22	5228.37	5230.44	366.0
2015-07-01 20:00:00	NQ	Futures	5230.15	5230.74	5225.42	5225.42	567.0
2015-07-01 21:00:00	NQ	Futures	5225.71	5227.49	5224.82	5226.01	235.0
2015-07-01 22:00:00	NQ	Futures	5225.42	5229.56	5225.42	5228.08	320.0
2015-07-01 23:00:00	NQ	Futures	5228.37	5230.74	5227.19	5227.78	525.0
2015-07-01 00:00:00	YM	Futures	18524.0	18531.4	18521.9	18523.0	398.0
2015-07-01 01:00:00	YM	Futures	18523.0	18538.8	18514.6	18535.6	775.0

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

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