PREVIEW / futures_1hour / 2015-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-24.parquet
  size:    50 KB
  rows:    1,553

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-03-24 00:00:00	ES	Futures	2215.68	2215.68	2213.84	2214.89	2528.0
2015-03-24 01:00:00	ES	Futures	2214.89	2215.16	2213.04	2213.57	3419.0
2015-03-24 02:00:00	ES	Futures	2213.84	2214.63	2213.57	2214.1	1249.0
2015-03-24 03:00:00	ES	Futures	2214.1	2214.89	2211.72	2213.04	9756.0
2015-03-24 04:00:00	ES	Futures	2213.04	2217.8	2209.87	2215.16	25071.0
2015-03-24 05:00:00	ES	Futures	2215.42	2217.27	2214.1	2217.27	12996.0
2015-03-24 06:00:00	ES	Futures	2217.0	2219.65	2216.21	2217.8	15192.0
2015-03-24 07:00:00	ES	Futures	2217.8	2219.38	2215.42	2218.59	18808.0
2015-03-24 08:00:00	ES	Futures	2218.85	2219.12	2214.89	2216.48	33928.0
2015-03-24 09:00:00	ES	Futures	2216.21	2216.48	2208.55	2214.1	165190.0
2015-03-24 10:00:00	ES	Futures	2214.1	2217.0	2212.78	2214.63	190903.0
2015-03-24 11:00:00	ES	Futures	2214.36	2218.85	2213.04	2216.21	106881.0
2015-03-24 12:00:00	ES	Futures	2216.21	2217.53	2209.35	2209.61	112869.0
2015-03-24 13:00:00	ES	Futures	2209.61	2211.72	2206.18	2209.35	100737.0
2015-03-24 14:00:00	ES	Futures	2209.35	2209.35	2203.27	2206.18	116363.0
2015-03-24 15:00:00	ES	Futures	2206.18	2209.08	2200.63	2201.42	187793.0
2015-03-24 16:00:00	ES	Futures	2201.42	2203.53	2200.63	2202.74	64591.0
2015-03-24 17:00:00	ES	Futures	2203.01	2203.27	2202.48	2203.01	1621.0
2015-03-24 18:00:00	ES	Futures	2203.01	2203.53	2202.74	2203.01	2610.0
2015-03-24 19:00:00	ES	Futures	2203.27	2203.8	2202.48	2203.53	1607.0
2015-03-24 20:00:00	ES	Futures	2203.27	2204.06	2203.27	2203.27	2944.0
2015-03-24 21:00:00	ES	Futures	2203.27	2203.8	2202.74	2203.01	1962.0
2015-03-24 22:00:00	ES	Futures	2203.01	2203.27	2202.21	2202.48	1704.0
2015-03-24 23:00:00	ES	Futures	2202.74	2202.74	2201.42	2201.42	4278.0
2015-03-24 00:00:00	NQ	Futures	5226.39	5227.57	5222.57	5225.51	678.0
2015-03-24 01:00:00	NQ	Futures	5225.21	5225.51	5220.8	5223.16	406.0
2015-03-24 02:00:00	NQ	Futures	5222.86	5224.63	5222.86	5223.16	170.0
2015-03-24 03:00:00	NQ	Futures	5223.16	5223.74	5215.8	5219.04	1521.0
2015-03-24 04:00:00	NQ	Futures	5218.75	5230.21	5212.28	5226.1	4695.0
2015-03-24 05:00:00	NQ	Futures	5226.1	5230.21	5221.98	5229.92	2030.0
2015-03-24 06:00:00	NQ	Futures	5229.63	5234.04	5226.39	5229.63	3008.0
2015-03-24 07:00:00	NQ	Futures	5229.33	5233.74	5225.8	5232.27	3047.0
2015-03-24 08:00:00	NQ	Futures	5232.57	5232.57	5224.63	5226.39	4538.0
2015-03-24 09:00:00	NQ	Futures	5226.69	5229.04	5213.16	5228.45	32212.0
2015-03-24 10:00:00	NQ	Futures	5228.16	5241.39	5227.86	5239.33	29585.0
2015-03-24 11:00:00	NQ	Futures	5239.33	5247.27	5235.8	5243.45	14239.0
2015-03-24 12:00:00	NQ	Futures	5243.15	5245.21	5225.21	5225.21	16986.0
2015-03-24 13:00:00	NQ	Futures	5225.21	5231.68	5214.92	5223.45	16928.0
2015-03-24 14:00:00	NQ	Futures	5223.45	5223.45	5207.57	5214.63	17603.0
2015-03-24 15:00:00	NQ	Futures	5214.92	5222.57	5204.04	5205.51	26792.0
2015-03-24 16:00:00	NQ	Futures	5205.22	5211.39	5204.04	5210.22	5402.0
2015-03-24 17:00:00	NQ	Futures	5210.22	5211.1	5209.34	5210.22	171.0
2015-03-24 18:00:00	NQ	Futures	5209.92	5211.98	5209.34	5211.69	347.0
2015-03-24 19:00:00	NQ	Futures	5211.69	5214.63	5211.1	5214.04	425.0
2015-03-24 20:00:00	NQ	Futures	5214.04	5215.51	5213.45	5213.75	439.0
2015-03-24 21:00:00	NQ	Futures	5213.75	5214.92	5212.28	5212.57	401.0
2015-03-24 22:00:00	NQ	Futures	5212.86	5213.45	5210.22	5211.1	476.0
2015-03-24 23:00:00	NQ	Futures	5210.81	5211.98	5209.34	5210.81	500.0
2015-03-24 00:00:00	YM	Futures	18925.3	18925.3	18906.4	18916.9	974.0
2015-03-24 01:00:00	YM	Futures	18915.8	18915.8	18888.6	18901.2	2056.0

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

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