PREVIEW / futures_1hour / 2020-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-25.parquet
  size:    18 KB
  rows:    364

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-25 18:00:00	ES	Futures	3860.54	3861.1	3837.29	3844.58	23462.0
2020-10-25 19:00:00	ES	Futures	3844.86	3854.94	3844.58	3853.26	9207.0
2020-10-25 20:00:00	ES	Futures	3853.26	3856.34	3849.34	3852.98	15911.0
2020-10-25 21:00:00	ES	Futures	3853.26	3856.34	3844.3	3846.54	14868.0
2020-10-25 22:00:00	ES	Futures	3846.82	3849.62	3844.86	3846.26	4813.0
2020-10-25 23:00:00	ES	Futures	3845.98	3849.06	3842.34	3846.26	10038.0
2020-10-25 18:00:00	NQ	Futures	13470.72	13477.66	13399.51	13429.61	9653.0
2020-10-25 19:00:00	NQ	Futures	13429.32	13471.0	13429.03	13462.9	4503.0
2020-10-25 20:00:00	NQ	Futures	13462.03	13476.22	13451.9	13461.74	6402.0
2020-10-25 21:00:00	NQ	Futures	13462.61	13473.9	13437.14	13450.16	7326.0
2020-10-25 22:00:00	NQ	Futures	13449.58	13463.48	13442.93	13451.32	3070.0
2020-10-25 23:00:00	NQ	Futures	13451.9	13464.64	13441.19	13454.22	4708.0
2020-10-25 18:00:00	YM	Futures	31123.2	31123.2	30939.7	30990.5	3825.0
2020-10-25 19:00:00	YM	Futures	30991.6	31080.1	30988.3	31064.6	1574.0
2020-10-25 20:00:00	YM	Futures	31063.5	31084.5	31030.3	31065.7	2268.0
2020-10-25 21:00:00	YM	Futures	31066.8	31093.3	30986.1	31008.2	3359.0
2020-10-25 22:00:00	YM	Futures	31007.1	31031.4	30990.5	30998.3	1283.0
2020-10-25 23:00:00	YM	Futures	30998.3	31017.0	30966.2	30999.4	1959.0
2020-10-25 18:00:00	CL	Futures	27.16	27.2	26.57	26.67	10014.0
2020-10-25 19:00:00	CL	Futures	26.67	26.86	26.64	26.83	2737.0
2020-10-25 20:00:00	CL	Futures	26.84	26.94	26.82	26.89	4034.0
2020-10-25 21:00:00	CL	Futures	26.89	26.94	26.78	26.81	5057.0
2020-10-25 22:00:00	CL	Futures	26.81	26.89	26.79	26.83	2491.0
2020-10-25 23:00:00	CL	Futures	26.83	26.84	26.76	26.79	1828.0
2020-10-25 18:00:00	GC	Futures	2318.0	2318.4	2301.6	2304.3	5586.0
2020-10-25 19:00:00	GC	Futures	2304.3	2312.2	2304.3	2311.3	2879.0
2020-10-25 20:00:00	GC	Futures	2311.3	2314.0	2310.0	2312.9	2564.0
2020-10-25 21:00:00	GC	Futures	2312.9	2315.6	2307.8	2309.4	6784.0
2020-10-25 22:00:00	GC	Futures	2309.3	2313.5	2308.5	2311.0	3934.0
2020-10-25 23:00:00	GC	Futures	2310.8	2312.0	2308.0	2310.0	3530.0
2020-10-25 18:00:00	ZN	Futures	138.164871	138.274105	138.164871	138.2585	21276.0
2020-10-25 19:00:00	ZN	Futures	138.2585	138.28971	138.22729	138.274105	10001.0
2020-10-25 20:00:00	ZN	Futures	138.274105	138.28971	138.242895	138.274105	16854.0
2020-10-25 21:00:00	ZN	Futures	138.274105	138.352129	138.274105	138.336524	30292.0
2020-10-25 22:00:00	ZN	Futures	138.336524	138.352129	138.305314	138.336524	12856.0
2020-10-25 23:00:00	ZN	Futures	138.336524	138.352129	138.320919	138.352129	16800.0

> showing 36 of 364 rows — these rows as CSV

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