PREVIEW / futures_1hour / 2014-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-16.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
2014-09-16 00:00:00	ES	Futures	2070.33	2070.85	2070.07	2070.59	1241.0
2014-09-16 01:00:00	ES	Futures	2070.85	2071.11	2070.59	2070.85	2175.0
2014-09-16 02:00:00	ES	Futures	2070.59	2070.85	2069.28	2069.8	5888.0
2014-09-16 03:00:00	ES	Futures	2069.8	2070.07	2067.45	2068.23	21032.0
2014-09-16 04:00:00	ES	Futures	2068.23	2069.02	2066.92	2067.45	10675.0
2014-09-16 05:00:00	ES	Futures	2067.45	2069.8	2067.45	2069.8	11342.0
2014-09-16 06:00:00	ES	Futures	2069.54	2069.8	2066.4	2067.97	16751.0
2014-09-16 07:00:00	ES	Futures	2067.71	2069.28	2067.18	2067.97	14475.0
2014-09-16 08:00:00	ES	Futures	2068.23	2068.49	2066.4	2067.71	24229.0
2014-09-16 09:00:00	ES	Futures	2067.97	2073.47	2064.56	2073.21	228985.0
2014-09-16 10:00:00	ES	Futures	2072.95	2076.35	2072.42	2073.21	219230.0
2014-09-16 11:00:00	ES	Futures	2072.95	2084.74	2071.11	2083.16	268943.0
2014-09-16 12:00:00	ES	Futures	2083.16	2086.57	2081.59	2084.74	156225.0
2014-09-16 13:00:00	ES	Futures	2084.74	2089.98	2084.47	2088.4	132887.0
2014-09-16 14:00:00	ES	Futures	2088.14	2089.71	2087.36	2087.88	91505.0
2014-09-16 15:00:00	ES	Futures	2087.88	2089.19	2086.05	2086.31	159632.0
2014-09-16 16:00:00	ES	Futures	2086.57	2087.36	2086.31	2087.09	79004.0
2014-09-16 17:00:00	ES	Futures	2086.83	2087.09	2086.83	2087.09	3069.0
2014-09-16 18:00:00	ES	Futures	2086.83	2087.62	2086.31	2086.31	5022.0
2014-09-16 19:00:00	ES	Futures	2086.31	2087.09	2086.31	2086.83	1137.0
2014-09-16 20:00:00	ES	Futures	2087.09	2087.09	2085.52	2085.52	2610.0
2014-09-16 21:00:00	ES	Futures	2085.52	2086.05	2084.21	2085.52	5433.0
2014-09-16 22:00:00	ES	Futures	2085.52	2086.05	2085.26	2085.52	2412.0
2014-09-16 23:00:00	ES	Futures	2085.52	2086.05	2085.26	2086.05	1215.0
2014-09-16 00:00:00	NQ	Futures	4716.51	4718.27	4715.93	4718.27	240.0
2014-09-16 01:00:00	NQ	Futures	4718.27	4719.15	4717.98	4718.27	277.0
2014-09-16 02:00:00	NQ	Futures	4717.98	4718.27	4713.58	4713.88	1362.0
2014-09-16 03:00:00	NQ	Futures	4714.17	4714.46	4706.26	4707.72	4918.0
2014-09-16 04:00:00	NQ	Futures	4707.72	4709.48	4703.62	4705.09	2790.0
2014-09-16 05:00:00	NQ	Futures	4705.09	4711.24	4705.09	4710.95	3557.0
2014-09-16 06:00:00	NQ	Futures	4711.24	4711.24	4701.57	4710.07	4213.0
2014-09-16 07:00:00	NQ	Futures	4710.07	4713.29	4707.43	4708.31	3051.0
2014-09-16 08:00:00	NQ	Futures	4708.31	4708.6	4702.45	4707.72	7424.0
2014-09-16 09:00:00	NQ	Futures	4708.02	4719.74	4693.07	4715.05	59269.0
2014-09-16 10:00:00	NQ	Futures	4715.05	4727.65	4711.24	4713.88	48727.0
2014-09-16 11:00:00	NQ	Futures	4713.88	4742.0	4706.26	4739.07	48308.0
2014-09-16 12:00:00	NQ	Futures	4739.07	4747.57	4735.27	4741.13	27322.0
2014-09-16 13:00:00	NQ	Futures	4741.42	4759.88	4741.42	4754.02	26008.0
2014-09-16 14:00:00	NQ	Futures	4754.31	4762.81	4752.85	4758.71	17127.0
2014-09-16 15:00:00	NQ	Futures	4758.41	4766.03	4756.07	4756.65	31689.0
2014-09-16 16:00:00	NQ	Futures	4756.65	4758.41	4755.19	4757.24	8892.0
2014-09-16 17:00:00	NQ	Futures	4757.24	4757.53	4755.78	4755.78	470.0
2014-09-16 18:00:00	NQ	Futures	4753.72	4757.53	4753.72	4753.72	1181.0
2014-09-16 19:00:00	NQ	Futures	4754.02	4756.07	4753.72	4756.07	405.0
2014-09-16 20:00:00	NQ	Futures	4755.78	4755.78	4751.97	4751.97	555.0
2014-09-16 21:00:00	NQ	Futures	4752.26	4753.14	4749.62	4752.26	562.0
2014-09-16 22:00:00	NQ	Futures	4752.26	4753.43	4751.67	4753.14	228.0
2014-09-16 23:00:00	NQ	Futures	4753.43	4753.43	4752.26	4753.14	134.0
2014-09-16 00:00:00	YM	Futures	17616.7	17617.7	17611.5	17616.7	656.0
2014-09-16 01:00:00	YM	Futures	17616.7	17620.9	17615.7	17617.7	430.0

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

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