PREVIEW / futures_1hour / 2015-12-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	2208.58	2209.11	2206.17	2208.31	3909.0
2015-12-09 01:00:00	ES	Futures	2208.04	2209.92	2207.77	2209.11	2344.0
2015-12-09 02:00:00	ES	Futures	2209.11	2213.13	2208.58	2210.18	9552.0
2015-12-09 03:00:00	ES	Futures	2210.45	2213.93	2204.03	2205.37	27855.0
2015-12-09 04:00:00	ES	Futures	2205.1	2206.17	2196.54	2202.16	32696.0
2015-12-09 05:00:00	ES	Futures	2202.16	2202.69	2197.34	2198.41	18770.0
2015-12-09 06:00:00	ES	Futures	2198.14	2206.44	2198.14	2205.1	20323.0
2015-12-09 07:00:00	ES	Futures	2204.83	2205.37	2198.41	2199.75	24348.0
2015-12-09 08:00:00	ES	Futures	2200.02	2202.96	2197.07	2197.61	39916.0
2015-12-09 09:00:00	ES	Futures	2197.87	2214.73	2193.86	2211.25	282842.0
2015-12-09 10:00:00	ES	Futures	2211.52	2225.97	2209.65	2220.35	329353.0
2015-12-09 11:00:00	ES	Futures	2220.35	2221.15	2197.61	2200.55	326506.0
2015-12-09 12:00:00	ES	Futures	2200.28	2202.96	2178.88	2181.82	390358.0
2015-12-09 13:00:00	ES	Futures	2181.55	2189.58	2177.27	2185.83	301459.0
2015-12-09 14:00:00	ES	Futures	2186.1	2188.24	2182.09	2182.36	158621.0
2015-12-09 15:00:00	ES	Futures	2182.62	2195.2	2181.82	2190.11	302857.0
2015-12-09 16:00:00	ES	Futures	2190.11	2191.72	2185.3	2189.04	89163.0
2015-12-09 18:00:00	ES	Futures	2189.58	2191.72	2188.51	2191.45	5433.0
2015-12-09 19:00:00	ES	Futures	2191.45	2194.13	2190.38	2190.65	7426.0
2015-12-09 20:00:00	ES	Futures	2190.65	2194.93	2190.65	2194.13	7125.0
2015-12-09 21:00:00	ES	Futures	2193.86	2194.66	2190.92	2192.52	4448.0
2015-12-09 22:00:00	ES	Futures	2192.52	2193.86	2191.99	2192.79	2746.0
2015-12-09 23:00:00	ES	Futures	2192.79	2194.93	2192.52	2194.13	3996.0
2015-12-09 00:00:00	NQ	Futures	5571.36	5572.85	5565.73	5570.47	640.0
2015-12-09 01:00:00	NQ	Futures	5570.47	5573.73	5568.69	5570.18	480.0
2015-12-09 02:00:00	NQ	Futures	5570.47	5581.74	5570.47	5572.85	1842.0
2015-12-09 03:00:00	NQ	Futures	5572.55	5582.93	5553.57	5557.13	4910.0
2015-12-09 04:00:00	NQ	Futures	5556.54	5557.72	5534.0	5548.83	6542.0
2015-12-09 05:00:00	NQ	Futures	5549.72	5551.79	5538.75	5540.53	2738.0
2015-12-09 06:00:00	NQ	Futures	5540.23	5563.65	5539.93	5555.65	4296.0
2015-12-09 07:00:00	NQ	Futures	5555.35	5555.95	5539.05	5544.68	4181.0
2015-12-09 08:00:00	NQ	Futures	5544.98	5552.09	5539.05	5539.93	4990.0
2015-12-09 09:00:00	NQ	Futures	5540.23	5558.02	5527.19	5543.79	39140.0
2015-12-09 10:00:00	NQ	Futures	5544.09	5573.14	5541.12	5558.61	45031.0
2015-12-09 11:00:00	NQ	Futures	5558.32	5559.8	5502.87	5509.1	44803.0
2015-12-09 12:00:00	NQ	Futures	5509.4	5516.81	5452.77	5458.99	68543.0
2015-12-09 13:00:00	NQ	Futures	5458.7	5475.3	5447.43	5466.4	51792.0
2015-12-09 14:00:00	NQ	Futures	5466.4	5469.67	5450.39	5455.14	28494.0
2015-12-09 15:00:00	NQ	Futures	5454.84	5490.12	5452.77	5480.93	48251.0
2015-12-09 16:00:00	NQ	Futures	5481.53	5485.97	5473.52	5483.3	9894.0
2015-12-09 18:00:00	NQ	Futures	5483.9	5488.94	5481.53	5488.94	834.0
2015-12-09 19:00:00	NQ	Futures	5489.23	5495.76	5487.46	5488.35	1403.0
2015-12-09 20:00:00	NQ	Futures	5487.75	5498.43	5487.75	5496.35	1141.0
2015-12-09 21:00:00	NQ	Futures	5496.05	5497.83	5489.23	5493.68	819.0
2015-12-09 22:00:00	NQ	Futures	5493.39	5496.65	5491.61	5494.28	516.0
2015-12-09 23:00:00	NQ	Futures	5493.98	5498.13	5493.09	5496.94	782.0
2015-12-09 00:00:00	YM	Futures	18634.4	18638.6	18614.3	18631.2	724.0
2015-12-09 01:00:00	YM	Futures	18629.1	18642.9	18628.0	18635.4	415.0
2015-12-09 02:00:00	YM	Futures	18636.5	18667.2	18632.3	18642.9	1407.0
2015-12-09 03:00:00	YM	Futures	18641.8	18673.6	18592.0	18600.5	4391.0

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

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