PREVIEW / futures_1hour / 2015-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-10.parquet
  size:    46 KB
  rows:    1,292

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-10 00:00:00	ES	Futures	2198.94	2199.21	2195.48	2196.55	4137.0
2015-07-10 01:00:00	ES	Futures	2196.55	2199.74	2192.29	2197.61	12604.0
2015-07-10 02:00:00	ES	Futures	2197.61	2199.74	2195.22	2199.21	16691.0
2015-07-10 03:00:00	ES	Futures	2199.48	2200.54	2195.48	2199.48	31241.0
2015-07-10 04:00:00	ES	Futures	2199.48	2199.74	2193.62	2194.95	22161.0
2015-07-10 05:00:00	ES	Futures	2194.95	2198.41	2193.09	2196.81	22412.0
2015-07-10 06:00:00	ES	Futures	2196.55	2201.61	2196.55	2201.07	17461.0
2015-07-10 07:00:00	ES	Futures	2201.34	2202.94	2198.94	2201.07	39226.0
2015-07-10 08:00:00	ES	Futures	2201.07	2203.74	2199.74	2202.94	40347.0
2015-07-10 09:00:00	ES	Futures	2203.2	2204.54	2197.35	2197.61	216793.0
2015-07-10 10:00:00	ES	Futures	2197.61	2201.34	2193.35	2198.68	204449.0
2015-07-10 11:00:00	ES	Futures	2198.41	2207.2	2197.88	2205.07	191852.0
2015-07-10 12:00:00	ES	Futures	2204.8	2206.4	2201.34	2204.27	108277.0
2015-07-10 13:00:00	ES	Futures	2204.54	2205.6	2200.01	2201.87	101962.0
2015-07-10 14:00:00	ES	Futures	2201.61	2208.0	2201.07	2207.2	120429.0
2015-07-10 15:00:00	ES	Futures	2207.2	2209.59	2203.47	2203.74	215345.0
2015-07-10 16:00:00	ES	Futures	2203.74	2205.33	2201.34	2204.54	96415.0
2015-07-10 17:00:00	ES	Futures	2204.27	2205.6	2204.27	2205.07	3584.0
2015-07-10 00:00:00	NQ	Futures	5190.81	5190.81	5182.82	5184.6	649.0
2015-07-10 01:00:00	NQ	Futures	5183.71	5191.1	5175.13	5187.55	1849.0
2015-07-10 02:00:00	NQ	Futures	5186.96	5192.29	5181.64	5188.74	2243.0
2015-07-10 03:00:00	NQ	Futures	5189.33	5193.47	5181.05	5191.99	4312.0
2015-07-10 04:00:00	NQ	Futures	5192.29	5192.29	5178.09	5181.93	3404.0
2015-07-10 05:00:00	NQ	Futures	5181.93	5191.99	5176.91	5188.15	3998.0
2015-07-10 06:00:00	NQ	Futures	5188.15	5198.79	5188.15	5197.61	3758.0
2015-07-10 07:00:00	NQ	Futures	5197.91	5205.6	5197.32	5200.57	8098.0
2015-07-10 08:00:00	NQ	Futures	5200.57	5205.01	5197.02	5203.53	5333.0
2015-07-10 09:00:00	NQ	Futures	5203.82	5208.85	5195.54	5196.13	35498.0
2015-07-10 10:00:00	NQ	Futures	5196.72	5207.96	5188.44	5204.41	33596.0
2015-07-10 11:00:00	NQ	Futures	5204.12	5227.78	5203.23	5221.27	31395.0
2015-07-10 12:00:00	NQ	Futures	5221.57	5226.01	5213.29	5221.87	14739.0
2015-07-10 13:00:00	NQ	Futures	5221.87	5223.64	5211.81	5216.54	13006.0
2015-07-10 14:00:00	NQ	Futures	5216.25	5234.59	5214.77	5231.92	17686.0
2015-07-10 15:00:00	NQ	Futures	5231.63	5237.25	5218.32	5218.61	31633.0
2015-07-10 16:00:00	NQ	Futures	5218.61	5221.27	5210.92	5217.73	8729.0
2015-07-10 17:00:00	NQ	Futures	5217.73	5221.27	5217.73	5220.68	240.0
2015-07-10 00:00:00	YM	Futures	18574.6	18575.7	18547.2	18553.5	910.0
2015-07-10 01:00:00	YM	Futures	18553.5	18579.9	18524.0	18564.1	2257.0
2015-07-10 02:00:00	YM	Futures	18565.1	18588.3	18554.6	18580.9	2453.0
2015-07-10 03:00:00	YM	Futures	18582.0	18585.1	18547.2	18582.0	4748.0
2015-07-10 04:00:00	YM	Futures	18582.0	18582.0	18523.0	18532.5	3716.0
2015-07-10 05:00:00	YM	Futures	18531.4	18559.9	18518.8	18548.3	3523.0
2015-07-10 06:00:00	YM	Futures	18547.2	18584.1	18547.2	18580.9	3166.0
2015-07-10 07:00:00	YM	Futures	18582.0	18596.7	18566.2	18579.9	5612.0
2015-07-10 08:00:00	YM	Futures	18579.9	18606.2	18569.3	18603.1	4174.0
2015-07-10 09:00:00	YM	Futures	18603.1	18631.5	18573.6	18576.7	21597.0
2015-07-10 10:00:00	YM	Futures	18576.7	18602.0	18533.5	18568.3	19318.0
2015-07-10 11:00:00	YM	Futures	18568.3	18643.1	18566.2	18630.4	18020.0
2015-07-10 12:00:00	YM	Futures	18631.5	18641.0	18597.8	18621.0	11032.0
2015-07-10 13:00:00	YM	Futures	18621.0	18627.3	18586.2	18600.9	10491.0

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

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