PREVIEW / futures_1hour / 2016-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-21.parquet
  size:    54 KB
  rows:    1,602

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-21 00:00:00	ES	Futures	2351.46	2352.0	2350.64	2350.64	3220.0
2016-07-21 01:00:00	ES	Futures	2350.92	2351.46	2349.83	2350.64	3834.0
2016-07-21 02:00:00	ES	Futures	2350.92	2352.81	2350.37	2352.27	7584.0
2016-07-21 03:00:00	ES	Futures	2352.27	2354.17	2349.83	2350.92	26641.0
2016-07-21 04:00:00	ES	Futures	2351.19	2352.27	2346.85	2349.02	33707.0
2016-07-21 05:00:00	ES	Futures	2349.29	2349.29	2346.03	2347.66	18433.0
2016-07-21 06:00:00	ES	Futures	2347.39	2350.1	2347.39	2349.02	14499.0
2016-07-21 07:00:00	ES	Futures	2348.75	2350.64	2348.2	2350.1	13068.0
2016-07-21 08:00:00	ES	Futures	2350.37	2350.64	2347.12	2348.75	34113.0
2016-07-21 09:00:00	ES	Futures	2348.75	2352.27	2347.39	2349.02	172612.0
2016-07-21 10:00:00	ES	Futures	2349.02	2351.73	2347.66	2351.46	178108.0
2016-07-21 11:00:00	ES	Futures	2351.46	2351.73	2343.05	2344.95	168973.0
2016-07-21 12:00:00	ES	Futures	2344.68	2345.76	2341.69	2342.51	98046.0
2016-07-21 13:00:00	ES	Futures	2342.24	2344.14	2339.25	2340.61	100357.0
2016-07-21 14:00:00	ES	Futures	2340.61	2341.15	2337.9	2338.71	110746.0
2016-07-21 15:00:00	ES	Futures	2338.71	2342.78	2336.0	2341.42	230973.0
2016-07-21 16:00:00	ES	Futures	2341.69	2342.78	2340.34	2342.24	61773.0
2016-07-21 18:00:00	ES	Futures	2341.97	2342.51	2340.88	2341.42	3842.0
2016-07-21 19:00:00	ES	Futures	2341.69	2341.97	2340.61	2341.42	2099.0
2016-07-21 20:00:00	ES	Futures	2341.69	2342.51	2340.88	2340.88	4070.0
2016-07-21 21:00:00	ES	Futures	2341.15	2342.24	2339.53	2340.88	7580.0
2016-07-21 22:00:00	ES	Futures	2341.15	2342.24	2340.34	2341.15	2728.0
2016-07-21 23:00:00	ES	Futures	2341.15	2341.42	2340.34	2341.15	1737.0
2016-07-21 00:00:00	NQ	Futures	5551.21	5552.4	5548.23	5548.53	329.0
2016-07-21 01:00:00	NQ	Futures	5548.53	5551.21	5545.85	5547.93	664.0
2016-07-21 02:00:00	NQ	Futures	5548.83	5554.49	5548.23	5551.81	729.0
2016-07-21 03:00:00	NQ	Futures	5551.81	5557.47	5544.65	5548.23	2921.0
2016-07-21 04:00:00	NQ	Futures	5548.23	5551.81	5538.39	5542.27	3001.0
2016-07-21 05:00:00	NQ	Futures	5542.57	5543.46	5535.41	5539.59	2148.0
2016-07-21 06:00:00	NQ	Futures	5539.88	5545.55	5539.88	5542.86	1652.0
2016-07-21 07:00:00	NQ	Futures	5542.57	5550.02	5542.57	5548.83	2355.0
2016-07-21 08:00:00	NQ	Futures	5549.12	5550.61	5542.86	5545.55	4548.0
2016-07-21 09:00:00	NQ	Futures	5545.55	5558.36	5542.27	5545.85	30914.0
2016-07-21 10:00:00	NQ	Futures	5545.25	5555.38	5541.08	5547.93	28128.0
2016-07-21 11:00:00	NQ	Futures	5547.93	5552.1	5530.05	5536.31	24128.0
2016-07-21 12:00:00	NQ	Futures	5536.01	5537.5	5529.15	5531.84	13300.0
2016-07-21 13:00:00	NQ	Futures	5531.54	5536.9	5526.17	5530.05	13257.0
2016-07-21 14:00:00	NQ	Futures	5530.05	5530.64	5520.21	5522.6	15656.0
2016-07-21 15:00:00	NQ	Futures	5522.6	5533.03	5516.04	5531.54	25694.0
2016-07-21 16:00:00	NQ	Futures	5531.54	5533.92	5528.26	5531.54	5579.0
2016-07-21 18:00:00	NQ	Futures	5530.05	5530.35	5527.07	5528.56	901.0
2016-07-21 19:00:00	NQ	Futures	5528.86	5529.45	5527.07	5528.56	454.0
2016-07-21 20:00:00	NQ	Futures	5528.86	5531.84	5527.66	5527.96	605.0
2016-07-21 21:00:00	NQ	Futures	5528.56	5531.84	5524.39	5528.56	775.0
2016-07-21 22:00:00	NQ	Futures	5528.86	5533.03	5527.07	5529.15	479.0
2016-07-21 23:00:00	NQ	Futures	5528.86	5530.64	5527.07	5527.96	465.0
2016-07-21 00:00:00	YM	Futures	19939.9	19943.2	19932.4	19932.4	325.0
2016-07-21 01:00:00	YM	Futures	19933.5	19942.1	19928.1	19936.7	630.0
2016-07-21 02:00:00	YM	Futures	19937.8	19953.9	19936.7	19942.1	1163.0
2016-07-21 03:00:00	YM	Futures	19942.1	19961.5	19922.7	19933.5	2822.0

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

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