PREVIEW / futures_1hour / 2014-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-05.parquet
  size:    41 KB
  rows:    1,253

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
2014-09-05 00:00:00	ES	Futures	2079.96	2080.74	2079.7	2080.48	2943.0
2014-09-05 01:00:00	ES	Futures	2080.48	2081.26	2079.7	2079.96	3186.0
2014-09-05 02:00:00	ES	Futures	2079.96	2083.35	2078.92	2082.83	12462.0
2014-09-05 03:00:00	ES	Futures	2082.57	2082.83	2078.92	2079.18	29665.0
2014-09-05 04:00:00	ES	Futures	2079.44	2079.7	2077.61	2077.88	25255.0
2014-09-05 05:00:00	ES	Futures	2077.88	2078.66	2075.27	2075.79	20901.0
2014-09-05 06:00:00	ES	Futures	2075.79	2075.79	2073.18	2075.79	36735.0
2014-09-05 07:00:00	ES	Futures	2075.79	2076.83	2074.23	2076.05	22891.0
2014-09-05 08:00:00	ES	Futures	2076.05	2084.13	2073.44	2078.92	174188.0
2014-09-05 09:00:00	ES	Futures	2078.66	2082.05	2074.23	2080.48	272583.0
2014-09-05 10:00:00	ES	Futures	2080.74	2081.52	2072.66	2076.83	279529.0
2014-09-05 11:00:00	ES	Futures	2076.57	2082.83	2076.05	2081.52	155212.0
2014-09-05 12:00:00	ES	Futures	2081.52	2087.0	2081.0	2085.95	134808.0
2014-09-05 13:00:00	ES	Futures	2085.95	2088.3	2084.91	2086.48	89374.0
2014-09-05 14:00:00	ES	Futures	2086.48	2089.34	2086.21	2087.78	110871.0
2014-09-05 15:00:00	ES	Futures	2087.78	2091.43	2087.26	2090.65	174766.0
2014-09-05 16:00:00	ES	Futures	2090.65	2092.47	2089.86	2092.21	89884.0
2014-09-05 17:00:00	ES	Futures	2092.21	2092.99	2091.95	2092.73	2102.0
2014-09-05 00:00:00	NQ	Futures	4747.57	4750.49	4746.99	4749.91	755.0
2014-09-05 01:00:00	NQ	Futures	4749.91	4752.25	4747.87	4749.33	1202.0
2014-09-05 02:00:00	NQ	Futures	4749.03	4758.67	4747.87	4757.21	1951.0
2014-09-05 03:00:00	NQ	Futures	4757.5	4757.8	4747.87	4749.03	3596.0
2014-09-05 04:00:00	NQ	Futures	4749.62	4749.91	4745.53	4746.11	3055.0
2014-09-05 05:00:00	NQ	Futures	4746.41	4748.16	4741.15	4741.73	3079.0
2014-09-05 06:00:00	NQ	Futures	4742.03	4743.49	4736.77	4743.49	5731.0
2014-09-05 07:00:00	NQ	Futures	4743.19	4747.87	4742.32	4747.57	2998.0
2014-09-05 08:00:00	NQ	Futures	4747.57	4765.68	4743.19	4756.04	24959.0
2014-09-05 09:00:00	NQ	Futures	4756.04	4761.59	4733.56	4754.88	60691.0
2014-09-05 10:00:00	NQ	Futures	4755.17	4758.09	4732.97	4740.57	53803.0
2014-09-05 11:00:00	NQ	Futures	4740.57	4751.66	4737.94	4749.33	30687.0
2014-09-05 12:00:00	NQ	Futures	4749.33	4762.18	4747.28	4758.96	23009.0
2014-09-05 13:00:00	NQ	Futures	4758.96	4765.68	4757.21	4762.47	14457.0
2014-09-05 14:00:00	NQ	Futures	4762.18	4769.48	4761.88	4766.85	15319.0
2014-09-05 15:00:00	NQ	Futures	4766.56	4776.78	4764.51	4775.02	22869.0
2014-09-05 16:00:00	NQ	Futures	4774.73	4779.11	4771.81	4777.07	7601.0
2014-09-05 17:00:00	NQ	Futures	4776.78	4778.53	4776.19	4777.65	302.0
2014-09-05 00:00:00	YM	Futures	17649.7	17653.8	17646.6	17653.8	700.0
2014-09-05 01:00:00	YM	Futures	17653.8	17665.2	17646.6	17647.6	1894.0
2014-09-05 02:00:00	YM	Futures	17647.6	17677.6	17643.5	17673.5	1399.0
2014-09-05 03:00:00	YM	Futures	17673.5	17674.5	17643.5	17646.6	3389.0
2014-09-05 04:00:00	YM	Futures	17646.6	17648.7	17634.2	17636.3	2968.0
2014-09-05 05:00:00	YM	Futures	17636.3	17640.4	17614.5	17617.6	2433.0
2014-09-05 06:00:00	YM	Futures	17617.6	17618.7	17598.0	17615.6	4493.0
2014-09-05 07:00:00	YM	Futures	17613.5	17624.9	17603.2	17611.4	3047.0
2014-09-05 08:00:00	YM	Futures	17613.5	17674.5	17594.9	17630.1	16868.0
2014-09-05 09:00:00	YM	Futures	17631.1	17649.7	17599.0	17635.2	23127.0
2014-09-05 10:00:00	YM	Futures	17635.2	17639.4	17583.5	17610.4	26843.0
2014-09-05 11:00:00	YM	Futures	17611.4	17664.2	17605.2	17653.8	16459.0
2014-09-05 12:00:00	YM	Futures	17654.9	17694.2	17648.7	17684.9	15069.0
2014-09-05 13:00:00	YM	Futures	17683.8	17701.4	17677.6	17684.9	10096.0

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

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