PREVIEW / futures_1hour / 2018-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-21.parquet
  size:    16 KB
  rows:    310

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-10-21 18:00:00	ES	Futures	3000.68	3005.58	2995.24	2999.87	19763.0
2018-10-21 19:00:00	ES	Futures	2999.87	3002.32	2997.15	3000.96	11556.0
2018-10-21 20:00:00	ES	Futures	3000.96	3001.77	2991.71	2996.88	23599.0
2018-10-21 21:00:00	ES	Futures	2996.88	3007.76	2996.6	3003.4	21592.0
2018-10-21 22:00:00	ES	Futures	3003.4	3011.02	3002.32	3010.48	16040.0
2018-10-21 23:00:00	ES	Futures	3010.75	3017.28	3008.57	3014.83	15005.0
2018-10-21 18:00:00	NQ	Futures	8313.4	8319.56	8285.83	8305.48	6994.0
2018-10-21 19:00:00	NQ	Futures	8306.07	8314.87	8297.27	8309.59	4226.0
2018-10-21 20:00:00	NQ	Futures	8309.59	8313.7	8279.67	8297.56	9392.0
2018-10-21 21:00:00	NQ	Futures	8297.56	8343.32	8295.51	8328.95	10255.0
2018-10-21 22:00:00	NQ	Futures	8328.95	8356.81	8326.6	8354.17	9299.0
2018-10-21 23:00:00	NQ	Futures	8354.47	8374.12	8346.55	8369.13	8155.0
2018-10-21 18:00:00	YM	Futures	27563.7	27586.5	27497.5	27540.9	3312.0
2018-10-21 19:00:00	YM	Futures	27540.9	27560.5	27513.8	27542.0	2095.0
2018-10-21 20:00:00	YM	Futures	27544.2	27554.0	27463.8	27511.6	4489.0
2018-10-21 21:00:00	YM	Futures	27511.6	27597.4	27507.2	27559.4	4599.0
2018-10-21 22:00:00	YM	Futures	27559.4	27628.9	27550.7	27624.6	3063.0
2018-10-21 23:00:00	YM	Futures	27625.7	27687.6	27603.9	27663.7	3154.0
2018-10-21 18:00:00	CL	Futures	63.98	64.06	63.7	63.72	3957.0
2018-10-21 19:00:00	CL	Futures	63.72	63.92	63.71	63.84	2001.0
2018-10-21 20:00:00	CL	Futures	63.85	63.85	63.6	63.65	5304.0
2018-10-21 21:00:00	CL	Futures	63.66	63.8	63.59	63.79	6067.0
2018-10-21 22:00:00	CL	Futures	63.79	63.88	63.77	63.87	3863.0
2018-10-21 23:00:00	CL	Futures	63.88	63.94	63.81	63.9	3407.0
2018-10-21 18:00:00	GC	Futures	1603.2	1604.2	1602.1	1602.8	1906.0
2018-10-21 19:00:00	GC	Futures	1602.8	1603.4	1602.1	1602.9	1473.0
2018-10-21 20:00:00	GC	Futures	1602.9	1605.9	1602.2	1602.8	6004.0
2018-10-21 21:00:00	GC	Futures	1602.8	1603.7	1601.6	1603.0	4958.0
2018-10-21 22:00:00	GC	Futures	1603.0	1604.3	1603.0	1603.8	4410.0
2018-10-21 23:00:00	GC	Futures	1603.7	1604.3	1602.8	1604.2	4240.0
2018-10-21 18:00:00	ZN	Futures	118.826924	118.921356	118.811186	118.889879	11828.0
2018-10-21 19:00:00	ZN	Futures	118.889879	118.905618	118.826924	118.858402	8348.0
2018-10-21 20:00:00	ZN	Futures	118.87414	118.921356	118.842663	118.889879	19943.0
2018-10-21 21:00:00	ZN	Futures	118.889879	118.889879	118.826924	118.858402	18424.0
2018-10-21 22:00:00	ZN	Futures	118.858402	118.858402	118.811186	118.811186	11592.0
2018-10-21 23:00:00	ZN	Futures	118.795447	118.826924	118.795447	118.811186	8503.0

> showing 36 of 310 rows — these rows as CSV

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