PREVIEW / futures_1hour / 2016-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-21.parquet
  size:    51 KB
  rows:    1,597

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-21 00:00:00	ES	Futures	2472.1	2472.65	2471.83	2472.38	1478.0
2016-12-21 01:00:00	ES	Futures	2472.38	2472.65	2472.1	2472.38	1005.0
2016-12-21 02:00:00	ES	Futures	2472.1	2473.47	2471.56	2471.83	3041.0
2016-12-21 03:00:00	ES	Futures	2471.83	2474.01	2470.47	2472.38	9735.0
2016-12-21 04:00:00	ES	Futures	2472.65	2473.74	2472.1	2472.38	5135.0
2016-12-21 05:00:00	ES	Futures	2472.1	2473.2	2472.1	2472.92	3750.0
2016-12-21 06:00:00	ES	Futures	2472.92	2473.2	2470.47	2470.74	5994.0
2016-12-21 07:00:00	ES	Futures	2470.74	2471.83	2469.65	2471.83	9678.0
2016-12-21 08:00:00	ES	Futures	2471.83	2472.38	2471.01	2471.56	10442.0
2016-12-21 09:00:00	ES	Futures	2471.83	2474.56	2470.2	2470.74	116135.0
2016-12-21 10:00:00	ES	Futures	2470.74	2472.1	2469.38	2469.38	104075.0
2016-12-21 11:00:00	ES	Futures	2469.65	2471.83	2469.1	2470.47	53681.0
2016-12-21 12:00:00	ES	Futures	2470.74	2472.1	2470.47	2471.01	35899.0
2016-12-21 13:00:00	ES	Futures	2471.29	2471.83	2469.92	2469.92	38186.0
2016-12-21 14:00:00	ES	Futures	2469.92	2471.56	2469.92	2471.01	33456.0
2016-12-21 15:00:00	ES	Futures	2471.29	2471.56	2466.1	2466.92	136460.0
2016-12-21 16:00:00	ES	Futures	2466.92	2467.74	2463.65	2463.92	66977.0
2016-12-21 18:00:00	ES	Futures	2463.92	2465.29	2463.92	2465.01	3586.0
2016-12-21 19:00:00	ES	Futures	2464.74	2465.29	2463.92	2465.01	2688.0
2016-12-21 20:00:00	ES	Futures	2465.01	2465.83	2464.47	2465.01	2404.0
2016-12-21 21:00:00	ES	Futures	2465.01	2465.01	2462.56	2463.1	3863.0
2016-12-21 22:00:00	ES	Futures	2463.38	2463.65	2461.47	2462.01	3610.0
2016-12-21 23:00:00	ES	Futures	2462.01	2462.56	2461.47	2462.01	3778.0
2016-12-21 00:00:00	NQ	Futures	5913.59	5915.68	5913.59	5914.79	423.0
2016-12-21 01:00:00	NQ	Futures	5914.79	5915.68	5913.89	5914.79	341.0
2016-12-21 02:00:00	NQ	Futures	5914.49	5916.58	5913.3	5913.89	456.0
2016-12-21 03:00:00	NQ	Futures	5913.59	5918.67	5910.31	5913.89	1154.0
2016-12-21 04:00:00	NQ	Futures	5914.19	5917.47	5913.89	5914.19	505.0
2016-12-21 05:00:00	NQ	Futures	5914.19	5915.09	5913.0	5914.19	462.0
2016-12-21 06:00:00	NQ	Futures	5914.19	5914.79	5909.12	5909.42	913.0
2016-12-21 07:00:00	NQ	Futures	5909.42	5912.1	5907.03	5912.1	1509.0
2016-12-21 08:00:00	NQ	Futures	5911.8	5914.79	5910.01	5913.89	1563.0
2016-12-21 09:00:00	NQ	Futures	5913.89	5918.37	5903.45	5905.84	17758.0
2016-12-21 10:00:00	NQ	Futures	5905.54	5910.91	5893.9	5895.4	17472.0
2016-12-21 11:00:00	NQ	Futures	5895.4	5905.84	5894.5	5905.24	11565.0
2016-12-21 12:00:00	NQ	Futures	5904.94	5910.31	5904.94	5907.63	6787.0
2016-12-21 13:00:00	NQ	Futures	5907.93	5912.7	5905.84	5909.72	6017.0
2016-12-21 14:00:00	NQ	Futures	5909.72	5915.09	5909.42	5913.59	5417.0
2016-12-21 15:00:00	NQ	Futures	5913.89	5914.19	5904.64	5906.73	11942.0
2016-12-21 16:00:00	NQ	Futures	5906.73	5908.22	5901.36	5903.45	3248.0
2016-12-21 18:00:00	NQ	Futures	5904.35	5905.24	5901.66	5904.05	562.0
2016-12-21 19:00:00	NQ	Futures	5904.05	5905.54	5900.77	5904.35	519.0
2016-12-21 20:00:00	NQ	Futures	5904.35	5905.84	5903.15	5903.15	479.0
2016-12-21 21:00:00	NQ	Futures	5902.85	5903.15	5897.78	5899.27	681.0
2016-12-21 22:00:00	NQ	Futures	5899.27	5899.87	5895.1	5896.29	702.0
2016-12-21 23:00:00	NQ	Futures	5896.29	5898.08	5895.4	5895.99	529.0
2016-12-21 00:00:00	YM	Futures	21591.2	21598.8	21591.2	21595.5	648.0
2016-12-21 01:00:00	YM	Futures	21596.6	21597.7	21594.4	21596.6	264.0
2016-12-21 02:00:00	YM	Futures	21596.6	21603.1	21593.4	21593.4	796.0
2016-12-21 03:00:00	YM	Futures	21593.4	21612.9	21584.7	21600.9	2401.0

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

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