PREVIEW / futures_1hour / 2020-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-20.parquet
  size:    17 KB
  rows:    362

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-09-20 18:00:00	ES	Futures	3713.49	3715.17	3692.77	3707.89	29666.0
2020-09-20 19:00:00	ES	Futures	3708.17	3720.22	3705.65	3713.49	11440.0
2020-09-20 20:00:00	ES	Futures	3713.21	3723.02	3711.25	3720.22	9748.0
2020-09-20 21:00:00	ES	Futures	3720.5	3726.66	3708.73	3710.69	17328.0
2020-09-20 22:00:00	ES	Futures	3710.69	3720.22	3709.29	3715.17	11947.0
2020-09-20 23:00:00	ES	Futures	3715.45	3716.29	3703.97	3707.33	10967.0
2020-09-20 18:00:00	NQ	Futures	12643.99	12666.57	12565.55	12636.18	11158.0
2020-09-20 19:00:00	NQ	Futures	12637.05	12697.26	12630.39	12657.31	5593.0
2020-09-20 20:00:00	NQ	Futures	12656.73	12696.97	12643.12	12685.68	4969.0
2020-09-20 21:00:00	NQ	Futures	12687.41	12725.33	12641.39	12653.26	7513.0
2020-09-20 22:00:00	NQ	Futures	12653.26	12689.73	12650.07	12664.55	4905.0
2020-09-20 23:00:00	NQ	Futures	12665.7	12668.89	12614.47	12630.97	5743.0
2020-09-20 18:00:00	YM	Futures	30479.7	30508.5	30338.2	30449.9	4703.0
2020-09-20 19:00:00	YM	Futures	30452.1	30536.1	30425.5	30486.3	2246.0
2020-09-20 20:00:00	YM	Futures	30485.2	30558.2	30473.1	30539.4	1760.0
2020-09-20 21:00:00	YM	Futures	30541.6	30584.7	30446.5	30458.7	3149.0
2020-09-20 22:00:00	YM	Futures	30459.8	30533.9	30452.1	30499.6	1918.0
2020-09-20 23:00:00	YM	Futures	30500.7	30505.1	30417.8	30443.2	2300.0
2020-09-20 18:00:00	CL	Futures	28.39	28.39	28.11	28.21	3535.0
2020-09-20 19:00:00	CL	Futures	28.22	28.38	28.22	28.29	1979.0
2020-09-20 20:00:00	CL	Futures	28.29	28.34	28.23	28.3	2179.0
2020-09-20 21:00:00	CL	Futures	28.29	28.53	28.24	28.41	5628.0
2020-09-20 22:00:00	CL	Futures	28.42	28.6	28.41	28.51	3345.0
2020-09-20 23:00:00	CL	Futures	28.51	28.56	28.46	28.52	2299.0
2020-09-20 18:00:00	GC	Futures	2380.4	2381.6	2366.0	2379.5	4397.0
2020-09-20 19:00:00	GC	Futures	2379.5	2380.9	2377.4	2377.8	1560.0
2020-09-20 20:00:00	GC	Futures	2377.7	2382.3	2375.9	2381.2	3150.0
2020-09-20 21:00:00	GC	Futures	2381.1	2387.2	2380.5	2380.9	6543.0
2020-09-20 22:00:00	GC	Futures	2380.9	2384.8	2380.9	2382.7	2353.0
2020-09-20 23:00:00	GC	Futures	2382.8	2385.9	2381.5	2383.9	2489.0
2020-09-20 18:00:00	ZN	Futures	139.210393	139.257207	139.194788	139.241602	11545.0
2020-09-20 19:00:00	ZN	Futures	139.241602	139.241602	139.194788	139.210393	4211.0
2020-09-20 20:00:00	ZN	Futures	139.210393	139.225997	139.194788	139.210393	3761.0
2020-09-20 21:00:00	ZN	Futures	139.225997	139.257207	139.210393	139.257207	4759.0
2020-09-20 22:00:00	ZN	Futures	139.241602	139.257207	139.225997	139.241602	5104.0
2020-09-20 23:00:00	ZN	Futures	139.241602	139.272812	139.241602	139.257207	3761.0

> showing 36 of 362 rows — these rows as CSV

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