PREVIEW / futures_1hour / 2020-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-15.parquet
  size:    18 KB
  rows:    397

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-11-15 18:00:00	ES	Futures	4018.8	4045.4	4018.24	4042.32	22261.0
2020-11-15 19:00:00	ES	Futures	4042.32	4043.16	4035.04	4040.08	11051.0
2020-11-15 20:00:00	ES	Futures	4039.8	4045.68	4035.88	4038.96	13250.0
2020-11-15 21:00:00	ES	Futures	4039.24	4045.68	4039.24	4042.04	10599.0
2020-11-15 22:00:00	ES	Futures	4041.76	4045.68	4040.92	4044.0	5414.0
2020-11-15 23:00:00	ES	Futures	4044.0	4045.4	4042.32	4045.12	3623.0
2020-11-15 18:00:00	NQ	Futures	13845.0	13969.76	13845.0	13948.63	10404.0
2020-11-15 19:00:00	NQ	Futures	13948.92	13952.39	13930.1	13939.65	3951.0
2020-11-15 20:00:00	NQ	Futures	13938.79	13950.94	13908.97	13921.42	4525.0
2020-11-15 21:00:00	NQ	Futures	13921.42	13964.26	13919.68	13943.71	5880.0
2020-11-15 22:00:00	NQ	Futures	13944.29	13953.55	13926.34	13938.5	3757.0
2020-11-15 23:00:00	NQ	Futures	13938.79	13949.21	13932.13	13947.18	1860.0
2020-11-15 18:00:00	YM	Futures	32543.9	32770.6	32543.9	32734.1	4422.0
2020-11-15 19:00:00	YM	Futures	32731.9	32742.9	32677.7	32734.1	2280.0
2020-11-15 20:00:00	YM	Futures	32733.0	32779.4	32706.4	32727.4	2894.0
2020-11-15 21:00:00	YM	Futures	32728.5	32783.8	32728.5	32751.8	2618.0
2020-11-15 22:00:00	YM	Futures	32750.7	32770.6	32745.1	32760.6	1533.0
2020-11-15 23:00:00	YM	Futures	32761.7	32783.8	32749.6	32781.6	1018.0
2020-11-15 18:00:00	CL	Futures	27.48	27.72	27.46	27.68	1314.0
2020-11-15 19:00:00	CL	Futures	27.68	27.74	27.64	27.73	1070.0
2020-11-15 20:00:00	CL	Futures	27.73	27.79	27.63	27.71	1594.0
2020-11-15 21:00:00	CL	Futures	27.73	27.82	27.72	27.78	1270.0
2020-11-15 22:00:00	CL	Futures	27.79	27.86	27.77	27.81	863.0
2020-11-15 23:00:00	CL	Futures	27.81	27.85	27.76	27.84	481.0
2020-11-15 18:00:00	GC	Futures	2294.4	2298.8	2293.1	2297.1	2381.0
2020-11-15 19:00:00	GC	Futures	2297.2	2297.9	2295.0	2296.1	2229.0
2020-11-15 20:00:00	GC	Futures	2296.2	2306.7	2293.9	2304.3	8144.0
2020-11-15 21:00:00	GC	Futures	2304.5	2308.3	2302.2	2302.8	4701.0
2020-11-15 22:00:00	GC	Futures	2302.9	2306.2	2301.8	2303.1	2966.0
2020-11-15 23:00:00	GC	Futures	2302.9	2305.1	2302.0	2303.8	1965.0
2020-11-15 18:00:00	ZN	Futures	137.89959	137.915195	137.837171	137.883985	17881.0
2020-11-15 19:00:00	ZN	Futures	137.883985	137.89959	137.86838	137.89959	4693.0
2020-11-15 20:00:00	ZN	Futures	137.89959	137.946404	137.883985	137.946404	12653.0
2020-11-15 21:00:00	ZN	Futures	137.946404	137.977614	137.915195	137.946404	10128.0
2020-11-15 22:00:00	ZN	Futures	137.962009	137.977614	137.930799	137.946404	6793.0
2020-11-15 23:00:00	ZN	Futures	137.962009	137.962009	137.930799	137.946404	1582.0

> showing 36 of 397 rows — these rows as CSV

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