PREVIEW / futures_1hour / 2016-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-23.parquet
  size:    40 KB
  rows:    1,224

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-12-23 00:00:00	ES	Futures	2465.01	2465.29	2464.74	2465.01	762.0
2016-12-23 01:00:00	ES	Futures	2465.01	2465.29	2464.19	2465.29	783.0
2016-12-23 02:00:00	ES	Futures	2465.01	2466.38	2464.74	2465.83	2506.0
2016-12-23 03:00:00	ES	Futures	2465.83	2466.92	2464.19	2464.74	7716.0
2016-12-23 04:00:00	ES	Futures	2464.74	2465.56	2464.19	2465.01	3625.0
2016-12-23 05:00:00	ES	Futures	2464.74	2465.56	2464.47	2465.01	3911.0
2016-12-23 06:00:00	ES	Futures	2465.01	2465.29	2463.92	2464.74	4369.0
2016-12-23 07:00:00	ES	Futures	2464.74	2464.74	2460.92	2462.56	9645.0
2016-12-23 08:00:00	ES	Futures	2462.29	2462.83	2460.92	2462.01	10484.0
2016-12-23 09:00:00	ES	Futures	2461.74	2463.92	2460.65	2463.38	64784.0
2016-12-23 10:00:00	ES	Futures	2463.1	2464.19	2460.92	2461.74	52171.0
2016-12-23 11:00:00	ES	Futures	2461.74	2462.29	2459.56	2461.74	44021.0
2016-12-23 12:00:00	ES	Futures	2462.01	2462.56	2461.19	2461.19	22511.0
2016-12-23 13:00:00	ES	Futures	2461.47	2462.56	2460.92	2462.01	18467.0
2016-12-23 14:00:00	ES	Futures	2462.01	2463.1	2461.74	2462.56	20791.0
2016-12-23 15:00:00	ES	Futures	2462.83	2465.01	2462.29	2464.74	75114.0
2016-12-23 16:00:00	ES	Futures	2464.74	2466.1	2464.19	2464.47	37512.0
2016-12-23 00:00:00	NQ	Futures	5887.94	5888.54	5887.04	5887.34	251.0
2016-12-23 01:00:00	NQ	Futures	5887.34	5888.54	5887.34	5888.54	181.0
2016-12-23 02:00:00	NQ	Futures	5888.54	5891.22	5887.94	5889.73	413.0
2016-12-23 03:00:00	NQ	Futures	5889.43	5892.71	5884.66	5890.03	1516.0
2016-12-23 04:00:00	NQ	Futures	5889.13	5892.41	5888.24	5891.22	705.0
2016-12-23 05:00:00	NQ	Futures	5891.22	5892.41	5887.94	5888.54	434.0
2016-12-23 06:00:00	NQ	Futures	5888.24	5888.83	5885.25	5887.94	837.0
2016-12-23 07:00:00	NQ	Futures	5888.24	5888.54	5879.59	5883.76	1208.0
2016-12-23 08:00:00	NQ	Futures	5883.76	5886.75	5880.78	5882.87	1225.0
2016-12-23 09:00:00	NQ	Futures	5882.57	5895.69	5877.5	5890.62	15759.0
2016-12-23 10:00:00	NQ	Futures	5890.92	5895.69	5879.59	5881.08	11114.0
2016-12-23 11:00:00	NQ	Futures	5881.38	5884.06	5874.22	5881.67	8749.0
2016-12-23 12:00:00	NQ	Futures	5881.97	5889.13	5881.97	5883.76	4656.0
2016-12-23 13:00:00	NQ	Futures	5884.06	5889.13	5883.46	5886.15	2861.0
2016-12-23 14:00:00	NQ	Futures	5886.15	5889.43	5884.96	5887.94	2649.0
2016-12-23 15:00:00	NQ	Futures	5887.64	5896.59	5887.04	5894.8	8145.0
2016-12-23 16:00:00	NQ	Futures	5894.8	5899.27	5893.9	5895.99	3412.0
2016-12-23 00:00:00	YM	Futures	21565.1	21565.1	21559.7	21561.9	202.0
2016-12-23 01:00:00	YM	Futures	21561.9	21563.0	21558.6	21563.0	272.0
2016-12-23 02:00:00	YM	Futures	21563.0	21572.7	21561.9	21567.3	706.0
2016-12-23 03:00:00	YM	Futures	21567.3	21576.0	21556.5	21559.7	2171.0
2016-12-23 04:00:00	YM	Futures	21559.7	21563.0	21554.3	21558.6	893.0
2016-12-23 05:00:00	YM	Futures	21557.6	21563.0	21556.5	21558.6	608.0
2016-12-23 06:00:00	YM	Futures	21557.6	21561.9	21550.0	21554.3	671.0
2016-12-23 07:00:00	YM	Futures	21554.3	21555.4	21529.3	21539.1	1515.0
2016-12-23 08:00:00	YM	Futures	21539.1	21544.5	21532.6	21535.9	1302.0
2016-12-23 09:00:00	YM	Futures	21535.9	21551.0	21528.3	21546.7	8676.0
2016-12-23 10:00:00	YM	Futures	21546.7	21555.4	21533.7	21535.9	6004.0
2016-12-23 11:00:00	YM	Futures	21536.9	21543.5	21527.2	21534.8	4127.0
2016-12-23 12:00:00	YM	Futures	21535.9	21542.4	21533.7	21535.9	2011.0
2016-12-23 13:00:00	YM	Futures	21536.9	21546.7	21532.6	21544.5	1894.0
2016-12-23 14:00:00	YM	Futures	21543.5	21548.9	21540.2	21545.6	1817.0
2016-12-23 15:00:00	YM	Futures	21544.5	21558.6	21538.0	21557.6	4456.0

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

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