PREVIEW / futures_1hour / 2015-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-08.parquet
  size:    52 KB
  rows:    1,611

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-12-08 00:00:00	ES	Futures	2217.94	2219.28	2217.14	2218.48	3263.0
2015-12-08 01:00:00	ES	Futures	2218.48	2219.55	2217.94	2219.01	2595.0
2015-12-08 02:00:00	ES	Futures	2218.75	2222.49	2218.21	2219.28	6423.0
2015-12-08 03:00:00	ES	Futures	2219.28	2223.29	2213.13	2216.6	30968.0
2015-12-08 04:00:00	ES	Futures	2216.6	2218.48	2210.45	2214.2	23532.0
2015-12-08 05:00:00	ES	Futures	2214.2	2218.21	2213.39	2217.14	14245.0
2015-12-08 06:00:00	ES	Futures	2217.14	2217.14	2210.72	2211.79	17069.0
2015-12-08 07:00:00	ES	Futures	2211.52	2213.39	2204.03	2204.03	40205.0
2015-12-08 08:00:00	ES	Futures	2204.03	2205.37	2201.89	2203.23	55765.0
2015-12-08 09:00:00	ES	Futures	2203.23	2206.97	2195.73	2199.48	296527.0
2015-12-08 10:00:00	ES	Futures	2199.75	2210.45	2194.4	2210.18	362252.0
2015-12-08 11:00:00	ES	Futures	2210.18	2219.01	2205.37	2209.38	287988.0
2015-12-08 12:00:00	ES	Futures	2209.65	2209.65	2203.23	2208.04	121271.0
2015-12-08 13:00:00	ES	Futures	2208.04	2209.65	2201.89	2208.58	130107.0
2015-12-08 14:00:00	ES	Futures	2208.58	2215.0	2208.31	2209.38	142122.0
2015-12-08 15:00:00	ES	Futures	2209.38	2212.06	2202.96	2207.24	239365.0
2015-12-08 16:00:00	ES	Futures	2207.24	2208.04	2202.96	2204.83	76787.0
2015-12-08 18:00:00	ES	Futures	2204.3	2208.31	2203.23	2208.04	4446.0
2015-12-08 19:00:00	ES	Futures	2208.04	2210.72	2206.7	2209.92	7292.0
2015-12-08 20:00:00	ES	Futures	2209.92	2211.79	2208.04	2208.04	6819.0
2015-12-08 21:00:00	ES	Futures	2208.58	2209.11	2206.17	2208.58	4136.0
2015-12-08 22:00:00	ES	Futures	2208.85	2210.18	2207.77	2208.58	3148.0
2015-12-08 23:00:00	ES	Futures	2208.58	2210.72	2207.77	2208.58	2502.0
2015-12-08 00:00:00	NQ	Futures	5549.13	5553.87	5548.83	5552.09	485.0
2015-12-08 01:00:00	NQ	Futures	5550.61	5554.17	5550.31	5552.68	402.0
2015-12-08 02:00:00	NQ	Futures	5551.79	5561.88	5550.61	5553.28	1369.0
2015-12-08 03:00:00	NQ	Futures	5552.68	5567.51	5539.05	5549.13	5328.0
2015-12-08 04:00:00	NQ	Futures	5548.53	5552.98	5531.93	5542.31	3730.0
2015-12-08 05:00:00	NQ	Futures	5542.31	5551.5	5539.93	5549.13	2102.0
2015-12-08 06:00:00	NQ	Futures	5548.83	5548.83	5532.23	5534.89	2898.0
2015-12-08 07:00:00	NQ	Futures	5534.6	5539.05	5514.73	5514.73	8228.0
2015-12-08 08:00:00	NQ	Futures	5514.73	5517.99	5509.4	5513.84	7587.0
2015-12-08 09:00:00	NQ	Futures	5513.25	5535.78	5504.36	5516.81	48815.0
2015-12-08 10:00:00	NQ	Futures	5517.1	5555.95	5505.84	5552.68	58654.0
2015-12-08 11:00:00	NQ	Futures	5552.39	5580.85	5550.9	5563.95	44744.0
2015-12-08 12:00:00	NQ	Futures	5563.95	5564.25	5546.75	5563.06	17659.0
2015-12-08 13:00:00	NQ	Futures	5563.06	5568.4	5548.53	5565.43	18581.0
2015-12-08 14:00:00	NQ	Futures	5565.73	5584.7	5564.84	5573.14	26725.0
2015-12-08 15:00:00	NQ	Futures	5573.44	5578.48	5556.24	5566.92	32378.0
2015-12-08 16:00:00	NQ	Futures	5566.62	5570.18	5557.43	5564.84	7995.0
2015-12-08 18:00:00	NQ	Futures	5562.76	5570.77	5558.91	5570.18	888.0
2015-12-08 19:00:00	NQ	Futures	5569.88	5574.62	5566.03	5573.73	1881.0
2015-12-08 20:00:00	NQ	Futures	5573.14	5577.89	5568.99	5569.58	1386.0
2015-12-08 21:00:00	NQ	Futures	5569.58	5571.36	5564.25	5569.58	834.0
2015-12-08 22:00:00	NQ	Futures	5570.47	5576.11	5567.8	5572.25	749.0
2015-12-08 23:00:00	NQ	Futures	5572.25	5577.0	5569.58	5571.36	523.0
2015-12-08 00:00:00	YM	Futures	18730.8	18743.5	18725.5	18736.1	404.0
2015-12-08 01:00:00	YM	Futures	18736.1	18744.5	18731.8	18741.4	377.0
2015-12-08 02:00:00	YM	Futures	18740.3	18770.0	18734.0	18748.8	788.0
2015-12-08 03:00:00	YM	Futures	18746.7	18775.3	18694.8	18723.4	3917.0

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

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