PREVIEW / futures_1hour / 2016-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-15.parquet
  size:    46 KB
  rows:    1,330

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
2016-07-15 00:00:00	ES	Futures	2339.8	2341.15	2336.81	2337.36	6968.0
2016-07-15 01:00:00	ES	Futures	2337.36	2337.63	2334.92	2335.19	7326.0
2016-07-15 02:00:00	ES	Futures	2335.19	2337.36	2333.83	2335.19	9881.0
2016-07-15 03:00:00	ES	Futures	2335.46	2339.53	2333.83	2337.36	25957.0
2016-07-15 04:00:00	ES	Futures	2337.08	2339.8	2335.19	2336.54	21916.0
2016-07-15 05:00:00	ES	Futures	2336.81	2338.71	2333.83	2337.9	24640.0
2016-07-15 06:00:00	ES	Futures	2337.9	2339.8	2336.0	2336.27	24562.0
2016-07-15 07:00:00	ES	Futures	2336.27	2342.24	2336.27	2341.97	32135.0
2016-07-15 08:00:00	ES	Futures	2341.97	2345.22	2340.07	2343.86	63504.0
2016-07-15 09:00:00	ES	Futures	2344.14	2348.2	2341.15	2342.24	267960.0
2016-07-15 10:00:00	ES	Futures	2341.97	2344.14	2339.53	2342.24	187885.0
2016-07-15 11:00:00	ES	Futures	2342.24	2342.51	2333.83	2334.92	193142.0
2016-07-15 12:00:00	ES	Futures	2334.92	2336.54	2331.12	2332.47	116340.0
2016-07-15 13:00:00	ES	Futures	2332.47	2337.08	2332.47	2335.73	78745.0
2016-07-15 14:00:00	ES	Futures	2335.73	2337.63	2333.83	2336.81	88226.0
2016-07-15 15:00:00	ES	Futures	2336.81	2340.07	2335.73	2336.81	168522.0
2016-07-15 16:00:00	ES	Futures	2337.08	2338.17	2324.88	2327.86	126343.0
2016-07-15 00:00:00	NQ	Futures	5473.12	5476.7	5465.67	5467.16	841.0
2016-07-15 01:00:00	NQ	Futures	5467.76	5468.35	5461.2	5462.99	887.0
2016-07-15 02:00:00	NQ	Futures	5462.09	5467.76	5459.11	5463.88	1144.0
2016-07-15 03:00:00	NQ	Futures	5463.88	5474.61	5460.01	5468.95	2467.0
2016-07-15 04:00:00	NQ	Futures	5468.95	5475.51	5462.69	5466.27	1924.0
2016-07-15 05:00:00	NQ	Futures	5466.56	5471.33	5459.41	5469.25	1657.0
2016-07-15 06:00:00	NQ	Futures	5468.95	5473.72	5465.67	5466.27	1720.0
2016-07-15 07:00:00	NQ	Futures	5466.86	5475.8	5466.86	5474.61	2722.0
2016-07-15 08:00:00	NQ	Futures	5474.61	5479.38	5470.74	5474.91	5293.0
2016-07-15 09:00:00	NQ	Futures	5475.51	5488.32	5471.03	5476.1	36102.0
2016-07-15 10:00:00	NQ	Futures	5476.1	5478.49	5465.37	5472.52	25854.0
2016-07-15 11:00:00	NQ	Futures	5472.82	5474.91	5455.54	5458.81	22419.0
2016-07-15 12:00:00	NQ	Futures	5458.81	5461.2	5451.36	5454.64	13289.0
2016-07-15 13:00:00	NQ	Futures	5454.34	5463.58	5454.34	5459.41	8762.0
2016-07-15 14:00:00	NQ	Futures	5459.71	5463.29	5455.83	5460.3	9342.0
2016-07-15 15:00:00	NQ	Futures	5460.6	5469.25	5458.22	5462.99	18745.0
2016-07-15 16:00:00	NQ	Futures	5462.69	5465.97	5424.84	5439.14	10435.0
2016-07-15 00:00:00	YM	Futures	19832.3	19851.7	19805.4	19809.7	5063.0
2016-07-15 01:00:00	YM	Futures	19811.9	19817.2	19798.9	19798.9	2089.0
2016-07-15 02:00:00	YM	Futures	19800.0	19817.2	19790.3	19798.9	1365.0
2016-07-15 03:00:00	YM	Futures	19800.0	19834.5	19791.4	19817.2	3102.0
2016-07-15 04:00:00	YM	Futures	19816.2	19838.8	19804.3	19814.0	2461.0
2016-07-15 05:00:00	YM	Futures	19814.0	19830.2	19792.5	19821.5	2469.0
2016-07-15 06:00:00	YM	Futures	19820.5	19836.6	19808.6	19810.8	2280.0
2016-07-15 07:00:00	YM	Futures	19811.9	19848.4	19811.9	19846.3	3511.0
2016-07-15 08:00:00	YM	Futures	19846.3	19871.0	19836.6	19863.5	5411.0
2016-07-15 09:00:00	YM	Futures	19863.5	19896.9	19847.4	19857.1	21239.0
2016-07-15 10:00:00	YM	Futures	19857.1	19872.1	19838.8	19852.8	15251.0
2016-07-15 11:00:00	YM	Futures	19852.8	19856.0	19804.3	19810.8	15271.0
2016-07-15 12:00:00	YM	Futures	19810.8	19821.5	19788.2	19797.9	10055.0
2016-07-15 13:00:00	YM	Futures	19798.9	19830.2	19797.9	19820.5	6951.0
2016-07-15 14:00:00	YM	Futures	19821.5	19836.6	19809.7	19829.1	6065.0
2016-07-15 15:00:00	YM	Futures	19830.2	19853.8	19820.5	19833.4	12353.0

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

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