PREVIEW / futures_1hour / 2020-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-21.parquet
  size:    17 KB
  rows:    358

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-06-21 18:00:00	ES	Futures	3395.88	3413.19	3381.36	3409.28	41825.0
2020-06-21 19:00:00	ES	Futures	3409.56	3412.08	3399.23	3410.96	12906.0
2020-06-21 20:00:00	ES	Futures	3411.24	3417.66	3405.65	3415.15	22301.0
2020-06-21 21:00:00	ES	Futures	3415.15	3433.58	3414.87	3424.36	27046.0
2020-06-21 22:00:00	ES	Futures	3424.08	3436.09	3423.25	3433.02	12537.0
2020-06-21 23:00:00	ES	Futures	3433.02	3443.63	3429.67	3439.44	13193.0
2020-06-21 18:00:00	NQ	Futures	11414.46	11458.12	11386.12	11448.0	9268.0
2020-06-21 19:00:00	NQ	Futures	11449.73	11460.72	11422.84	11457.54	3414.0
2020-06-21 20:00:00	NQ	Futures	11458.41	11483.57	11445.69	11471.13	5817.0
2020-06-21 21:00:00	NQ	Futures	11471.71	11537.65	11470.56	11520.29	8451.0
2020-06-21 22:00:00	NQ	Futures	11520.29	11548.34	11517.98	11533.02	4193.0
2020-06-21 23:00:00	NQ	Futures	11532.15	11561.65	11526.37	11554.13	4901.0
2020-06-21 18:00:00	YM	Futures	27935.9	28048.2	27781.8	28024.0	7787.0
2020-06-21 19:00:00	YM	Futures	28026.2	28055.9	27924.9	28038.3	3253.0
2020-06-21 20:00:00	YM	Futures	28041.6	28104.4	27987.7	28070.3	4352.0
2020-06-21 21:00:00	YM	Futures	28075.8	28243.1	28073.6	28141.8	5724.0
2020-06-21 22:00:00	YM	Futures	28142.9	28258.6	28136.3	28227.7	2999.0
2020-06-21 23:00:00	YM	Futures	28227.7	28346.6	28192.5	28294.9	4203.0
2020-06-21 18:00:00	CL	Futures	27.37	28.03	27.36	27.96	7079.0
2020-06-21 19:00:00	CL	Futures	27.94	28.05	27.85	27.96	3076.0
2020-06-21 20:00:00	CL	Futures	27.96	28.12	27.83	27.92	6956.0
2020-06-21 21:00:00	CL	Futures	27.93	28.18	27.92	28.03	5874.0
2020-06-21 22:00:00	CL	Futures	28.03	28.13	27.96	28.0	3736.0
2020-06-21 23:00:00	CL	Futures	28.0	28.01	27.82	27.92	4335.0
2020-06-21 18:00:00	GC	Futures	2179.9	2180.4	2172.0	2172.8	7287.0
2020-06-21 19:00:00	GC	Futures	2173.0	2176.1	2172.2	2175.9	1898.0
2020-06-21 20:00:00	GC	Futures	2175.7	2179.6	2175.7	2177.8	4308.0
2020-06-21 21:00:00	GC	Futures	2177.7	2193.4	2175.4	2190.8	15901.0
2020-06-21 22:00:00	GC	Futures	2190.9	2191.2	2181.3	2182.7	7467.0
2020-06-21 23:00:00	GC	Futures	2182.7	2185.2	2179.2	2182.5	5742.0
2020-06-21 18:00:00	ZN	Futures	138.555585	138.555585	138.446498	138.446498	9327.0
2020-06-21 19:00:00	ZN	Futures	138.446498	138.49325	138.415331	138.446498	5712.0
2020-06-21 20:00:00	ZN	Futures	138.430915	138.477666	138.399747	138.446498	12980.0
2020-06-21 21:00:00	ZN	Futures	138.446498	138.462082	138.399747	138.446498	11188.0
2020-06-21 22:00:00	ZN	Futures	138.446498	138.446498	138.399747	138.430915	6264.0
2020-06-21 23:00:00	ZN	Futures	138.430915	138.446498	138.415331	138.430915	3526.0

> showing 36 of 358 rows — these rows as CSV

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