PREVIEW / futures_1hour / 2015-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-22.parquet
  size:    51 KB
  rows:    1,574

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-04-22 00:00:00	ES	Futures	2210.93	2211.72	2210.4	2210.93	2086.0
2015-04-22 01:00:00	ES	Futures	2211.19	2211.19	2210.14	2211.19	2234.0
2015-04-22 02:00:00	ES	Futures	2210.93	2214.1	2210.4	2213.84	6026.0
2015-04-22 03:00:00	ES	Futures	2214.1	2217.0	2210.67	2212.78	27237.0
2015-04-22 04:00:00	ES	Futures	2212.78	2213.04	2199.31	2200.89	52750.0
2015-04-22 05:00:00	ES	Futures	2200.63	2205.12	2198.25	2202.74	25834.0
2015-04-22 06:00:00	ES	Futures	2202.74	2202.74	2197.72	2201.95	19499.0
2015-04-22 07:00:00	ES	Futures	2202.21	2205.91	2201.95	2204.59	14348.0
2015-04-22 08:00:00	ES	Futures	2204.59	2210.67	2203.53	2210.4	27949.0
2015-04-22 09:00:00	ES	Futures	2210.4	2214.36	2205.38	2208.02	160892.0
2015-04-22 10:00:00	ES	Futures	2208.29	2214.89	2201.42	2214.1	239033.0
2015-04-22 11:00:00	ES	Futures	2214.1	2215.68	2212.25	2215.42	110180.0
2015-04-22 12:00:00	ES	Futures	2215.42	2217.0	2212.25	2215.95	71496.0
2015-04-22 13:00:00	ES	Futures	2215.95	2220.44	2214.36	2219.38	80345.0
2015-04-22 14:00:00	ES	Futures	2219.38	2221.49	2218.85	2219.65	70199.0
2015-04-22 15:00:00	ES	Futures	2219.65	2222.55	2217.8	2219.91	197960.0
2015-04-22 16:00:00	ES	Futures	2220.17	2220.17	2217.27	2218.06	61471.0
2015-04-22 17:00:00	ES	Futures	2218.06	2218.06	2217.27	2217.53	1445.0
2015-04-22 18:00:00	ES	Futures	2217.8	2219.38	2217.53	2218.85	2686.0
2015-04-22 19:00:00	ES	Futures	2218.85	2219.38	2218.33	2218.85	1083.0
2015-04-22 20:00:00	ES	Futures	2218.59	2218.85	2216.74	2217.8	4762.0
2015-04-22 21:00:00	ES	Futures	2218.06	2218.06	2216.48	2217.0	2259.0
2015-04-22 22:00:00	ES	Futures	2217.27	2217.53	2216.48	2216.74	1615.0
2015-04-22 23:00:00	ES	Futures	2216.74	2217.53	2216.48	2217.27	1216.0
2015-04-22 00:00:00	NQ	Futures	5216.1	5216.69	5214.33	5215.51	319.0
2015-04-22 01:00:00	NQ	Futures	5215.51	5215.8	5214.04	5214.92	300.0
2015-04-22 02:00:00	NQ	Futures	5214.92	5221.98	5214.33	5221.1	954.0
2015-04-22 03:00:00	NQ	Futures	5221.39	5229.92	5214.63	5219.33	5181.0
2015-04-22 04:00:00	NQ	Futures	5219.04	5219.33	5173.75	5183.16	12516.0
2015-04-22 05:00:00	NQ	Futures	5183.16	5197.28	5177.28	5192.57	4754.0
2015-04-22 06:00:00	NQ	Futures	5192.28	5193.16	5177.87	5192.87	3927.0
2015-04-22 07:00:00	NQ	Futures	5193.46	5204.34	5192.57	5201.98	2544.0
2015-04-22 08:00:00	NQ	Futures	5202.28	5217.57	5199.63	5216.98	4691.0
2015-04-22 09:00:00	NQ	Futures	5217.28	5226.1	5199.63	5206.98	28451.0
2015-04-22 10:00:00	NQ	Futures	5207.28	5216.1	5188.16	5214.92	36811.0
2015-04-22 11:00:00	NQ	Futures	5214.63	5223.74	5213.16	5223.16	17734.0
2015-04-22 12:00:00	NQ	Futures	5223.16	5225.21	5215.8	5222.57	9868.0
2015-04-22 13:00:00	NQ	Futures	5222.57	5231.68	5217.57	5229.63	12862.0
2015-04-22 14:00:00	NQ	Futures	5229.92	5239.04	5228.16	5236.68	11893.0
2015-04-22 15:00:00	NQ	Futures	5236.98	5245.51	5233.45	5236.98	31787.0
2015-04-22 16:00:00	NQ	Futures	5236.98	5237.27	5219.63	5220.22	8931.0
2015-04-22 17:00:00	NQ	Futures	5220.22	5220.8	5219.04	5219.04	434.0
2015-04-22 18:00:00	NQ	Futures	5220.8	5227.57	5220.22	5227.57	659.0
2015-04-22 19:00:00	NQ	Futures	5226.98	5228.16	5226.98	5227.57	320.0
2015-04-22 20:00:00	NQ	Futures	5227.27	5227.27	5222.86	5224.63	632.0
2015-04-22 21:00:00	NQ	Futures	5224.63	5224.63	5222.57	5223.74	275.0
2015-04-22 22:00:00	NQ	Futures	5223.74	5225.51	5221.69	5222.86	310.0
2015-04-22 23:00:00	NQ	Futures	5222.57	5225.51	5222.57	5224.33	128.0
2015-04-22 00:00:00	YM	Futures	18769.0	18774.3	18765.9	18770.1	706.0
2015-04-22 01:00:00	YM	Futures	18770.1	18770.1	18761.7	18765.9	815.0

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

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