PREVIEW / futures_1hour / 2016-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-14.parquet
  size:    54 KB
  rows:    1,647

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-14 00:00:00	ES	Futures	2474.01	2474.29	2472.92	2472.92	2068.0
2016-12-14 01:00:00	ES	Futures	2473.2	2473.47	2472.65	2472.92	2153.0
2016-12-14 02:00:00	ES	Futures	2473.2	2473.2	2471.29	2471.83	5059.0
2016-12-14 03:00:00	ES	Futures	2471.83	2474.83	2471.29	2473.74	15579.0
2016-12-14 04:00:00	ES	Futures	2474.01	2475.38	2472.92	2473.2	8610.0
2016-12-14 05:00:00	ES	Futures	2473.2	2474.56	2472.38	2473.74	5916.0
2016-12-14 06:00:00	ES	Futures	2474.01	2474.56	2471.56	2474.56	9957.0
2016-12-14 07:00:00	ES	Futures	2474.29	2475.38	2473.2	2474.01	9511.0
2016-12-14 08:00:00	ES	Futures	2474.01	2474.01	2470.2	2471.83	22367.0
2016-12-14 09:00:00	ES	Futures	2471.56	2474.29	2468.83	2471.29	145858.0
2016-12-14 10:00:00	ES	Futures	2471.29	2472.1	2467.47	2469.92	220742.0
2016-12-14 11:00:00	ES	Futures	2469.92	2470.74	2466.1	2468.01	135362.0
2016-12-14 12:00:00	ES	Futures	2468.29	2472.92	2468.01	2472.65	82941.0
2016-12-14 13:00:00	ES	Futures	2472.38	2475.65	2471.56	2475.11	101719.0
2016-12-14 14:00:00	ES	Futures	2474.56	2479.47	2457.1	2457.92	420215.0
2016-12-14 15:00:00	ES	Futures	2457.92	2465.83	2447.28	2453.56	488871.0
2016-12-14 16:00:00	ES	Futures	2453.56	2458.47	2453.28	2457.1	101487.0
2016-12-14 18:00:00	ES	Futures	2456.83	2457.92	2452.74	2457.65	8652.0
2016-12-14 19:00:00	ES	Futures	2457.65	2462.01	2457.38	2458.47	12473.0
2016-12-14 20:00:00	ES	Futures	2458.74	2460.38	2456.56	2460.1	7540.0
2016-12-14 21:00:00	ES	Futures	2459.83	2460.1	2456.28	2457.65	5830.0
2016-12-14 22:00:00	ES	Futures	2457.38	2460.65	2457.38	2460.38	4633.0
2016-12-14 23:00:00	ES	Futures	2460.38	2462.56	2460.1	2460.92	5883.0
2016-12-14 00:00:00	NQ	Futures	5898.08	5898.38	5893.61	5894.2	392.0
2016-12-14 01:00:00	NQ	Futures	5894.2	5895.4	5893.61	5895.4	206.0
2016-12-14 02:00:00	NQ	Futures	5895.69	5895.69	5891.22	5892.11	649.0
2016-12-14 03:00:00	NQ	Futures	5892.41	5896.89	5887.64	5895.1	2149.0
2016-12-14 04:00:00	NQ	Futures	5895.4	5897.78	5892.71	5893.61	1002.0
2016-12-14 05:00:00	NQ	Futures	5893.9	5895.69	5891.22	5894.2	573.0
2016-12-14 06:00:00	NQ	Futures	5894.2	5895.99	5890.32	5895.1	1180.0
2016-12-14 07:00:00	NQ	Futures	5895.1	5896.89	5893.01	5895.99	1433.0
2016-12-14 08:00:00	NQ	Futures	5895.99	5896.59	5888.83	5894.8	2861.0
2016-12-14 09:00:00	NQ	Futures	5894.8	5907.63	5888.54	5903.45	24548.0
2016-12-14 10:00:00	NQ	Futures	5903.75	5910.01	5896.29	5899.87	26038.0
2016-12-14 11:00:00	NQ	Futures	5899.57	5901.66	5888.24	5897.78	18579.0
2016-12-14 12:00:00	NQ	Futures	5897.78	5904.94	5896.59	5903.75	8600.0
2016-12-14 13:00:00	NQ	Futures	5903.75	5911.8	5900.77	5909.12	12399.0
2016-12-14 14:00:00	NQ	Futures	5909.42	5915.68	5859.6	5884.06	80574.0
2016-12-14 15:00:00	NQ	Futures	5884.06	5908.82	5860.19	5875.11	60969.0
2016-12-14 16:00:00	NQ	Futures	5875.11	5890.62	5874.22	5884.96	11231.0
2016-12-14 18:00:00	NQ	Futures	5883.76	5883.76	5872.43	5883.76	1312.0
2016-12-14 19:00:00	NQ	Futures	5883.46	5893.9	5880.48	5881.97	2578.0
2016-12-14 20:00:00	NQ	Futures	5881.97	5887.04	5876.6	5885.25	1370.0
2016-12-14 21:00:00	NQ	Futures	5884.96	5889.13	5876.01	5878.69	1289.0
2016-12-14 22:00:00	NQ	Futures	5878.39	5889.43	5878.39	5888.54	656.0
2016-12-14 23:00:00	NQ	Futures	5888.54	5892.41	5887.94	5891.22	1009.0
2016-12-14 00:00:00	YM	Futures	21538.0	21538.0	21527.2	21529.3	422.0
2016-12-14 01:00:00	YM	Futures	21528.3	21531.5	21526.1	21529.3	433.0
2016-12-14 02:00:00	YM	Futures	21528.3	21530.4	21510.9	21513.1	1255.0
2016-12-14 03:00:00	YM	Futures	21514.2	21540.2	21507.7	21532.6	2522.0

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

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