PREVIEW / futures_1hour / 2020-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-18.parquet
  size:    17 KB
  rows:    364

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
2020-10-18 18:00:00	ES	Futures	3888.83	3897.8	3887.71	3896.11	12664.0
2020-10-18 19:00:00	ES	Futures	3896.11	3898.64	3893.87	3896.11	5214.0
2020-10-18 20:00:00	ES	Futures	3896.11	3900.6	3895.83	3900.32	7049.0
2020-10-18 21:00:00	ES	Futures	3900.32	3906.2	3897.8	3902.84	11260.0
2020-10-18 22:00:00	ES	Futures	3902.84	3907.32	3900.6	3903.4	7411.0
2020-10-18 23:00:00	ES	Futures	3903.12	3904.52	3899.2	3903.68	5597.0
2020-10-18 18:00:00	NQ	Futures	13682.32	13765.97	13682.32	13747.45	7656.0
2020-10-18 19:00:00	NQ	Futures	13746.29	13762.21	13741.37	13748.03	3042.0
2020-10-18 20:00:00	NQ	Futures	13747.45	13763.95	13746.29	13758.16	2890.0
2020-10-18 21:00:00	NQ	Futures	13757.29	13790.0	13748.32	13778.71	5614.0
2020-10-18 22:00:00	NQ	Futures	13778.13	13803.03	13763.66	13779.58	4999.0
2020-10-18 23:00:00	NQ	Futures	13779.87	13782.47	13736.74	13763.08	5232.0
2020-10-18 18:00:00	YM	Futures	31505.7	31538.9	31472.6	31519.0	1629.0
2020-10-18 19:00:00	YM	Futures	31519.0	31544.4	31502.4	31522.3	896.0
2020-10-18 20:00:00	YM	Futures	31521.2	31567.6	31521.2	31564.3	1070.0
2020-10-18 21:00:00	YM	Futures	31563.2	31609.7	31540.0	31577.6	1915.0
2020-10-18 22:00:00	YM	Futures	31574.3	31609.7	31556.6	31584.2	1299.0
2020-10-18 23:00:00	YM	Futures	31582.0	31599.7	31552.2	31590.9	1205.0
2020-10-18 18:00:00	CL	Futures	28.0	28.3	28.0	28.21	4762.0
2020-10-18 19:00:00	CL	Futures	28.2	28.28	28.19	28.19	1570.0
2020-10-18 20:00:00	CL	Futures	28.19	28.26	28.13	28.15	2201.0
2020-10-18 21:00:00	CL	Futures	28.16	28.22	28.08	28.11	3064.0
2020-10-18 22:00:00	CL	Futures	28.11	28.13	28.04	28.06	1921.0
2020-10-18 23:00:00	CL	Futures	28.06	28.06	27.95	28.02	2403.0
2020-10-18 18:00:00	GC	Futures	2314.6	2318.7	2313.6	2315.7	2175.0
2020-10-18 19:00:00	GC	Futures	2315.9	2316.8	2313.3	2316.1	1325.0
2020-10-18 20:00:00	GC	Futures	2316.1	2318.0	2313.9	2316.7	2092.0
2020-10-18 21:00:00	GC	Futures	2316.7	2318.9	2311.0	2316.4	6514.0
2020-10-18 22:00:00	GC	Futures	2316.3	2317.2	2314.5	2316.8	2287.0
2020-10-18 23:00:00	GC	Futures	2316.9	2317.3	2313.6	2315.5	2058.0
2020-10-18 18:00:00	ZN	Futures	138.851482	138.867087	138.789063	138.789063	12085.0
2020-10-18 19:00:00	ZN	Futures	138.804668	138.804668	138.726644	138.742249	19403.0
2020-10-18 20:00:00	ZN	Futures	138.757854	138.789063	138.742249	138.773458	6749.0
2020-10-18 21:00:00	ZN	Futures	138.773458	138.773458	138.711039	138.742249	18555.0
2020-10-18 22:00:00	ZN	Futures	138.726644	138.757854	138.711039	138.726644	6833.0
2020-10-18 23:00:00	ZN	Futures	138.742249	138.757854	138.726644	138.757854	2586.0

> showing 36 of 364 rows — these rows as CSV

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