PREVIEW / futures_1hour / 2015-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-29.parquet
  size:    50 KB
  rows:    1,551

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-29 00:00:00	ES	Futures	2205.56	2205.83	2204.76	2205.03	1957.0
2015-12-29 01:00:00	ES	Futures	2205.03	2205.3	2203.68	2204.76	1429.0
2015-12-29 02:00:00	ES	Futures	2204.49	2206.1	2204.22	2205.03	3538.0
2015-12-29 03:00:00	ES	Futures	2205.3	2211.48	2205.3	2211.21	13226.0
2015-12-29 04:00:00	ES	Futures	2211.21	2213.89	2210.94	2212.55	12899.0
2015-12-29 05:00:00	ES	Futures	2212.55	2212.55	2210.4	2211.48	6795.0
2015-12-29 06:00:00	ES	Futures	2211.74	2211.74	2208.79	2209.59	5943.0
2015-12-29 07:00:00	ES	Futures	2209.33	2213.36	2209.06	2212.28	8827.0
2015-12-29 08:00:00	ES	Futures	2212.28	2218.19	2212.01	2217.39	24699.0
2015-12-29 09:00:00	ES	Futures	2217.39	2221.95	2214.97	2221.15	122389.0
2015-12-29 10:00:00	ES	Futures	2221.15	2223.84	2220.07	2220.61	123884.0
2015-12-29 11:00:00	ES	Futures	2220.61	2224.37	2218.46	2220.34	84870.0
2015-12-29 12:00:00	ES	Futures	2220.07	2223.3	2219.54	2222.22	50398.0
2015-12-29 13:00:00	ES	Futures	2221.95	2227.06	2221.69	2226.79	67334.0
2015-12-29 14:00:00	ES	Futures	2226.79	2228.4	2224.64	2227.87	76630.0
2015-12-29 15:00:00	ES	Futures	2227.6	2229.75	2223.57	2225.72	154718.0
2015-12-29 16:00:00	ES	Futures	2225.72	2228.94	2225.18	2228.4	55261.0
2015-12-29 18:00:00	ES	Futures	2227.06	2228.14	2225.99	2226.25	2588.0
2015-12-29 19:00:00	ES	Futures	2226.52	2228.67	2226.25	2227.87	3286.0
2015-12-29 20:00:00	ES	Futures	2227.87	2230.28	2227.6	2228.14	4166.0
2015-12-29 21:00:00	ES	Futures	2228.14	2228.4	2225.72	2226.52	2217.0
2015-12-29 22:00:00	ES	Futures	2226.79	2227.33	2225.45	2227.06	2091.0
2015-12-29 23:00:00	ES	Futures	2227.33	2227.87	2226.52	2227.6	1162.0
2015-12-29 00:00:00	NQ	Futures	5489.07	5491.75	5488.48	5488.78	476.0
2015-12-29 01:00:00	NQ	Futures	5489.07	5489.67	5486.4	5487.29	262.0
2015-12-29 02:00:00	NQ	Futures	5487.59	5491.45	5486.7	5489.07	533.0
2015-12-29 03:00:00	NQ	Futures	5489.67	5507.48	5489.37	5506.89	3260.0
2015-12-29 04:00:00	NQ	Futures	5506.59	5516.39	5506.29	5512.23	2257.0
2015-12-29 05:00:00	NQ	Futures	5512.23	5512.23	5506.0	5508.97	1536.0
2015-12-29 06:00:00	NQ	Futures	5508.97	5510.15	5500.65	5502.73	1257.0
2015-12-29 07:00:00	NQ	Futures	5502.73	5512.53	5502.73	5508.08	1501.0
2015-12-29 08:00:00	NQ	Futures	5508.37	5521.74	5508.08	5517.58	4375.0
2015-12-29 09:00:00	NQ	Futures	5518.17	5533.61	5509.56	5533.32	25509.0
2015-12-29 10:00:00	NQ	Futures	5533.32	5549.94	5533.32	5546.08	26763.0
2015-12-29 11:00:00	NQ	Futures	5546.08	5559.15	5545.49	5551.73	17910.0
2015-12-29 12:00:00	NQ	Futures	5551.73	5560.34	5550.83	5559.45	10061.0
2015-12-29 13:00:00	NQ	Futures	5559.45	5573.4	5557.07	5572.51	13592.0
2015-12-29 14:00:00	NQ	Futures	5572.81	5577.86	5569.54	5576.37	13803.0
2015-12-29 15:00:00	NQ	Futures	5576.37	5579.64	5563.01	5565.98	21806.0
2015-12-29 16:00:00	NQ	Futures	5565.68	5573.7	5562.41	5570.14	5702.0
2015-12-29 18:00:00	NQ	Futures	5567.17	5571.03	5565.98	5566.87	321.0
2015-12-29 19:00:00	NQ	Futures	5567.17	5572.81	5566.87	5570.73	559.0
2015-12-29 20:00:00	NQ	Futures	5570.73	5576.37	5570.43	5573.4	774.0
2015-12-29 21:00:00	NQ	Futures	5573.7	5573.7	5567.76	5568.95	529.0
2015-12-29 22:00:00	NQ	Futures	5568.95	5570.14	5566.87	5570.14	462.0
2015-12-29 23:00:00	NQ	Futures	5570.14	5570.43	5567.17	5569.84	206.0
2015-12-29 00:00:00	YM	Futures	18599.6	18605.0	18591.1	18593.2	252.0
2015-12-29 01:00:00	YM	Futures	18594.3	18595.4	18585.8	18590.0	209.0
2015-12-29 02:00:00	YM	Futures	18591.1	18603.9	18586.9	18594.3	526.0
2015-12-29 03:00:00	YM	Futures	18593.2	18651.8	18593.2	18647.5	3554.0

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

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