PREVIEW / futures_1hour / 2016-12-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-15.parquet
  size:    55 KB
  rows:    1,635

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-15 00:00:00	ES	Futures	2461.19	2461.74	2459.28	2459.56	3524.0
2016-12-15 01:00:00	ES	Futures	2459.56	2460.65	2458.19	2459.01	5193.0
2016-12-15 02:00:00	ES	Futures	2459.01	2461.19	2456.56	2460.38	10829.0
2016-12-15 03:00:00	ES	Futures	2460.38	2462.29	2455.47	2457.65	25734.0
2016-12-15 04:00:00	ES	Futures	2457.92	2459.83	2456.28	2456.83	15226.0
2016-12-15 05:00:00	ES	Futures	2456.83	2462.56	2456.56	2462.56	24103.0
2016-12-15 06:00:00	ES	Futures	2462.29	2463.38	2456.28	2456.83	20413.0
2016-12-15 07:00:00	ES	Futures	2456.83	2457.92	2454.65	2455.47	21282.0
2016-12-15 08:00:00	ES	Futures	2455.47	2458.47	2451.92	2457.38	47732.0
2016-12-15 09:00:00	ES	Futures	2457.38	2467.47	2454.1	2466.65	263594.0
2016-12-15 10:00:00	ES	Futures	2466.65	2470.47	2464.47	2468.01	283105.0
2016-12-15 11:00:00	ES	Futures	2467.74	2474.29	2467.2	2469.38	181474.0
2016-12-15 12:00:00	ES	Futures	2469.65	2470.47	2465.01	2467.74	130349.0
2016-12-15 13:00:00	ES	Futures	2467.74	2470.47	2457.92	2459.56	148391.0
2016-12-15 14:00:00	ES	Futures	2459.56	2465.83	2458.19	2463.1	144454.0
2016-12-15 15:00:00	ES	Futures	2463.38	2465.83	2461.19	2462.83	247293.0
2016-12-15 16:00:00	ES	Futures	2462.83	2466.1	2462.29	2465.56	86096.0
2016-12-15 18:00:00	ES	Futures	2465.29	2467.2	2464.19	2465.83	5628.0
2016-12-15 19:00:00	ES	Futures	2465.56	2466.38	2463.65	2463.92	4885.0
2016-12-15 20:00:00	ES	Futures	2463.65	2465.56	2463.38	2465.01	3979.0
2016-12-15 21:00:00	ES	Futures	2465.01	2466.1	2464.74	2466.1	2744.0
2016-12-15 22:00:00	ES	Futures	2465.83	2465.83	2464.74	2465.01	1399.0
2016-12-15 23:00:00	ES	Futures	2465.29	2465.56	2464.19	2465.29	2767.0
2016-12-15 00:00:00	NQ	Futures	5891.22	5892.41	5886.75	5887.64	416.0
2016-12-15 01:00:00	NQ	Futures	5887.34	5890.03	5883.76	5885.25	539.0
2016-12-15 02:00:00	NQ	Futures	5885.55	5892.41	5880.48	5889.43	1689.0
2016-12-15 03:00:00	NQ	Futures	5889.43	5893.01	5876.6	5881.67	3283.0
2016-12-15 04:00:00	NQ	Futures	5881.67	5889.43	5878.99	5881.38	2081.0
2016-12-15 05:00:00	NQ	Futures	5881.08	5893.61	5880.78	5893.01	1954.0
2016-12-15 06:00:00	NQ	Futures	5892.71	5894.8	5878.69	5880.18	2073.0
2016-12-15 07:00:00	NQ	Futures	5879.88	5881.97	5873.92	5876.6	3079.0
2016-12-15 08:00:00	NQ	Futures	5876.9	5883.76	5868.85	5882.87	6403.0
2016-12-15 09:00:00	NQ	Futures	5882.87	5903.45	5875.41	5901.66	38919.0
2016-12-15 10:00:00	NQ	Futures	5902.26	5907.03	5889.73	5894.8	37348.0
2016-12-15 11:00:00	NQ	Futures	5895.1	5920.75	5894.8	5905.84	32285.0
2016-12-15 12:00:00	NQ	Futures	5905.24	5912.1	5898.08	5907.03	15356.0
2016-12-15 13:00:00	NQ	Futures	5907.33	5915.38	5869.74	5876.6	28638.0
2016-12-15 14:00:00	NQ	Futures	5876.3	5894.8	5869.74	5886.45	17601.0
2016-12-15 15:00:00	NQ	Futures	5886.75	5898.38	5883.17	5886.75	22037.0
2016-12-15 16:00:00	NQ	Futures	5887.04	5894.2	5885.55	5892.71	5975.0
2016-12-15 18:00:00	NQ	Futures	5894.8	5896.89	5888.54	5895.1	1099.0
2016-12-15 19:00:00	NQ	Futures	5894.8	5895.99	5888.54	5889.43	980.0
2016-12-15 20:00:00	NQ	Futures	5889.13	5890.92	5887.04	5890.32	680.0
2016-12-15 21:00:00	NQ	Futures	5889.73	5895.1	5889.43	5894.5	492.0
2016-12-15 22:00:00	NQ	Futures	5894.2	5894.5	5891.22	5891.82	252.0
2016-12-15 23:00:00	NQ	Futures	5892.11	5893.31	5890.32	5892.41	280.0
2016-12-15 00:00:00	YM	Futures	21481.6	21487.0	21471.9	21475.1	787.0
2016-12-15 01:00:00	YM	Futures	21475.1	21484.9	21465.3	21474.0	979.0
2016-12-15 02:00:00	YM	Futures	21472.9	21486.0	21454.5	21480.5	2057.0
2016-12-15 03:00:00	YM	Futures	21479.4	21492.5	21445.8	21464.3	5989.0

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

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