PREVIEW / futures_1hour / 2020-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-15.parquet
  size:    17 KB
  rows:    356

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-03-15 18:00:00	ES	Futures	2888.48	2908.79	2805.06	2805.06	51401.0
2020-03-15 19:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	873.0
2020-03-15 20:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	2171.0
2020-03-15 21:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	871.0
2020-03-15 22:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	89.0
2020-03-15 23:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	2746.0
2020-03-15 18:00:00	NQ	Futures	9048.81	9049.1	8616.06	8616.06	6338.0
2020-03-15 19:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	31.0
2020-03-15 20:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	12.0
2020-03-15 21:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	246.0
2020-03-15 22:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	85.0
2020-03-15 23:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	31.0
2020-03-15 18:00:00	YM	Futures	24869.2	24872.5	23875.7	23875.7	3375.0
2020-03-15 19:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	19.0
2020-03-15 20:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	21.0
2020-03-15 21:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	83.0
2020-03-15 22:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	11.0
2020-03-15 23:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	8.0
2020-03-15 18:00:00	CL	Futures	29.04	30.02	27.09	27.21	7163.0
2020-03-15 19:00:00	CL	Futures	27.2	27.53	26.76	27.37	3920.0
2020-03-15 20:00:00	CL	Futures	27.37	28.18	27.33	27.84	5782.0
2020-03-15 21:00:00	CL	Futures	27.82	28.23	27.61	28.13	4757.0
2020-03-15 22:00:00	CL	Futures	28.13	28.34	27.83	28.07	2919.0
2020-03-15 23:00:00	CL	Futures	28.05	28.14	27.86	28.06	960.0
2020-03-15 18:00:00	GC	Futures	1953.3	1967.0	1923.3	1930.8	25931.0
2020-03-15 19:00:00	GC	Futures	1930.5	1952.7	1924.8	1945.4	11723.0
2020-03-15 20:00:00	GC	Futures	1945.4	1949.5	1925.0	1933.4	11480.0
2020-03-15 21:00:00	GC	Futures	1933.7	1935.4	1902.7	1916.3	19357.0
2020-03-15 22:00:00	GC	Futures	1916.6	1934.2	1911.4	1931.3	13338.0
2020-03-15 23:00:00	GC	Futures	1931.3	1934.8	1926.8	1933.4	8532.0
2020-03-15 18:00:00	ZN	Futures	137.462485	137.478019	135.83139	137.369279	78660.0
2020-03-15 19:00:00	ZN	Futures	137.369279	138.006183	137.229471	137.990649	44486.0
2020-03-15 20:00:00	ZN	Futures	137.990649	138.145991	137.353745	137.524622	46636.0
2020-03-15 21:00:00	ZN	Futures	137.540156	138.052786	137.540156	137.95958	23133.0
2020-03-15 22:00:00	ZN	Futures	137.95958	137.975115	137.757635	137.77317	13410.0
2020-03-15 23:00:00	ZN	Futures	137.77317	137.835306	137.726567	137.757635	7997.0

> showing 36 of 356 rows — these rows as CSV

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