PREVIEW / futures_1hour / 2016-12-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	2469.1	2469.92	2469.1	2469.65	1085.0
2016-12-28 01:00:00	ES	Futures	2469.92	2471.29	2469.65	2471.29	2314.0
2016-12-28 02:00:00	ES	Futures	2471.29	2472.92	2471.01	2471.83	3999.0
2016-12-28 03:00:00	ES	Futures	2471.83	2472.65	2470.47	2471.29	8120.0
2016-12-28 04:00:00	ES	Futures	2471.56	2472.92	2470.74	2472.1	4733.0
2016-12-28 05:00:00	ES	Futures	2472.1	2472.92	2471.83	2472.65	2977.0
2016-12-28 06:00:00	ES	Futures	2472.65	2472.65	2471.56	2472.1	3487.0
2016-12-28 07:00:00	ES	Futures	2472.1	2472.65	2471.56	2472.38	4683.0
2016-12-28 08:00:00	ES	Futures	2472.38	2473.47	2471.83	2473.2	9005.0
2016-12-28 09:00:00	ES	Futures	2473.47	2474.01	2461.74	2462.01	126827.0
2016-12-28 10:00:00	ES	Futures	2462.29	2462.56	2459.83	2460.92	145965.0
2016-12-28 11:00:00	ES	Futures	2460.92	2463.92	2460.1	2460.38	61249.0
2016-12-28 12:00:00	ES	Futures	2460.1	2460.38	2451.1	2453.28	158059.0
2016-12-28 13:00:00	ES	Futures	2453.56	2454.37	2450.83	2451.37	66742.0
2016-12-28 14:00:00	ES	Futures	2451.65	2453.01	2448.37	2451.1	105208.0
2016-12-28 15:00:00	ES	Futures	2450.83	2452.74	2447.83	2449.74	183104.0
2016-12-28 16:00:00	ES	Futures	2449.74	2451.1	2448.37	2449.19	75083.0
2016-12-28 18:00:00	ES	Futures	2450.01	2451.92	2450.01	2451.37	3376.0
2016-12-28 19:00:00	ES	Futures	2451.37	2451.37	2450.01	2450.28	3282.0
2016-12-28 20:00:00	ES	Futures	2450.28	2451.37	2448.92	2450.83	5108.0
2016-12-28 21:00:00	ES	Futures	2450.83	2451.65	2450.56	2451.37	1280.0
2016-12-28 22:00:00	ES	Futures	2451.1	2451.92	2450.83	2451.1	1808.0
2016-12-28 23:00:00	ES	Futures	2451.1	2451.65	2450.83	2451.65	1468.0
2016-12-28 00:00:00	NQ	Futures	5928.21	5930.9	5928.21	5930.3	307.0
2016-12-28 01:00:00	NQ	Futures	5930.6	5935.37	5930.3	5934.48	616.0
2016-12-28 02:00:00	NQ	Futures	5935.07	5938.65	5934.18	5935.37	924.0
2016-12-28 03:00:00	NQ	Futures	5935.37	5938.65	5933.28	5935.37	1144.0
2016-12-28 04:00:00	NQ	Futures	5935.07	5939.85	5933.58	5937.76	810.0
2016-12-28 05:00:00	NQ	Futures	5937.76	5939.55	5936.27	5937.16	624.0
2016-12-28 06:00:00	NQ	Futures	5937.16	5937.16	5935.07	5935.97	567.0
2016-12-28 07:00:00	NQ	Futures	5936.27	5937.76	5935.07	5937.16	762.0
2016-12-28 08:00:00	NQ	Futures	5936.86	5941.64	5933.58	5938.35	2420.0
2016-12-28 09:00:00	NQ	Futures	5938.35	5941.34	5902.26	5904.05	20589.0
2016-12-28 10:00:00	NQ	Futures	5903.75	5909.42	5891.52	5897.19	25826.0
2016-12-28 11:00:00	NQ	Futures	5896.89	5911.8	5895.69	5899.27	13134.0
2016-12-28 12:00:00	NQ	Futures	5899.57	5899.57	5878.09	5882.87	18055.0
2016-12-28 13:00:00	NQ	Futures	5882.87	5886.75	5875.71	5878.69	9922.0
2016-12-28 14:00:00	NQ	Futures	5878.99	5884.66	5873.62	5882.27	10310.0
2016-12-28 15:00:00	NQ	Futures	5881.67	5886.15	5871.23	5876.3	18647.0
2016-12-28 16:00:00	NQ	Futures	5876.01	5878.69	5872.43	5873.62	4543.0
2016-12-28 18:00:00	NQ	Futures	5875.41	5880.18	5875.11	5878.09	657.0
2016-12-28 19:00:00	NQ	Futures	5878.09	5878.09	5872.43	5873.62	918.0
2016-12-28 20:00:00	NQ	Futures	5873.62	5878.69	5869.14	5877.5	1562.0
2016-12-28 21:00:00	NQ	Futures	5877.5	5878.39	5875.71	5875.71	351.0
2016-12-28 22:00:00	NQ	Futures	5876.01	5877.2	5874.51	5875.71	544.0
2016-12-28 23:00:00	NQ	Futures	5876.01	5877.5	5876.01	5877.5	312.0
2016-12-28 00:00:00	YM	Futures	21579.2	21583.6	21579.2	21581.4	429.0
2016-12-28 01:00:00	YM	Futures	21582.5	21592.3	21582.5	21591.2	588.0
2016-12-28 02:00:00	YM	Futures	21592.3	21600.9	21589.0	21593.4	1205.0
2016-12-28 03:00:00	YM	Futures	21593.4	21597.7	21585.8	21590.1	1529.0

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

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