PREVIEW / futures_1hour / 2020-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-02.parquet
  size:    18 KB
  rows:    386

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-02-02 18:00:00	ES	Futures	3493.3	3508.0	3492.5	3503.4	53208.0
2020-02-02 19:00:00	ES	Futures	3503.4	3516.9	3500.9	3510.7	36614.0
2020-02-02 20:00:00	ES	Futures	3510.7	3521.8	3505.5	3521.2	64892.0
2020-02-02 21:00:00	ES	Futures	3521.0	3523.4	3512.6	3513.4	32038.0
2020-02-02 22:00:00	ES	Futures	3513.4	3519.6	3512.0	3517.7	20424.0
2020-02-02 23:00:00	ES	Futures	3518.0	3519.1	3515.0	3517.5	9057.0
2020-02-02 18:00:00	NQ	Futures	10390.28	10454.48	10381.32	10434.24	19930.0
2020-02-02 19:00:00	NQ	Futures	10433.37	10486.0	10423.25	10462.29	14975.0
2020-02-02 20:00:00	NQ	Futures	10462.0	10502.19	10442.63	10499.88	23483.0
2020-02-02 21:00:00	NQ	Futures	10499.88	10516.94	10471.54	10474.43	15050.0
2020-02-02 22:00:00	NQ	Futures	10474.72	10500.75	10470.1	10494.97	8305.0
2020-02-02 23:00:00	NQ	Futures	10495.54	10499.59	10484.56	10492.94	3903.0
2020-02-02 18:00:00	YM	Futures	30657.9	30794.0	30632.9	30765.7	8144.0
2020-02-02 19:00:00	YM	Futures	30763.5	30887.6	30737.4	30841.9	7337.0
2020-02-02 20:00:00	YM	Futures	30841.9	30944.2	30794.0	30937.7	14203.0
2020-02-02 21:00:00	YM	Futures	30936.6	30955.1	30848.4	30856.0	6491.0
2020-02-02 22:00:00	YM	Futures	30856.0	30908.3	30839.7	30887.6	4394.0
2020-02-02 23:00:00	YM	Futures	30892.0	30900.7	30864.8	30892.0	2194.0
2020-02-02 18:00:00	CL	Futures	45.19	45.42	44.67	45.23	14913.0
2020-02-02 19:00:00	CL	Futures	45.23	45.39	44.82	45.32	16576.0
2020-02-02 20:00:00	CL	Futures	45.31	45.7	45.18	45.7	25546.0
2020-02-02 21:00:00	CL	Futures	45.7	45.7	45.39	45.42	9084.0
2020-02-02 22:00:00	CL	Futures	45.41	45.61	45.36	45.57	7985.0
2020-02-02 23:00:00	CL	Futures	45.57	45.66	45.46	45.63	4931.0
2020-02-02 18:00:00	GC	Futures	1995.7	1996.6	1988.5	1990.9	12266.0
2020-02-02 19:00:00	GC	Futures	1990.9	1991.6	1984.0	1986.9	8973.0
2020-02-02 20:00:00	GC	Futures	1987.0	1989.1	1981.4	1982.0	23368.0
2020-02-02 21:00:00	GC	Futures	1981.9	1984.1	1980.8	1982.6	10850.0
2020-02-02 22:00:00	GC	Futures	1982.8	1983.6	1977.5	1979.6	9069.0
2020-02-02 23:00:00	GC	Futures	1979.5	1981.0	1978.6	1980.3	3007.0
2020-02-02 18:00:00	ZN	Futures	132.016856	132.063787	131.782201	131.876063	46012.0
2020-02-02 19:00:00	ZN	Futures	131.860419	131.891706	131.688339	131.719626	43989.0
2020-02-02 20:00:00	ZN	Futures	131.73527	131.829132	131.657051	131.688339	66352.0
2020-02-02 21:00:00	ZN	Futures	131.703982	131.813488	131.688339	131.797844	28352.0
2020-02-02 22:00:00	ZN	Futures	131.797844	131.844775	131.73527	131.73527	20783.0
2020-02-02 23:00:00	ZN	Futures	131.750913	131.797844	131.73527	131.766557	7809.0

> showing 36 of 386 rows — these rows as CSV

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