PREVIEW / futures_1hour / 2015-03-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	2216.26	2216.53	2215.74	2215.74	1189.0
2015-03-02 01:00:00	ES	Futures	2215.74	2216.26	2215.48	2215.74	1186.0
2015-03-02 02:00:00	ES	Futures	2215.48	2216.26	2215.21	2215.21	3675.0
2015-03-02 03:00:00	ES	Futures	2215.48	2220.21	2214.95	2216.79	21295.0
2015-03-02 04:00:00	ES	Futures	2217.05	2217.58	2215.74	2216.53	11759.0
2015-03-02 05:00:00	ES	Futures	2216.79	2217.58	2216.0	2216.53	4569.0
2015-03-02 06:00:00	ES	Futures	2216.79	2216.79	2213.63	2214.42	10925.0
2015-03-02 07:00:00	ES	Futures	2214.42	2215.21	2212.58	2213.37	13986.0
2015-03-02 08:00:00	ES	Futures	2213.37	2213.9	2211.27	2211.53	18764.0
2015-03-02 09:00:00	ES	Futures	2211.79	2218.9	2211.0	2218.37	136433.0
2015-03-02 10:00:00	ES	Futures	2218.37	2223.63	2218.11	2222.32	207037.0
2015-03-02 11:00:00	ES	Futures	2222.05	2223.9	2219.95	2221.53	131978.0
2015-03-02 12:00:00	ES	Futures	2221.79	2222.05	2217.84	2219.95	87563.0
2015-03-02 13:00:00	ES	Futures	2220.21	2222.58	2219.42	2222.05	66274.0
2015-03-02 14:00:00	ES	Futures	2222.32	2223.11	2219.69	2222.58	74215.0
2015-03-02 15:00:00	ES	Futures	2222.58	2226.79	2222.05	2226.53	178385.0
2015-03-02 16:00:00	ES	Futures	2226.53	2226.53	2224.69	2225.48	66766.0
2015-03-02 17:00:00	ES	Futures	2225.74	2226.0	2225.48	2225.48	1980.0
2015-03-02 18:00:00	ES	Futures	2225.21	2225.74	2224.69	2225.21	4144.0
2015-03-02 19:00:00	ES	Futures	2225.21	2225.48	2224.42	2224.69	1999.0
2015-03-02 20:00:00	ES	Futures	2224.69	2224.95	2223.63	2223.9	4717.0
2015-03-02 21:00:00	ES	Futures	2223.9	2223.9	2222.05	2223.11	6944.0
2015-03-02 22:00:00	ES	Futures	2223.11	2223.9	2223.11	2223.63	2010.0
2015-03-02 23:00:00	ES	Futures	2223.37	2224.16	2223.37	2223.9	1763.0
2015-03-02 00:00:00	NQ	Futures	5227.65	5228.24	5226.77	5227.65	145.0
2015-03-02 01:00:00	NQ	Futures	5227.36	5227.95	5226.48	5226.77	202.0
2015-03-02 02:00:00	NQ	Futures	5226.77	5227.36	5224.72	5225.6	606.0
2015-03-02 03:00:00	NQ	Futures	5225.6	5237.05	5224.72	5230.59	4540.0
2015-03-02 04:00:00	NQ	Futures	5230.59	5234.41	5226.77	5232.65	2031.0
2015-03-02 05:00:00	NQ	Futures	5232.65	5234.11	5230.59	5232.35	792.0
2015-03-02 06:00:00	NQ	Futures	5232.06	5232.35	5224.42	5225.89	2196.0
2015-03-02 07:00:00	NQ	Futures	5226.19	5228.53	5223.84	5225.3	2072.0
2015-03-02 08:00:00	NQ	Futures	5225.6	5227.36	5223.54	5225.6	3376.0
2015-03-02 09:00:00	NQ	Futures	5225.6	5250.56	5224.42	5248.8	31343.0
2015-03-02 10:00:00	NQ	Futures	5249.39	5259.08	5246.16	5251.15	35267.0
2015-03-02 11:00:00	NQ	Futures	5251.15	5261.13	5246.45	5256.14	20808.0
2015-03-02 12:00:00	NQ	Futures	5256.43	5257.9	5240.87	5247.33	16116.0
2015-03-02 13:00:00	NQ	Futures	5247.62	5250.56	5238.52	5250.56	14211.0
2015-03-02 14:00:00	NQ	Futures	5250.56	5254.67	5245.86	5254.38	14544.0
2015-03-02 15:00:00	NQ	Futures	5254.67	5266.71	5252.91	5265.25	27388.0
2015-03-02 16:00:00	NQ	Futures	5265.25	5265.54	5258.49	5261.43	6024.0
2015-03-02 17:00:00	NQ	Futures	5261.13	5262.6	5261.13	5261.72	112.0
2015-03-02 18:00:00	NQ	Futures	5261.72	5261.72	5259.37	5261.13	300.0
2015-03-02 19:00:00	NQ	Futures	5260.84	5261.13	5259.96	5260.55	214.0
2015-03-02 20:00:00	NQ	Futures	5260.55	5260.55	5257.61	5258.2	431.0
2015-03-02 21:00:00	NQ	Futures	5257.61	5258.49	5255.26	5257.32	677.0
2015-03-02 22:00:00	NQ	Futures	5257.02	5258.78	5257.02	5257.9	158.0
2015-03-02 23:00:00	NQ	Futures	5257.61	5259.37	5257.32	5257.9	193.0
2015-03-02 00:00:00	YM	Futures	18947.4	18949.5	18943.2	18944.3	164.0
2015-03-02 01:00:00	YM	Futures	18944.3	18947.4	18940.1	18941.2	295.0

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

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