PREVIEW / futures_1hour / 2020-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-04.parquet
  size:    17 KB
  rows:    366

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-04 18:00:00	ES	Futures	3764.47	3765.87	3752.71	3760.55	22796.0
2020-10-04 19:00:00	ES	Futures	3760.83	3768.67	3758.31	3766.71	8439.0
2020-10-04 20:00:00	ES	Futures	3766.43	3772.59	3763.63	3772.59	13226.0
2020-10-04 21:00:00	ES	Futures	3772.31	3773.15	3763.91	3765.87	9471.0
2020-10-04 22:00:00	ES	Futures	3765.87	3769.79	3765.03	3768.95	4580.0
2020-10-04 23:00:00	ES	Futures	3768.95	3772.31	3761.39	3761.67	6338.0
2020-10-04 18:00:00	NQ	Futures	13093.83	13112.93	13061.12	13092.96	11187.0
2020-10-04 19:00:00	NQ	Futures	13091.8	13126.83	13086.01	13120.17	4462.0
2020-10-04 20:00:00	NQ	Futures	13121.62	13156.06	13110.62	13154.91	7953.0
2020-10-04 21:00:00	NQ	Futures	13154.33	13157.8	13120.75	13129.43	5802.0
2020-10-04 22:00:00	NQ	Futures	13130.01	13148.54	13125.09	13142.46	2766.0
2020-10-04 23:00:00	NQ	Futures	13142.75	13160.12	13110.62	13112.06	4582.0
2020-10-04 18:00:00	YM	Futures	30669.9	30669.9	30566.0	30637.8	3549.0
2020-10-04 19:00:00	YM	Futures	30638.9	30705.3	30614.6	30684.3	2377.0
2020-10-04 20:00:00	YM	Futures	30685.4	30732.9	30662.1	30730.7	3899.0
2020-10-04 21:00:00	YM	Futures	30729.6	30738.4	30656.6	30674.3	3849.0
2020-10-04 22:00:00	YM	Futures	30674.3	30710.8	30667.7	30703.1	2134.0
2020-10-04 23:00:00	YM	Futures	30707.5	30758.3	30654.4	30657.7	2616.0
2020-10-04 18:00:00	CL	Futures	25.5	25.68	25.5	25.62	4314.0
2020-10-04 19:00:00	CL	Futures	25.62	25.74	25.61	25.72	1859.0
2020-10-04 20:00:00	CL	Futures	25.71	26.03	25.69	26.03	6317.0
2020-10-04 21:00:00	CL	Futures	26.03	26.06	25.92	25.98	3367.0
2020-10-04 22:00:00	CL	Futures	25.98	26.12	25.97	26.04	4473.0
2020-10-04 23:00:00	CL	Futures	26.04	26.23	26.04	26.19	4736.0
2020-10-04 18:00:00	GC	Futures	2324.0	2324.0	2313.9	2316.9	4002.0
2020-10-04 19:00:00	GC	Futures	2317.0	2322.4	2316.1	2320.4	2066.0
2020-10-04 20:00:00	GC	Futures	2320.6	2320.8	2315.2	2318.3	2928.0
2020-10-04 21:00:00	GC	Futures	2318.0	2318.6	2314.4	2318.3	2774.0
2020-10-04 22:00:00	GC	Futures	2318.0	2318.6	2314.0	2315.8	2879.0
2020-10-04 23:00:00	GC	Futures	2315.8	2315.8	2306.5	2307.4	6234.0
2020-10-04 18:00:00	ZN	Futures	139.194788	139.241602	139.163578	139.194788	15803.0
2020-10-04 19:00:00	ZN	Futures	139.194788	139.225997	139.163578	139.194788	11144.0
2020-10-04 20:00:00	ZN	Futures	139.194788	139.210393	139.132369	139.147974	23778.0
2020-10-04 21:00:00	ZN	Futures	139.163578	139.194788	139.147974	139.194788	9663.0
2020-10-04 22:00:00	ZN	Futures	139.194788	139.194788	139.163578	139.179183	4461.0
2020-10-04 23:00:00	ZN	Futures	139.179183	139.210393	139.163578	139.194788	6735.0

> showing 36 of 366 rows — these rows as CSV

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