PREVIEW / futures_1hour / 2016-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-21.parquet
  size:    52 KB
  rows:    1,600

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
2016-03-21 00:00:00	ES	Futures	2196.56	2197.1	2195.48	2195.75	1096.0
2016-03-21 01:00:00	ES	Futures	2195.75	2197.1	2195.21	2195.48	2223.0
2016-03-21 02:00:00	ES	Futures	2195.48	2196.02	2194.94	2195.21	2102.0
2016-03-21 03:00:00	ES	Futures	2194.94	2196.29	2194.13	2195.48	8483.0
2016-03-21 04:00:00	ES	Futures	2195.48	2200.34	2193.32	2197.64	31294.0
2016-03-21 05:00:00	ES	Futures	2197.64	2207.63	2197.1	2204.39	35824.0
2016-03-21 06:00:00	ES	Futures	2204.39	2205.47	2201.69	2201.69	15511.0
2016-03-21 07:00:00	ES	Futures	2201.69	2203.31	2200.07	2202.77	15496.0
2016-03-21 08:00:00	ES	Futures	2202.5	2203.04	2196.02	2198.18	38700.0
2016-03-21 09:00:00	ES	Futures	2198.45	2204.66	2197.37	2203.04	167814.0
2016-03-21 10:00:00	ES	Futures	2203.04	2204.66	2195.21	2196.83	250542.0
2016-03-21 11:00:00	ES	Futures	2196.83	2204.39	2196.56	2201.69	140243.0
2016-03-21 12:00:00	ES	Futures	2201.69	2202.77	2198.99	2201.42	114274.0
2016-03-21 13:00:00	ES	Futures	2201.69	2206.28	2200.88	2204.93	109593.0
2016-03-21 14:00:00	ES	Futures	2204.93	2207.9	2203.31	2206.82	115775.0
2016-03-21 15:00:00	ES	Futures	2207.09	2207.09	2202.5	2204.93	149282.0
2016-03-21 16:00:00	ES	Futures	2204.93	2207.09	2203.85	2206.55	45606.0
2016-03-21 18:00:00	ES	Futures	2206.55	2207.36	2205.47	2205.74	3177.0
2016-03-21 19:00:00	ES	Futures	2205.74	2205.74	2203.31	2205.2	4144.0
2016-03-21 20:00:00	ES	Futures	2205.2	2208.17	2204.93	2206.28	6967.0
2016-03-21 21:00:00	ES	Futures	2206.28	2206.28	2204.39	2205.47	5205.0
2016-03-21 22:00:00	ES	Futures	2205.2	2206.01	2204.39	2204.66	2416.0
2016-03-21 23:00:00	ES	Futures	2204.39	2204.93	2201.96	2202.5	5372.0
2016-03-21 00:00:00	NQ	Futures	5216.89	5218.37	5213.91	5214.21	358.0
2016-03-21 01:00:00	NQ	Futures	5214.51	5218.97	5212.72	5213.61	626.0
2016-03-21 02:00:00	NQ	Futures	5213.61	5214.8	5212.13	5213.61	529.0
2016-03-21 03:00:00	NQ	Futures	5213.32	5217.78	5211.83	5215.4	1605.0
2016-03-21 04:00:00	NQ	Futures	5215.1	5229.38	5208.85	5223.13	3858.0
2016-03-21 05:00:00	NQ	Futures	5223.13	5253.18	5221.35	5241.88	5392.0
2016-03-21 06:00:00	NQ	Futures	5241.58	5245.75	5235.93	5236.52	2224.0
2016-03-21 07:00:00	NQ	Futures	5236.23	5239.2	5231.17	5237.12	1780.0
2016-03-21 08:00:00	NQ	Futures	5236.82	5238.01	5221.05	5225.51	4640.0
2016-03-21 09:00:00	NQ	Futures	5225.81	5251.1	5224.62	5245.75	24782.0
2016-03-21 10:00:00	NQ	Futures	5246.34	5250.8	5223.43	5228.49	31428.0
2016-03-21 11:00:00	NQ	Futures	5228.49	5249.91	5227.6	5245.45	20687.0
2016-03-21 12:00:00	NQ	Futures	5244.85	5245.75	5235.93	5242.77	12307.0
2016-03-21 13:00:00	NQ	Futures	5243.07	5257.05	5239.8	5249.91	15665.0
2016-03-21 14:00:00	NQ	Futures	5250.21	5261.81	5245.15	5259.14	14540.0
2016-03-21 15:00:00	NQ	Futures	5258.84	5259.14	5243.96	5256.75	19528.0
2016-03-21 16:00:00	NQ	Futures	5256.75	5258.24	5252.29	5255.56	6086.0
2016-03-21 18:00:00	NQ	Futures	5255.56	5257.94	5252.59	5254.37	508.0
2016-03-21 19:00:00	NQ	Futures	5254.67	5254.67	5249.02	5252.89	455.0
2016-03-21 20:00:00	NQ	Futures	5253.48	5260.92	5252.89	5257.35	719.0
2016-03-21 21:00:00	NQ	Futures	5257.05	5257.35	5251.4	5255.27	764.0
2016-03-21 22:00:00	NQ	Futures	5254.37	5255.56	5250.8	5251.4	253.0
2016-03-21 23:00:00	NQ	Futures	5251.1	5252.89	5244.85	5245.15	741.0
2016-03-21 00:00:00	YM	Futures	18692.2	18698.6	18685.8	18686.9	190.0
2016-03-21 01:00:00	YM	Futures	18687.9	18697.6	18682.6	18686.9	379.0
2016-03-21 02:00:00	YM	Futures	18685.8	18690.1	18679.4	18685.8	397.0
2016-03-21 03:00:00	YM	Futures	18685.8	18694.4	18676.2	18684.7	656.0

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

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