PREVIEW / futures_1hour / 2014-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-27.parquet
  size:    36 KB
  rows:    1,037

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-11-27 00:00:00	ES	Futures	2171.71	2172.23	2171.45	2171.45	739.0
2014-11-27 01:00:00	ES	Futures	2171.71	2171.97	2171.45	2171.71	796.0
2014-11-27 02:00:00	ES	Futures	2171.45	2171.71	2169.09	2169.61	4981.0
2014-11-27 03:00:00	ES	Futures	2169.35	2169.61	2167.26	2169.09	9607.0
2014-11-27 04:00:00	ES	Futures	2169.35	2171.19	2168.83	2171.19	7371.0
2014-11-27 05:00:00	ES	Futures	2170.92	2171.45	2168.57	2168.57	4323.0
2014-11-27 06:00:00	ES	Futures	2168.57	2169.88	2168.3	2169.35	2987.0
2014-11-27 07:00:00	ES	Futures	2169.61	2170.66	2168.83	2170.66	2751.0
2014-11-27 08:00:00	ES	Futures	2170.66	2172.76	2170.4	2171.97	5354.0
2014-11-27 09:00:00	ES	Futures	2172.23	2173.02	2170.92	2171.71	6437.0
2014-11-27 10:00:00	ES	Futures	2171.97	2172.5	2169.88	2172.5	7374.0
2014-11-27 11:00:00	ES	Futures	2172.5	2173.02	2170.4	2172.5	9430.0
2014-11-27 12:00:00	ES	Futures	2172.5	2173.54	2171.71	2173.28	5594.0
2014-11-27 18:00:00	ES	Futures	2171.45	2171.97	2168.83	2170.14	4905.0
2014-11-27 19:00:00	ES	Futures	2170.14	2172.5	2170.14	2171.97	2462.0
2014-11-27 20:00:00	ES	Futures	2171.97	2172.23	2171.45	2171.71	1625.0
2014-11-27 21:00:00	ES	Futures	2171.71	2171.71	2170.4	2171.19	1483.0
2014-11-27 22:00:00	ES	Futures	2171.19	2172.5	2170.66	2172.23	1794.0
2014-11-27 23:00:00	ES	Futures	2171.97	2172.5	2171.97	2171.97	1068.0
2014-11-27 00:00:00	NQ	Futures	5062.85	5064.02	5062.26	5062.85	229.0
2014-11-27 01:00:00	NQ	Futures	5062.85	5063.72	5061.97	5062.55	254.0
2014-11-27 02:00:00	NQ	Futures	5062.26	5062.26	5056.4	5057.28	656.0
2014-11-27 03:00:00	NQ	Futures	5057.28	5060.5	5054.35	5060.5	1302.0
2014-11-27 04:00:00	NQ	Futures	5060.79	5064.02	5059.92	5062.55	699.0
2014-11-27 05:00:00	NQ	Futures	5062.55	5063.14	5059.92	5061.97	665.0
2014-11-27 06:00:00	NQ	Futures	5061.67	5062.85	5060.21	5061.67	315.0
2014-11-27 07:00:00	NQ	Futures	5061.38	5063.43	5059.92	5063.43	258.0
2014-11-27 08:00:00	NQ	Futures	5062.85	5067.53	5062.26	5065.48	923.0
2014-11-27 09:00:00	NQ	Futures	5065.48	5076.03	5061.38	5066.95	3009.0
2014-11-27 10:00:00	NQ	Futures	5067.53	5073.69	5062.55	5073.69	1576.0
2014-11-27 11:00:00	NQ	Futures	5073.69	5076.03	5069.29	5074.86	1914.0
2014-11-27 12:00:00	NQ	Futures	5074.57	5077.2	5072.52	5076.62	1248.0
2014-11-27 18:00:00	NQ	Futures	5073.98	5076.91	5066.95	5071.64	1438.0
2014-11-27 19:00:00	NQ	Futures	5071.93	5074.86	5071.64	5074.27	438.0
2014-11-27 20:00:00	NQ	Futures	5074.27	5074.57	5072.22	5074.27	472.0
2014-11-27 21:00:00	NQ	Futures	5073.98	5074.27	5069.58	5070.46	683.0
2014-11-27 22:00:00	NQ	Futures	5070.76	5073.98	5070.76	5072.22	429.0
2014-11-27 23:00:00	NQ	Futures	5072.81	5074.86	5072.52	5073.39	321.0
2014-11-27 00:00:00	YM	Futures	18523.4	18526.5	18520.3	18520.3	159.0
2014-11-27 01:00:00	YM	Futures	18522.3	18529.6	18520.3	18527.5	383.0
2014-11-27 02:00:00	YM	Futures	18526.5	18526.5	18509.9	18514.0	334.0
2014-11-27 03:00:00	YM	Futures	18514.0	18515.1	18493.2	18510.9	1390.0
2014-11-27 04:00:00	YM	Futures	18511.9	18530.7	18508.8	18525.5	1565.0
2014-11-27 05:00:00	YM	Futures	18526.5	18528.6	18505.7	18509.9	561.0
2014-11-27 06:00:00	YM	Futures	18509.9	18516.1	18505.7	18514.0	391.0
2014-11-27 07:00:00	YM	Futures	18514.0	18527.5	18511.9	18525.5	516.0
2014-11-27 08:00:00	YM	Futures	18524.4	18536.9	18524.4	18532.7	622.0
2014-11-27 09:00:00	YM	Futures	18533.8	18543.1	18528.6	18536.9	1049.0
2014-11-27 10:00:00	YM	Futures	18537.9	18544.2	18514.0	18542.1	1695.0
2014-11-27 11:00:00	YM	Futures	18542.1	18553.5	18528.6	18544.2	1590.0

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

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