PREVIEW / futures_1hour / 2020-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-26.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-01-26 18:00:00	ES	Futures	3544.3	3544.3	3525.3	3532.4	93971.0
2020-01-26 19:00:00	ES	Futures	3532.4	3543.2	3531.0	3542.9	47889.0
2020-01-26 20:00:00	ES	Futures	3543.2	3543.5	3538.3	3540.5	19670.0
2020-01-26 21:00:00	ES	Futures	3540.5	3540.8	3531.3	3533.2	23067.0
2020-01-26 22:00:00	ES	Futures	3533.2	3540.2	3533.2	3538.6	12216.0
2020-01-26 23:00:00	ES	Futures	3538.6	3539.4	3535.6	3536.2	6619.0
2020-01-26 18:00:00	NQ	Futures	10499.3	10499.3	10403.3	10427.01	33772.0
2020-01-26 19:00:00	NQ	Futures	10427.59	10463.45	10424.41	10462.58	18818.0
2020-01-26 20:00:00	NQ	Futures	10462.58	10463.45	10443.49	10454.77	9217.0
2020-01-26 21:00:00	NQ	Futures	10455.35	10455.35	10415.73	10427.3	16832.0
2020-01-26 22:00:00	NQ	Futures	10427.59	10458.82	10427.59	10449.28	9570.0
2020-01-26 23:00:00	NQ	Futures	10449.28	10456.22	10442.63	10444.07	4144.0
2020-01-26 18:00:00	YM	Futures	31268.7	31271.9	31143.5	31193.6	14131.0
2020-01-26 19:00:00	YM	Futures	31191.4	31277.4	31181.6	31275.2	9375.0
2020-01-26 20:00:00	YM	Futures	31276.3	31281.7	31238.2	31255.6	4499.0
2020-01-26 21:00:00	YM	Futures	31255.6	31255.6	31185.9	31196.8	5329.0
2020-01-26 22:00:00	YM	Futures	31196.8	31254.5	31196.8	31240.4	3332.0
2020-01-26 23:00:00	YM	Futures	31240.4	31244.7	31214.2	31218.6	1910.0
2020-01-26 18:00:00	CL	Futures	47.57	47.58	46.2	46.6	25553.0
2020-01-26 19:00:00	CL	Futures	46.61	47.01	46.48	46.99	14698.0
2020-01-26 20:00:00	CL	Futures	47.0	47.1	46.87	47.01	9746.0
2020-01-26 21:00:00	CL	Futures	47.01	47.02	46.78	46.85	6260.0
2020-01-26 22:00:00	CL	Futures	46.85	46.94	46.82	46.91	3679.0
2020-01-26 23:00:00	CL	Futures	46.92	46.94	46.83	46.86	2252.0
2020-01-26 18:00:00	GC	Futures	1981.1	1991.9	1979.8	1984.0	5245.0
2020-01-26 19:00:00	GC	Futures	1983.9	1984.3	1977.3	1978.0	3417.0
2020-01-26 20:00:00	GC	Futures	1977.8	1982.9	1977.5	1982.0	1642.0
2020-01-26 21:00:00	GC	Futures	1981.9	1984.5	1981.6	1983.1	1413.0
2020-01-26 22:00:00	GC	Futures	1983.3	1983.3	1979.9	1979.9	1349.0
2020-01-26 23:00:00	GC	Futures	1979.9	1980.6	1978.0	1979.4	874.0
2020-01-26 18:00:00	ZN	Futures	130.734075	131.062592	130.734075	130.890512	98094.0
2020-01-26 19:00:00	ZN	Futures	130.890512	130.906156	130.749719	130.765363	56009.0
2020-01-26 20:00:00	ZN	Futures	130.765363	130.812294	130.749719	130.79665	26979.0
2020-01-26 21:00:00	ZN	Futures	130.79665	130.890512	130.781006	130.874868	25238.0
2020-01-26 22:00:00	ZN	Futures	130.874868	130.874868	130.781006	130.79665	13013.0
2020-01-26 23:00:00	ZN	Futures	130.79665	130.812294	130.765363	130.781006	6525.0

> showing 36 of 386 rows — these rows as CSV

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