PREVIEW / futures_1hour / 2020-01-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-01.parquet
  size:    16 KB
  rows:    335

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-01 18:00:00	ES	Futures	3508.8	3512.8	3505.8	3509.3	16226.0
2020-01-01 19:00:00	ES	Futures	3509.6	3511.2	3508.8	3510.7	5278.0
2020-01-01 20:00:00	ES	Futures	3510.9	3512.6	3507.7	3510.4	11144.0
2020-01-01 21:00:00	ES	Futures	3510.4	3512.0	3509.9	3511.5	5074.0
2020-01-01 22:00:00	ES	Futures	3511.2	3513.1	3511.2	3512.8	3562.0
2020-01-01 23:00:00	ES	Futures	3512.6	3512.8	3511.5	3512.0	1869.0
2020-01-01 18:00:00	NQ	Futures	10152.01	10160.1	10143.62	10151.72	5839.0
2020-01-01 19:00:00	NQ	Futures	10151.72	10159.24	10149.98	10157.79	2182.0
2020-01-01 20:00:00	NQ	Futures	10158.08	10163.86	10147.09	10157.79	5044.0
2020-01-01 21:00:00	NQ	Futures	10157.79	10163.86	10155.77	10162.13	2814.0
2020-01-01 22:00:00	NQ	Futures	10162.13	10169.65	10162.13	10168.49	2162.0
2020-01-01 23:00:00	NQ	Futures	10168.49	10168.49	10163.86	10164.73	979.0
2020-01-01 18:00:00	YM	Futures	31086.9	31127.1	31070.5	31104.3	2738.0
2020-01-01 19:00:00	YM	Futures	31103.2	31119.5	31098.8	31115.2	864.0
2020-01-01 20:00:00	YM	Futures	31116.3	31133.7	31093.4	31118.4	2159.0
2020-01-01 21:00:00	YM	Futures	31118.4	31132.6	31114.1	31125.0	1176.0
2020-01-01 22:00:00	YM	Futures	31126.1	31142.4	31126.1	31140.2	1154.0
2020-01-01 23:00:00	YM	Futures	31140.2	31140.2	31129.3	31131.5	501.0
2020-01-01 18:00:00	CL	Futures	54.58	54.58	54.33	54.34	4611.0
2020-01-01 19:00:00	CL	Futures	54.34	54.38	54.31	54.38	1543.0
2020-01-01 20:00:00	CL	Futures	54.38	54.43	54.28	54.32	5295.0
2020-01-01 21:00:00	CL	Futures	54.32	54.35	54.31	54.32	2106.0
2020-01-01 22:00:00	CL	Futures	54.32	54.33	54.25	54.27	2757.0
2020-01-01 23:00:00	CL	Futures	54.27	54.28	54.25	54.25	984.0
2020-01-01 18:00:00	GC	Futures	1917.7	1921.5	1917.1	1917.7	5291.0
2020-01-01 19:00:00	GC	Futures	1917.6	1918.8	1917.2	1918.0	3547.0
2020-01-01 20:00:00	GC	Futures	1917.8	1920.7	1916.1	1919.0	9320.0
2020-01-01 21:00:00	GC	Futures	1918.8	1920.7	1917.6	1920.4	4851.0
2020-01-01 22:00:00	GC	Futures	1920.4	1921.1	1919.4	1920.1	3116.0
2020-01-01 23:00:00	GC	Futures	1920.1	1920.1	1918.8	1918.8	1343.0
2020-01-01 18:00:00	ZN	Futures	128.450101	128.481388	128.40317	128.434457	12956.0
2020-01-01 19:00:00	ZN	Futures	128.434457	128.465745	128.418814	128.450101	3291.0
2020-01-01 20:00:00	ZN	Futures	128.450101	128.528319	128.450101	128.512676	7824.0
2020-01-01 21:00:00	ZN	Futures	128.512676	128.512676	128.481388	128.481388	2505.0
2020-01-01 22:00:00	ZN	Futures	128.481388	128.512676	128.465745	128.497032	3256.0
2020-01-01 23:00:00	ZN	Futures	128.497032	128.512676	128.481388	128.512676	3536.0

> showing 36 of 335 rows — these rows as CSV

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