PREVIEW / futures_1hour / 2018-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-07.parquet
  size:    14 KB
  rows:    299

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
2018-01-07 18:00:00	ES	Futures	2997.59	3004.15	2997.59	3001.96	17529.0
2018-01-07 19:00:00	ES	Futures	3001.96	3002.24	3001.14	3002.24	5232.0
2018-01-07 20:00:00	ES	Futures	3001.96	3002.51	3001.69	3002.24	4149.0
2018-01-07 21:00:00	ES	Futures	3002.24	3002.24	3000.87	3001.42	3303.0
2018-01-07 22:00:00	ES	Futures	3001.42	3002.51	3001.14	3001.42	3121.0
2018-01-07 23:00:00	ES	Futures	3001.14	3001.42	3000.6	3000.6	1618.0
2018-01-07 18:00:00	NQ	Futures	7910.47	7926.48	7908.39	7917.29	3507.0
2018-01-07 19:00:00	NQ	Futures	7917.29	7918.77	7915.21	7918.47	885.0
2018-01-07 20:00:00	NQ	Futures	7918.47	7919.66	7914.32	7916.1	1526.0
2018-01-07 21:00:00	NQ	Futures	7915.51	7915.8	7908.69	7914.91	1261.0
2018-01-07 22:00:00	NQ	Futures	7914.62	7916.99	7913.13	7914.02	617.0
2018-01-07 23:00:00	NQ	Futures	7913.43	7914.62	7910.76	7912.84	426.0
2018-01-07 18:00:00	YM	Futures	27467.6	27562.2	27465.5	27542.6	4132.0
2018-01-07 19:00:00	YM	Futures	27541.5	27552.4	27532.8	27550.2	1374.0
2018-01-07 20:00:00	YM	Futures	27549.2	27555.7	27542.6	27548.1	1203.0
2018-01-07 21:00:00	YM	Futures	27549.2	27549.2	27537.2	27547.0	611.0
2018-01-07 22:00:00	YM	Futures	27547.0	27549.2	27538.3	27540.5	726.0
2018-01-07 23:00:00	YM	Futures	27540.5	27542.6	27526.3	27531.8	730.0
2018-01-07 18:00:00	CL	Futures	54.66	54.77	54.66	54.7	3080.0
2018-01-07 19:00:00	CL	Futures	54.7	54.71	54.59	54.66	3217.0
2018-01-07 20:00:00	CL	Futures	54.66	54.74	54.66	54.67	4577.0
2018-01-07 21:00:00	CL	Futures	54.67	54.69	54.62	54.68	3428.0
2018-01-07 22:00:00	CL	Futures	54.69	54.71	54.65	54.67	1939.0
2018-01-07 23:00:00	CL	Futures	54.67	54.68	54.62	54.64	1638.0
2018-01-07 18:00:00	GC	Futures	1755.4	1756.4	1753.1	1753.7	2583.0
2018-01-07 19:00:00	GC	Futures	1753.7	1755.5	1753.3	1755.0	2744.0
2018-01-07 20:00:00	GC	Futures	1755.1	1757.0	1754.3	1755.2	6546.0
2018-01-07 21:00:00	GC	Futures	1755.2	1756.6	1753.8	1754.6	6664.0
2018-01-07 22:00:00	GC	Futures	1754.6	1755.5	1754.1	1754.6	2718.0
2018-01-07 23:00:00	GC	Futures	1754.7	1755.0	1753.7	1754.4	2477.0
2018-01-07 18:00:00	ZN	Futures	123.223115	123.238707	123.207523	123.238707	6191.0
2018-01-07 19:00:00	ZN	Futures	123.223115	123.254299	123.223115	123.254299	3236.0
2018-01-07 20:00:00	ZN	Futures	123.254299	123.254299	123.238707	123.254299	5239.0
2018-01-07 21:00:00	ZN	Futures	123.254299	123.254299	123.223115	123.238707	6659.0
2018-01-07 22:00:00	ZN	Futures	123.254299	123.254299	123.238707	123.238707	1099.0
2018-01-07 23:00:00	ZN	Futures	123.254299	123.254299	123.238707	123.238707	3352.0

> showing 36 of 299 rows — these rows as CSV

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