PREVIEW / futures_1hour / 2020-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-05.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-07-05 18:00:00	ES	Futures	3486.36	3500.6	3486.36	3499.48	14400.0
2020-07-05 19:00:00	ES	Futures	3499.48	3503.67	3495.85	3501.71	9238.0
2020-07-05 20:00:00	ES	Futures	3501.99	3508.69	3500.88	3507.86	12373.0
2020-07-05 21:00:00	ES	Futures	3507.86	3524.61	3507.86	3521.26	26685.0
2020-07-05 22:00:00	ES	Futures	3521.26	3528.52	3520.14	3526.29	15704.0
2020-07-05 23:00:00	ES	Futures	3526.29	3538.02	3523.49	3535.22	17810.0
2020-07-05 18:00:00	NQ	Futures	11968.81	12027.22	11962.16	12015.37	4666.0
2020-07-05 19:00:00	NQ	Futures	12015.95	12029.54	12007.27	12022.02	2917.0
2020-07-05 20:00:00	NQ	Futures	12022.02	12052.09	12019.71	12050.94	4618.0
2020-07-05 21:00:00	NQ	Futures	12051.23	12115.71	12051.23	12102.7	10920.0
2020-07-05 22:00:00	NQ	Futures	12102.99	12129.59	12102.41	12118.32	5361.0
2020-07-05 23:00:00	NQ	Futures	12119.18	12145.5	12110.22	12135.09	4389.0
2020-07-05 18:00:00	YM	Futures	28287.2	28432.5	28251.9	28406.1	2456.0
2020-07-05 19:00:00	YM	Futures	28405.0	28460.1	28370.9	28436.9	1982.0
2020-07-05 20:00:00	YM	Futures	28438.0	28496.4	28429.2	28495.3	2278.0
2020-07-05 21:00:00	YM	Futures	28495.3	28642.9	28495.3	28604.3	5886.0
2020-07-05 22:00:00	YM	Futures	28608.7	28670.4	28596.6	28651.7	3523.0
2020-07-05 23:00:00	YM	Futures	28652.8	28773.9	28630.7	28749.7	4265.0
2020-07-05 18:00:00	CL	Futures	28.28	28.43	28.2	28.4	2415.0
2020-07-05 19:00:00	CL	Futures	28.4	28.42	28.28	28.33	1909.0
2020-07-05 20:00:00	CL	Futures	28.33	28.38	28.26	28.33	1698.0
2020-07-05 21:00:00	CL	Futures	28.33	28.38	28.24	28.33	3848.0
2020-07-05 22:00:00	CL	Futures	28.33	28.37	28.28	28.34	1958.0
2020-07-05 23:00:00	CL	Futures	28.34	28.44	28.31	28.42	2487.0
2020-07-05 18:00:00	GC	Futures	2206.1	2208.3	2204.0	2206.4	1352.0
2020-07-05 19:00:00	GC	Futures	2206.6	2206.8	2205.2	2205.4	959.0
2020-07-05 20:00:00	GC	Futures	2205.5	2207.3	2204.8	2206.0	1711.0
2020-07-05 21:00:00	GC	Futures	2206.0	2206.8	2198.2	2199.8	6038.0
2020-07-05 22:00:00	GC	Futures	2199.8	2201.0	2197.0	2200.4	4428.0
2020-07-05 23:00:00	GC	Futures	2200.4	2201.2	2197.2	2197.5	2247.0
2020-07-05 18:00:00	ZN	Futures	138.804926	138.804926	138.695839	138.727007	6727.0
2020-07-05 19:00:00	ZN	Futures	138.727007	138.758174	138.695839	138.711423	8550.0
2020-07-05 20:00:00	ZN	Futures	138.711423	138.711423	138.633504	138.633504	16635.0
2020-07-05 21:00:00	ZN	Futures	138.61792	138.633504	138.540001	138.586753	25762.0
2020-07-05 22:00:00	ZN	Futures	138.571169	138.61792	138.571169	138.602336	9369.0
2020-07-05 23:00:00	ZN	Futures	138.586753	138.602336	138.555585	138.571169	6276.0

> showing 36 of 358 rows — these rows as CSV

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