PREVIEW / futures_1hour / 2016-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-29.parquet
  size:    52 KB
  rows:    1,624

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-29 00:00:00	ES	Futures	2451.65	2451.92	2450.01	2450.01	1700.0
2016-12-29 01:00:00	ES	Futures	2450.01	2451.37	2449.47	2450.83	3556.0
2016-12-29 02:00:00	ES	Futures	2450.83	2451.37	2446.46	2447.28	9104.0
2016-12-29 03:00:00	ES	Futures	2447.28	2449.74	2447.28	2449.19	10477.0
2016-12-29 04:00:00	ES	Futures	2449.47	2451.1	2448.65	2449.47	9138.0
2016-12-29 05:00:00	ES	Futures	2449.74	2451.37	2448.92	2451.37	5630.0
2016-12-29 06:00:00	ES	Futures	2451.1	2451.37	2449.47	2450.01	5373.0
2016-12-29 07:00:00	ES	Futures	2450.01	2451.92	2449.74	2451.65	5856.0
2016-12-29 08:00:00	ES	Futures	2451.92	2452.47	2449.74	2450.83	14186.0
2016-12-29 09:00:00	ES	Futures	2450.56	2454.92	2449.19	2451.37	120683.0
2016-12-29 10:00:00	ES	Futures	2451.1	2453.56	2447.83	2448.65	124345.0
2016-12-29 11:00:00	ES	Futures	2448.65	2449.74	2445.65	2446.74	98570.0
2016-12-29 12:00:00	ES	Futures	2446.74	2448.92	2443.46	2446.74	102509.0
2016-12-29 13:00:00	ES	Futures	2446.74	2447.56	2444.83	2447.28	63948.0
2016-12-29 14:00:00	ES	Futures	2447.28	2450.83	2447.01	2448.65	103311.0
2016-12-29 15:00:00	ES	Futures	2448.65	2449.74	2447.28	2449.47	133219.0
2016-12-29 16:00:00	ES	Futures	2449.74	2451.1	2448.65	2450.83	54989.0
2016-12-29 18:00:00	ES	Futures	2450.83	2451.65	2450.28	2450.56	3107.0
2016-12-29 19:00:00	ES	Futures	2450.56	2451.1	2449.19	2450.28	4114.0
2016-12-29 20:00:00	ES	Futures	2450.01	2451.65	2449.74	2451.65	3428.0
2016-12-29 21:00:00	ES	Futures	2451.65	2452.47	2450.56	2451.65	2269.0
2016-12-29 22:00:00	ES	Futures	2451.65	2453.56	2451.1	2453.56	2929.0
2016-12-29 23:00:00	ES	Futures	2453.56	2454.92	2453.28	2454.65	4093.0
2016-12-29 00:00:00	NQ	Futures	5878.09	5878.39	5875.11	5875.11	358.0
2016-12-29 01:00:00	NQ	Futures	5875.11	5876.01	5872.43	5874.22	849.0
2016-12-29 02:00:00	NQ	Futures	5874.51	5876.6	5862.88	5864.67	1482.0
2016-12-29 03:00:00	NQ	Futures	5864.67	5870.64	5864.37	5869.74	1657.0
2016-12-29 04:00:00	NQ	Futures	5869.44	5874.51	5868.85	5869.74	918.0
2016-12-29 05:00:00	NQ	Futures	5870.64	5875.41	5869.74	5875.11	780.0
2016-12-29 06:00:00	NQ	Futures	5875.11	5876.01	5872.43	5872.72	720.0
2016-12-29 07:00:00	NQ	Futures	5872.72	5878.99	5872.72	5878.39	780.0
2016-12-29 08:00:00	NQ	Futures	5877.8	5878.99	5873.02	5877.5	2184.0
2016-12-29 09:00:00	NQ	Futures	5877.8	5887.04	5865.27	5869.74	23070.0
2016-12-29 10:00:00	NQ	Futures	5869.74	5879.88	5860.79	5864.37	21088.0
2016-12-29 11:00:00	NQ	Futures	5864.07	5864.67	5850.05	5853.03	15154.0
2016-12-29 12:00:00	NQ	Futures	5853.03	5867.35	5848.56	5862.58	12051.0
2016-12-29 13:00:00	NQ	Futures	5862.28	5864.37	5850.65	5855.72	8762.0
2016-12-29 14:00:00	NQ	Futures	5855.72	5864.37	5855.42	5861.39	9428.0
2016-12-29 15:00:00	NQ	Futures	5861.69	5868.55	5859.3	5866.16	13642.0
2016-12-29 16:00:00	NQ	Futures	5865.86	5872.43	5864.37	5870.64	3661.0
2016-12-29 18:00:00	NQ	Futures	5871.53	5875.71	5869.14	5869.44	754.0
2016-12-29 19:00:00	NQ	Futures	5869.44	5872.13	5867.65	5871.23	998.0
2016-12-29 20:00:00	NQ	Futures	5871.53	5877.8	5870.64	5876.9	1035.0
2016-12-29 21:00:00	NQ	Futures	5876.9	5878.99	5874.22	5877.2	490.0
2016-12-29 22:00:00	NQ	Futures	5877.5	5881.08	5876.3	5880.18	634.0
2016-12-29 23:00:00	NQ	Futures	5880.18	5887.94	5879.29	5887.04	1076.0
2016-12-29 00:00:00	YM	Futures	21462.1	21462.1	21450.2	21451.2	395.0
2016-12-29 01:00:00	YM	Futures	21452.3	21456.7	21444.7	21452.3	815.0
2016-12-29 02:00:00	YM	Futures	21454.5	21456.7	21427.4	21431.7	1881.0
2016-12-29 03:00:00	YM	Futures	21431.7	21449.1	21428.5	21437.1	2321.0

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

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