PREVIEW / futures_1hour / 2016-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-19.parquet
  size:    51 KB
  rows:    1,590

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-19 00:00:00	ES	Futures	2340.34	2340.88	2339.25	2340.34	2624.0
2016-07-19 01:00:00	ES	Futures	2340.61	2341.15	2339.25	2340.61	4737.0
2016-07-19 02:00:00	ES	Futures	2340.61	2341.15	2338.44	2339.53	8615.0
2016-07-19 03:00:00	ES	Futures	2339.53	2341.15	2335.46	2335.46	37006.0
2016-07-19 04:00:00	ES	Futures	2335.73	2337.36	2333.56	2335.73	21537.0
2016-07-19 05:00:00	ES	Futures	2335.73	2337.08	2334.92	2335.73	12595.0
2016-07-19 06:00:00	ES	Futures	2335.73	2338.17	2334.92	2337.9	14793.0
2016-07-19 07:00:00	ES	Futures	2338.17	2339.25	2336.81	2337.9	27843.0
2016-07-19 08:00:00	ES	Futures	2338.17	2340.07	2337.08	2337.63	35005.0
2016-07-19 09:00:00	ES	Futures	2337.9	2340.88	2335.73	2337.36	208943.0
2016-07-19 10:00:00	ES	Futures	2337.36	2340.34	2335.73	2339.25	165916.0
2016-07-19 11:00:00	ES	Futures	2339.53	2341.42	2335.46	2336.54	153722.0
2016-07-19 12:00:00	ES	Futures	2336.54	2338.98	2335.46	2338.44	85696.0
2016-07-19 13:00:00	ES	Futures	2338.44	2338.44	2334.64	2335.46	78380.0
2016-07-19 14:00:00	ES	Futures	2335.73	2338.98	2335.46	2337.36	70588.0
2016-07-19 15:00:00	ES	Futures	2337.36	2340.88	2336.54	2340.61	116418.0
2016-07-19 16:00:00	ES	Futures	2340.61	2343.05	2340.61	2341.97	79792.0
2016-07-19 18:00:00	ES	Futures	2341.97	2342.78	2341.15	2341.42	3586.0
2016-07-19 19:00:00	ES	Futures	2341.42	2341.97	2340.61	2340.88	2109.0
2016-07-19 20:00:00	ES	Futures	2340.88	2341.42	2338.17	2338.44	5084.0
2016-07-19 21:00:00	ES	Futures	2338.71	2339.53	2337.9	2338.71	5793.0
2016-07-19 22:00:00	ES	Futures	2338.98	2339.25	2337.9	2338.17	3455.0
2016-07-19 23:00:00	ES	Futures	2338.17	2340.07	2338.17	2339.53	2596.0
2016-07-19 00:00:00	NQ	Futures	5488.92	5490.71	5485.94	5490.11	373.0
2016-07-19 01:00:00	NQ	Futures	5490.41	5493.09	5488.02	5492.2	844.0
2016-07-19 02:00:00	NQ	Futures	5492.49	5493.98	5486.24	5489.22	893.0
2016-07-19 03:00:00	NQ	Futures	5489.22	5493.09	5478.49	5479.38	4080.0
2016-07-19 04:00:00	NQ	Futures	5479.38	5484.45	5475.21	5479.38	2187.0
2016-07-19 05:00:00	NQ	Futures	5479.68	5482.66	5477.89	5478.78	1140.0
2016-07-19 06:00:00	NQ	Futures	5478.49	5482.06	5476.4	5481.76	2553.0
2016-07-19 07:00:00	NQ	Futures	5481.76	5483.25	5479.08	5479.68	3455.0
2016-07-19 08:00:00	NQ	Futures	5479.68	5485.34	5478.19	5482.06	3770.0
2016-07-19 09:00:00	NQ	Futures	5482.06	5496.96	5471.63	5476.7	37855.0
2016-07-19 10:00:00	NQ	Futures	5476.4	5488.32	5473.42	5485.94	24479.0
2016-07-19 11:00:00	NQ	Futures	5485.94	5491.0	5476.1	5478.78	19369.0
2016-07-19 12:00:00	NQ	Futures	5479.08	5484.15	5474.91	5482.06	11108.0
2016-07-19 13:00:00	NQ	Futures	5482.06	5482.06	5470.14	5471.63	11296.0
2016-07-19 14:00:00	NQ	Futures	5471.33	5478.49	5471.33	5475.8	9733.0
2016-07-19 15:00:00	NQ	Futures	5476.1	5479.68	5472.82	5479.68	13683.0
2016-07-19 16:00:00	NQ	Futures	5479.68	5496.67	5477.29	5492.2	11525.0
2016-07-19 18:00:00	NQ	Futures	5494.88	5495.77	5491.3	5491.3	933.0
2016-07-19 19:00:00	NQ	Futures	5491.6	5493.98	5489.22	5489.81	720.0
2016-07-19 20:00:00	NQ	Futures	5490.11	5491.3	5483.25	5484.15	711.0
2016-07-19 21:00:00	NQ	Futures	5484.15	5487.73	5481.47	5486.53	970.0
2016-07-19 22:00:00	NQ	Futures	5486.24	5486.83	5483.25	5484.45	455.0
2016-07-19 23:00:00	NQ	Futures	5484.15	5489.51	5484.15	5488.32	482.0
2016-07-19 00:00:00	YM	Futures	19845.2	19854.9	19834.5	19848.4	1740.0
2016-07-19 01:00:00	YM	Futures	19848.4	19852.8	19829.1	19850.6	3813.0
2016-07-19 02:00:00	YM	Futures	19850.6	19861.4	19837.7	19848.4	2859.0
2016-07-19 03:00:00	YM	Futures	19847.4	19858.1	19816.2	19817.2	4428.0

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

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