PREVIEW / futures_1hour / 2020-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-26.parquet
  size:    17 KB
  rows:    357

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-26 18:00:00	ES	Futures	3586.32	3589.4	3571.52	3573.2	21882.0
2020-07-26 19:00:00	ES	Futures	3573.48	3578.23	3565.38	3573.76	20935.0
2020-07-26 20:00:00	ES	Futures	3573.48	3593.31	3572.08	3588.0	25497.0
2020-07-26 21:00:00	ES	Futures	3588.28	3595.82	3585.49	3593.03	18177.0
2020-07-26 22:00:00	ES	Futures	3593.31	3600.29	3586.32	3598.61	15380.0
2020-07-26 23:00:00	ES	Futures	3598.61	3600.85	3593.86	3596.66	10717.0
2020-07-26 18:00:00	NQ	Futures	12133.93	12165.74	12064.82	12080.43	9835.0
2020-07-26 19:00:00	NQ	Futures	12081.01	12092.29	12030.98	12076.38	6640.0
2020-07-26 20:00:00	NQ	Futures	12076.38	12157.07	12068.29	12132.77	5952.0
2020-07-26 21:00:00	NQ	Futures	12133.93	12165.45	12127.28	12142.61	5948.0
2020-07-26 22:00:00	NQ	Futures	12142.61	12195.53	12113.4	12183.38	6554.0
2020-07-26 23:00:00	NQ	Futures	12183.96	12190.9	12161.98	12179.62	4416.0
2020-07-26 18:00:00	YM	Futures	28932.5	29038.2	28917.0	28944.6	5292.0
2020-07-26 19:00:00	YM	Futures	28947.9	29009.5	28885.1	28965.5	4825.0
2020-07-26 20:00:00	YM	Futures	28966.6	29121.8	28944.6	29072.3	4835.0
2020-07-26 21:00:00	YM	Futures	29075.6	29138.4	29054.7	29113.0	3900.0
2020-07-26 22:00:00	YM	Futures	29115.2	29175.8	29063.5	29158.2	2513.0
2020-07-26 23:00:00	YM	Futures	29160.4	29179.1	29114.1	29130.7	1915.0
2020-07-26 18:00:00	CL	Futures	28.78	28.86	28.55	28.58	4182.0
2020-07-26 19:00:00	CL	Futures	28.58	28.73	28.53	28.66	2326.0
2020-07-26 20:00:00	CL	Futures	28.66	28.82	28.64	28.79	2842.0
2020-07-26 21:00:00	CL	Futures	28.79	28.87	28.71	28.73	3407.0
2020-07-26 22:00:00	CL	Futures	28.73	28.78	28.66	28.73	2866.0
2020-07-26 23:00:00	CL	Futures	28.73	28.8	28.71	28.75	2245.0
2020-07-26 18:00:00	GC	Futures	2346.0	2356.3	2343.3	2350.8	1314.0
2020-07-26 19:00:00	GC	Futures	2350.4	2359.6	2349.9	2358.1	917.0
2020-07-26 20:00:00	GC	Futures	2357.4	2363.9	2356.6	2360.3	1125.0
2020-07-26 21:00:00	GC	Futures	2360.5	2367.6	2358.4	2364.8	1727.0
2020-07-26 22:00:00	GC	Futures	2364.8	2377.6	2363.4	2375.2	2959.0
2020-07-26 23:00:00	GC	Futures	2375.4	2391.6	2374.8	2378.1	4599.0
2020-07-26 18:00:00	ZN	Futures	139.194521	139.241272	139.178937	139.210105	10916.0
2020-07-26 19:00:00	ZN	Futures	139.194521	139.210105	139.163353	139.194521	8075.0
2020-07-26 20:00:00	ZN	Futures	139.210105	139.225688	139.178937	139.178937	16168.0
2020-07-26 21:00:00	ZN	Futures	139.178937	139.225688	139.178937	139.210105	6399.0
2020-07-26 22:00:00	ZN	Futures	139.210105	139.256856	139.210105	139.241272	7087.0
2020-07-26 23:00:00	ZN	Futures	139.241272	139.256856	139.225688	139.241272	5465.0

> showing 36 of 357 rows — these rows as CSV

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