PREVIEW / futures_1hour / 2014-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-28.parquet
  size:    35 KB
  rows:    985

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-28 00:00:00	ES	Futures	2172.23	2172.23	2171.45	2171.97	1072.0
2014-11-28 01:00:00	ES	Futures	2171.97	2172.23	2171.45	2171.71	1299.0
2014-11-28 02:00:00	ES	Futures	2171.71	2172.23	2170.92	2171.45	4517.0
2014-11-28 03:00:00	ES	Futures	2171.19	2171.45	2165.95	2165.95	18952.0
2014-11-28 04:00:00	ES	Futures	2165.95	2168.57	2165.68	2166.21	11606.0
2014-11-28 05:00:00	ES	Futures	2166.21	2166.99	2164.9	2165.68	11802.0
2014-11-28 06:00:00	ES	Futures	2165.68	2167.52	2165.16	2167.26	8485.0
2014-11-28 07:00:00	ES	Futures	2167.26	2169.61	2166.73	2169.35	9104.0
2014-11-28 08:00:00	ES	Futures	2169.35	2170.92	2166.99	2169.61	16876.0
2014-11-28 09:00:00	ES	Futures	2169.61	2170.14	2165.68	2170.14	111583.0
2014-11-28 10:00:00	ES	Futures	2169.88	2171.97	2168.57	2170.4	110340.0
2014-11-28 11:00:00	ES	Futures	2170.4	2172.5	2169.09	2169.35	104400.0
2014-11-28 12:00:00	ES	Futures	2169.35	2169.35	2162.28	2165.95	188610.0
2014-11-28 13:00:00	ES	Futures	2165.68	2166.99	2163.59	2165.68	87482.0
2014-11-28 00:00:00	NQ	Futures	5073.69	5075.74	5073.39	5075.74	271.0
2014-11-28 01:00:00	NQ	Futures	5075.74	5076.62	5074.86	5076.03	311.0
2014-11-28 02:00:00	NQ	Futures	5075.74	5076.62	5073.98	5073.98	327.0
2014-11-28 03:00:00	NQ	Futures	5074.27	5074.27	5061.67	5061.97	2428.0
2014-11-28 04:00:00	NQ	Futures	5061.97	5069.29	5061.67	5065.78	1886.0
2014-11-28 05:00:00	NQ	Futures	5066.07	5068.12	5063.72	5066.36	1252.0
2014-11-28 06:00:00	NQ	Futures	5066.65	5071.05	5066.65	5069.58	864.0
2014-11-28 07:00:00	NQ	Futures	5069.88	5074.57	5067.83	5073.39	1832.0
2014-11-28 08:00:00	NQ	Futures	5073.39	5076.03	5069.0	5073.1	3231.0
2014-11-28 09:00:00	NQ	Futures	5073.1	5082.48	5071.34	5081.89	28375.0
2014-11-28 10:00:00	NQ	Futures	5082.18	5095.96	5078.67	5093.03	27117.0
2014-11-28 11:00:00	NQ	Futures	5092.73	5094.78	5087.46	5088.92	16900.0
2014-11-28 12:00:00	NQ	Futures	5088.92	5092.15	5075.45	5084.53	24438.0
2014-11-28 13:00:00	NQ	Futures	5084.24	5086.58	5081.01	5083.94	6085.0
2014-11-28 00:00:00	YM	Futures	18535.9	18539.0	18534.8	18539.0	239.0
2014-11-28 01:00:00	YM	Futures	18537.9	18541.1	18534.8	18539.0	247.0
2014-11-28 02:00:00	YM	Futures	18537.9	18540.0	18530.7	18530.7	508.0
2014-11-28 03:00:00	YM	Futures	18529.6	18529.6	18478.7	18478.7	4525.0
2014-11-28 04:00:00	YM	Futures	18478.7	18493.2	18474.5	18478.7	3017.0
2014-11-28 05:00:00	YM	Futures	18480.8	18484.9	18465.2	18473.5	2528.0
2014-11-28 06:00:00	YM	Futures	18474.5	18488.0	18473.5	18487.0	1203.0
2014-11-28 07:00:00	YM	Futures	18488.0	18516.1	18484.9	18516.1	2041.0
2014-11-28 08:00:00	YM	Futures	18517.1	18539.0	18511.9	18535.9	3317.0
2014-11-28 09:00:00	YM	Futures	18535.9	18575.4	18524.4	18574.3	15415.0
2014-11-28 10:00:00	YM	Futures	18574.3	18583.7	18558.7	18566.0	10308.0
2014-11-28 11:00:00	YM	Futures	18566.0	18587.8	18561.9	18577.4	7664.0
2014-11-28 12:00:00	YM	Futures	18576.4	18577.4	18500.5	18525.5	13371.0
2014-11-28 13:00:00	YM	Futures	18526.5	18529.6	18507.8	18516.1	2604.0
2014-11-28 00:00:00	CL	Futures	116.11	116.14	114.88	115.02	4006.0
2014-11-28 01:00:00	CL	Futures	115.0	115.35	114.34	114.51	6935.0
2014-11-28 02:00:00	CL	Futures	114.54	115.96	114.53	115.81	6418.0
2014-11-28 03:00:00	CL	Futures	115.81	116.28	115.37	115.64	8114.0
2014-11-28 04:00:00	CL	Futures	115.62	115.94	115.15	115.67	6309.0
2014-11-28 05:00:00	CL	Futures	115.66	117.02	115.66	116.9	13621.0
2014-11-28 06:00:00	CL	Futures	116.92	116.94	115.89	115.96	7996.0
2014-11-28 07:00:00	CL	Futures	115.98	116.75	115.89	116.06	8085.0

> showing 50 of 985 rows — these rows as CSV

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