PREVIEW / futures_1hour / 2020-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-05.parquet
  size:    18 KB
  rows:    377

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-01-05 18:00:00	ES	Futures	3490.6	3494.7	3486.3	3494.4	36078.0
2020-01-05 19:00:00	ES	Futures	3494.4	3496.0	3490.9	3493.6	22508.0
2020-01-05 20:00:00	ES	Futures	3493.6	3493.6	3489.3	3490.6	17575.0
2020-01-05 21:00:00	ES	Futures	3490.4	3493.1	3489.5	3490.9	12099.0
2020-01-05 22:00:00	ES	Futures	3490.9	3496.6	3490.9	3495.8	10485.0
2020-01-05 23:00:00	ES	Futures	3496.0	3501.2	3495.0	3499.6	13516.0
2020-01-05 18:00:00	NQ	Futures	10146.8	10154.9	10118.46	10152.87	13962.0
2020-01-05 19:00:00	NQ	Futures	10153.45	10160.39	10142.46	10148.83	10576.0
2020-01-05 20:00:00	NQ	Futures	10149.4	10150.27	10132.63	10136.39	7644.0
2020-01-05 21:00:00	NQ	Futures	10136.1	10145.36	10132.63	10137.55	5537.0
2020-01-05 22:00:00	NQ	Futures	10137.26	10157.79	10137.26	10154.61	4636.0
2020-01-05 23:00:00	NQ	Futures	10154.9	10173.12	10151.14	10165.02	5982.0
2020-01-05 18:00:00	YM	Futures	31022.6	31033.5	30970.4	31028.1	6855.0
2020-01-05 19:00:00	YM	Futures	31029.2	31039.0	30998.7	31019.4	4863.0
2020-01-05 20:00:00	YM	Futures	31019.4	31021.5	30986.7	30992.1	3706.0
2020-01-05 21:00:00	YM	Futures	30992.1	31015.0	30987.8	30999.8	2305.0
2020-01-05 22:00:00	YM	Futures	30999.8	31033.5	30999.8	31027.0	2257.0
2020-01-05 23:00:00	YM	Futures	31027.0	31072.7	31020.4	31060.7	2610.0
2020-01-05 18:00:00	CL	Futures	56.45	56.95	56.35	56.58	19122.0
2020-01-05 19:00:00	CL	Futures	56.58	56.66	56.49	56.6	6754.0
2020-01-05 20:00:00	CL	Futures	56.6	57.08	56.53	57.07	21408.0
2020-01-05 21:00:00	CL	Futures	57.07	57.1	56.93	57.03	9366.0
2020-01-05 22:00:00	CL	Futures	57.03	57.35	57.03	57.21	15267.0
2020-01-05 23:00:00	CL	Futures	57.22	57.24	57.13	57.21	5777.0
2020-01-05 18:00:00	GC	Futures	1970.3	2005.8	1969.8	1981.5	42728.0
2020-01-05 19:00:00	GC	Futures	1981.4	1983.8	1978.9	1981.9	18278.0
2020-01-05 20:00:00	GC	Futures	1981.9	1995.3	1980.9	1992.4	38054.0
2020-01-05 21:00:00	GC	Futures	1992.4	1992.7	1989.1	1992.1	12203.0
2020-01-05 22:00:00	GC	Futures	1992.0	1994.5	1991.2	1992.7	8488.0
2020-01-05 23:00:00	GC	Futures	1992.7	1993.0	1988.6	1990.1	9334.0
2020-01-05 18:00:00	ZN	Futures	129.654663	129.795456	129.654663	129.717238	49697.0
2020-01-05 19:00:00	ZN	Futures	129.717238	129.717238	129.623376	129.654663	29850.0
2020-01-05 20:00:00	ZN	Futures	129.654663	129.811099	129.654663	129.779812	36375.0
2020-01-05 21:00:00	ZN	Futures	129.779812	129.779812	129.701594	129.701594	15934.0
2020-01-05 22:00:00	ZN	Futures	129.701594	129.717238	129.654663	129.68595	14990.0
2020-01-05 23:00:00	ZN	Futures	129.670307	129.701594	129.654663	129.68595	9424.0

> showing 36 of 377 rows — these rows as CSV

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