PREVIEW / futures_1hour / 2015-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-16.parquet
  size:    50 KB
  rows:    1,560

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-07-16 00:00:00	ES	Futures	2247.4	2248.73	2246.87	2247.93	1900.0
2015-07-16 01:00:00	ES	Futures	2248.2	2248.73	2247.14	2248.47	2987.0
2015-07-16 02:00:00	ES	Futures	2248.73	2249.53	2246.6	2247.14	8999.0
2015-07-16 03:00:00	ES	Futures	2247.14	2249.53	2246.34	2248.47	16096.0
2015-07-16 04:00:00	ES	Futures	2248.73	2250.86	2248.2	2250.06	14718.0
2015-07-16 05:00:00	ES	Futures	2249.8	2250.33	2248.2	2248.47	10933.0
2015-07-16 06:00:00	ES	Futures	2248.2	2249.27	2247.4	2248.2	9087.0
2015-07-16 07:00:00	ES	Futures	2248.2	2250.6	2247.93	2249.53	16071.0
2015-07-16 08:00:00	ES	Futures	2249.53	2252.19	2249.0	2251.4	23524.0
2015-07-16 09:00:00	ES	Futures	2251.66	2252.99	2247.93	2251.13	168393.0
2015-07-16 10:00:00	ES	Futures	2250.86	2251.93	2247.93	2251.13	157174.0
2015-07-16 11:00:00	ES	Futures	2250.86	2253.53	2249.53	2251.93	102590.0
2015-07-16 12:00:00	ES	Futures	2251.93	2254.06	2251.13	2251.4	77994.0
2015-07-16 13:00:00	ES	Futures	2251.13	2252.73	2250.33	2250.6	93347.0
2015-07-16 14:00:00	ES	Futures	2250.6	2254.32	2250.33	2252.99	94576.0
2015-07-16 15:00:00	ES	Futures	2252.99	2255.39	2251.93	2255.12	170869.0
2015-07-16 16:00:00	ES	Futures	2254.86	2256.19	2253.79	2254.32	87482.0
2015-07-16 17:00:00	ES	Futures	2254.06	2255.12	2254.06	2254.86	1026.0
2015-07-16 18:00:00	ES	Futures	2254.59	2255.12	2253.79	2254.86	2815.0
2015-07-16 19:00:00	ES	Futures	2254.86	2255.92	2254.32	2254.86	2170.0
2015-07-16 20:00:00	ES	Futures	2254.86	2255.12	2253.53	2253.79	2998.0
2015-07-16 21:00:00	ES	Futures	2253.79	2254.86	2253.53	2254.59	1801.0
2015-07-16 22:00:00	ES	Futures	2254.59	2255.12	2253.53	2253.53	1675.0
2015-07-16 23:00:00	ES	Futures	2253.53	2253.79	2252.99	2253.26	1801.0
2015-07-16 00:00:00	NQ	Futures	5380.11	5383.66	5379.82	5381.59	428.0
2015-07-16 01:00:00	NQ	Futures	5381.0	5383.96	5378.93	5383.66	507.0
2015-07-16 02:00:00	NQ	Futures	5383.96	5386.33	5379.52	5381.59	1258.0
2015-07-16 03:00:00	NQ	Futures	5381.3	5386.62	5379.23	5383.96	1945.0
2015-07-16 04:00:00	NQ	Futures	5383.96	5393.42	5382.78	5391.65	2598.0
2015-07-16 05:00:00	NQ	Futures	5391.35	5391.95	5388.1	5390.76	1759.0
2015-07-16 06:00:00	NQ	Futures	5390.47	5392.24	5387.51	5388.99	2943.0
2015-07-16 07:00:00	NQ	Futures	5389.28	5392.24	5388.1	5390.47	4697.0
2015-07-16 08:00:00	NQ	Futures	5390.17	5396.68	5388.4	5394.02	4749.0
2015-07-16 09:00:00	NQ	Futures	5393.72	5401.11	5384.55	5395.79	33013.0
2015-07-16 10:00:00	NQ	Futures	5395.2	5404.07	5388.99	5401.11	25655.0
2015-07-16 11:00:00	NQ	Futures	5401.41	5413.83	5401.11	5408.21	18433.0
2015-07-16 12:00:00	NQ	Futures	5408.21	5417.09	5407.33	5408.21	12900.0
2015-07-16 13:00:00	NQ	Futures	5407.92	5412.06	5405.85	5407.62	11244.0
2015-07-16 14:00:00	NQ	Futures	5407.62	5417.09	5407.03	5415.61	12875.0
2015-07-16 15:00:00	NQ	Futures	5415.61	5426.55	5413.83	5424.78	28834.0
2015-07-16 16:00:00	NQ	Futures	5425.07	5452.29	5422.71	5449.33	16006.0
2015-07-16 17:00:00	NQ	Futures	5449.33	5457.31	5449.03	5456.43	947.0
2015-07-16 18:00:00	NQ	Futures	5454.06	5459.09	5454.06	5458.5	1513.0
2015-07-16 19:00:00	NQ	Futures	5458.2	5464.12	5458.2	5460.57	894.0
2015-07-16 20:00:00	NQ	Futures	5461.46	5461.75	5457.91	5459.09	578.0
2015-07-16 21:00:00	NQ	Futures	5458.79	5461.16	5458.2	5459.39	565.0
2015-07-16 22:00:00	NQ	Futures	5459.68	5460.57	5454.95	5454.95	684.0
2015-07-16 23:00:00	NQ	Futures	5455.24	5455.54	5452.29	5452.88	478.0
2015-07-16 00:00:00	YM	Futures	19006.5	19017.1	19003.4	19011.8	236.0
2015-07-16 01:00:00	YM	Futures	19012.8	19013.9	19005.5	19013.9	342.0

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

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