PREVIEW / futures_1hour / 2015-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-26.parquet
  size:    49 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
2015-10-26 00:00:00	ES	Futures	2207.24	2207.51	2206.44	2206.97	2352.0
2015-10-26 01:00:00	ES	Futures	2207.24	2208.85	2205.9	2205.9	3765.0
2015-10-26 02:00:00	ES	Futures	2206.17	2207.51	2205.63	2206.97	4046.0
2015-10-26 03:00:00	ES	Futures	2206.97	2208.04	2205.63	2206.17	8149.0
2015-10-26 04:00:00	ES	Futures	2206.44	2206.97	2202.16	2206.17	17642.0
2015-10-26 05:00:00	ES	Futures	2206.44	2208.58	2204.83	2207.51	12045.0
2015-10-26 06:00:00	ES	Futures	2207.51	2209.11	2206.7	2208.04	14836.0
2015-10-26 07:00:00	ES	Futures	2208.31	2208.85	2206.7	2208.31	12439.0
2015-10-26 08:00:00	ES	Futures	2208.31	2212.06	2207.51	2211.25	31602.0
2015-10-26 09:00:00	ES	Futures	2211.25	2213.39	2205.9	2206.7	196090.0
2015-10-26 10:00:00	ES	Futures	2206.7	2210.99	2204.3	2210.18	268393.0
2015-10-26 11:00:00	ES	Futures	2209.92	2210.99	2206.97	2207.77	125748.0
2015-10-26 12:00:00	ES	Futures	2207.51	2212.86	2205.9	2210.99	115530.0
2015-10-26 13:00:00	ES	Futures	2210.99	2212.86	2208.31	2208.58	75595.0
2015-10-26 14:00:00	ES	Futures	2208.85	2211.52	2207.51	2210.18	86982.0
2015-10-26 15:00:00	ES	Futures	2210.18	2210.99	2208.04	2208.58	120958.0
2015-10-26 16:00:00	ES	Futures	2208.58	2208.85	2206.7	2207.77	59238.0
2015-10-26 18:00:00	ES	Futures	2208.85	2208.85	2207.77	2208.58	1845.0
2015-10-26 19:00:00	ES	Futures	2208.31	2208.85	2207.77	2208.04	1279.0
2015-10-26 20:00:00	ES	Futures	2208.04	2208.31	2205.9	2206.44	5051.0
2015-10-26 21:00:00	ES	Futures	2206.44	2208.04	2206.17	2207.24	3062.0
2015-10-26 22:00:00	ES	Futures	2206.97	2206.97	2202.16	2202.69	9511.0
2015-10-26 23:00:00	ES	Futures	2202.69	2205.1	2202.42	2203.23	5241.0
2015-10-26 00:00:00	NQ	Futures	5460.48	5461.07	5458.1	5459.29	499.0
2015-10-26 01:00:00	NQ	Futures	5459.88	5463.14	5456.92	5457.51	640.0
2015-10-26 02:00:00	NQ	Futures	5457.21	5460.18	5455.73	5458.4	588.0
2015-10-26 03:00:00	NQ	Futures	5458.4	5461.96	5453.66	5455.14	2041.0
2015-10-26 04:00:00	NQ	Futures	5455.43	5457.51	5446.84	5456.03	3127.0
2015-10-26 05:00:00	NQ	Futures	5455.43	5462.55	5452.47	5458.4	2010.0
2015-10-26 06:00:00	NQ	Futures	5458.4	5462.25	5455.43	5459.29	2059.0
2015-10-26 07:00:00	NQ	Futures	5459.88	5461.66	5456.62	5459.88	2033.0
2015-10-26 08:00:00	NQ	Futures	5459.88	5473.22	5458.7	5469.96	5882.0
2015-10-26 09:00:00	NQ	Futures	5469.96	5475.6	5453.95	5457.51	32188.0
2015-10-26 10:00:00	NQ	Futures	5457.51	5488.64	5452.47	5485.38	38810.0
2015-10-26 11:00:00	NQ	Futures	5485.38	5487.16	5468.18	5469.96	21488.0
2015-10-26 12:00:00	NQ	Futures	5469.67	5490.12	5467.0	5483.01	16661.0
2015-10-26 13:00:00	NQ	Futures	5483.01	5491.01	5472.33	5473.22	14522.0
2015-10-26 14:00:00	NQ	Futures	5473.22	5483.9	5469.96	5483.6	12981.0
2015-10-26 15:00:00	NQ	Futures	5483.3	5484.79	5473.82	5480.64	17372.0
2015-10-26 16:00:00	NQ	Futures	5480.64	5481.23	5472.93	5476.78	5390.0
2015-10-26 18:00:00	NQ	Futures	5478.86	5478.86	5474.71	5477.67	366.0
2015-10-26 19:00:00	NQ	Futures	5477.97	5477.97	5475.0	5475.89	134.0
2015-10-26 20:00:00	NQ	Futures	5475.6	5476.19	5470.85	5471.74	797.0
2015-10-26 21:00:00	NQ	Futures	5472.04	5475.89	5471.74	5473.82	561.0
2015-10-26 22:00:00	NQ	Futures	5473.52	5473.52	5459.59	5461.36	1720.0
2015-10-26 23:00:00	NQ	Futures	5461.07	5465.52	5459.88	5461.07	1294.0
2015-10-26 00:00:00	YM	Futures	18558.1	18562.4	18552.8	18557.1	509.0
2015-10-26 01:00:00	YM	Futures	18560.2	18568.7	18548.6	18548.6	421.0
2015-10-26 02:00:00	YM	Futures	18551.8	18562.4	18546.5	18558.1	538.0
2015-10-26 03:00:00	YM	Futures	18559.2	18566.6	18548.6	18554.9	1508.0

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

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