PREVIEW / futures_1hour / 2016-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-19.parquet
  size:    53 KB
  rows:    1,612

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-19 00:00:00	ES	Futures	2464.47	2466.38	2464.19	2466.1	2149.0
2016-12-19 01:00:00	ES	Futures	2465.83	2466.65	2465.56	2465.83	2357.0
2016-12-19 02:00:00	ES	Futures	2465.83	2466.1	2464.47	2464.47	3961.0
2016-12-19 03:00:00	ES	Futures	2464.74	2465.29	2462.83	2464.47	11823.0
2016-12-19 04:00:00	ES	Futures	2464.74	2464.74	2462.56	2463.65	6024.0
2016-12-19 05:00:00	ES	Futures	2463.65	2465.29	2463.1	2464.74	4599.0
2016-12-19 06:00:00	ES	Futures	2464.74	2464.74	2463.1	2463.1	5125.0
2016-12-19 07:00:00	ES	Futures	2463.1	2464.19	2462.56	2463.38	4297.0
2016-12-19 08:00:00	ES	Futures	2463.65	2463.92	2461.47	2462.01	15822.0
2016-12-19 09:00:00	ES	Futures	2462.29	2466.92	2459.28	2464.47	162160.0
2016-12-19 10:00:00	ES	Futures	2464.19	2468.83	2463.1	2467.74	145126.0
2016-12-19 11:00:00	ES	Futures	2468.01	2469.92	2462.01	2462.01	136495.0
2016-12-19 12:00:00	ES	Futures	2462.01	2466.38	2461.47	2465.29	66736.0
2016-12-19 13:00:00	ES	Futures	2465.56	2467.47	2463.65	2467.2	59528.0
2016-12-19 14:00:00	ES	Futures	2467.2	2468.56	2462.83	2463.38	69647.0
2016-12-19 15:00:00	ES	Futures	2463.38	2464.74	2459.56	2464.19	151901.0
2016-12-19 16:00:00	ES	Futures	2464.19	2467.2	2463.38	2466.65	52167.0
2016-12-19 18:00:00	ES	Futures	2466.1	2468.01	2465.83	2466.92	4905.0
2016-12-19 19:00:00	ES	Futures	2466.92	2468.01	2465.83	2467.2	3219.0
2016-12-19 20:00:00	ES	Futures	2466.92	2467.74	2466.38	2467.74	1665.0
2016-12-19 21:00:00	ES	Futures	2467.74	2467.74	2466.38	2466.65	1772.0
2016-12-19 22:00:00	ES	Futures	2466.65	2467.74	2465.83	2466.38	1416.0
2016-12-19 23:00:00	ES	Futures	2466.1	2468.01	2466.1	2467.74	2055.0
2016-12-19 00:00:00	NQ	Futures	5871.53	5875.41	5870.93	5874.81	470.0
2016-12-19 01:00:00	NQ	Futures	5874.51	5876.01	5873.62	5874.81	303.0
2016-12-19 02:00:00	NQ	Futures	5874.51	5876.01	5872.72	5872.72	563.0
2016-12-19 03:00:00	NQ	Futures	5872.43	5873.32	5869.14	5871.83	1378.0
2016-12-19 04:00:00	NQ	Futures	5872.13	5873.92	5868.25	5872.13	1055.0
2016-12-19 05:00:00	NQ	Futures	5871.83	5877.5	5871.23	5876.6	921.0
2016-12-19 06:00:00	NQ	Futures	5876.6	5876.9	5871.83	5872.13	884.0
2016-12-19 07:00:00	NQ	Futures	5872.43	5875.11	5870.34	5873.92	743.0
2016-12-19 08:00:00	NQ	Futures	5874.22	5876.3	5870.93	5873.92	2255.0
2016-12-19 09:00:00	NQ	Futures	5874.22	5897.78	5861.98	5892.71	24822.0
2016-12-19 10:00:00	NQ	Futures	5892.71	5917.77	5890.62	5911.51	29368.0
2016-12-19 11:00:00	NQ	Futures	5911.51	5926.12	5900.17	5901.06	25276.0
2016-12-19 12:00:00	NQ	Futures	5900.77	5913.3	5898.98	5907.93	8154.0
2016-12-19 13:00:00	NQ	Futures	5907.93	5910.91	5899.27	5908.52	8514.0
2016-12-19 14:00:00	NQ	Futures	5908.82	5911.8	5891.22	5892.41	10252.0
2016-12-19 15:00:00	NQ	Futures	5892.41	5895.1	5879.59	5889.43	19549.0
2016-12-19 16:00:00	NQ	Futures	5889.73	5896.89	5889.13	5895.99	4559.0
2016-12-19 18:00:00	NQ	Futures	5894.2	5899.57	5893.01	5897.19	723.0
2016-12-19 19:00:00	NQ	Futures	5897.48	5903.75	5895.99	5897.78	1253.0
2016-12-19 20:00:00	NQ	Futures	5898.08	5898.98	5895.99	5898.08	221.0
2016-12-19 21:00:00	NQ	Futures	5897.78	5897.78	5893.61	5895.99	538.0
2016-12-19 22:00:00	NQ	Futures	5895.99	5898.68	5893.9	5895.99	420.0
2016-12-19 23:00:00	NQ	Futures	5895.4	5899.87	5895.4	5898.98	390.0
2016-12-19 00:00:00	YM	Futures	21506.6	21520.7	21504.4	21519.6	806.0
2016-12-19 01:00:00	YM	Futures	21518.5	21525.0	21517.4	21520.7	686.0
2016-12-19 02:00:00	YM	Futures	21519.6	21522.8	21512.0	21514.2	1043.0
2016-12-19 03:00:00	YM	Futures	21512.0	21516.3	21500.1	21512.0	1953.0

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

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