PREVIEW / futures_1hour / 2020-01-12

all futures 1-hour files

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

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-12 18:00:00	ES	Futures	3539.9	3546.2	3539.7	3541.6	11790.0
2020-01-12 19:00:00	ES	Futures	3541.6	3544.8	3541.0	3544.3	5868.0
2020-01-12 20:00:00	ES	Futures	3544.3	3548.9	3544.3	3545.9	10917.0
2020-01-12 21:00:00	ES	Futures	3545.6	3548.6	3544.8	3548.3	4785.0
2020-01-12 22:00:00	ES	Futures	3548.3	3549.2	3547.8	3548.6	3622.0
2020-01-12 23:00:00	ES	Futures	3548.6	3548.9	3548.1	3548.1	1549.0
2020-01-12 18:00:00	NQ	Futures	10385.95	10409.66	10385.95	10395.78	5888.0
2020-01-12 19:00:00	NQ	Futures	10396.07	10407.06	10393.18	10404.45	4100.0
2020-01-12 20:00:00	NQ	Futures	10404.74	10425.56	10404.74	10411.68	7375.0
2020-01-12 21:00:00	NQ	Futures	10411.68	10424.41	10410.24	10422.96	3534.0
2020-01-12 22:00:00	NQ	Futures	10422.96	10427.3	10420.94	10422.38	2762.0
2020-01-12 23:00:00	NQ	Futures	10422.38	10424.7	10420.07	10421.8	1059.0
2020-01-12 18:00:00	YM	Futures	31328.6	31397.2	31328.6	31365.6	3288.0
2020-01-12 19:00:00	YM	Futures	31365.6	31392.8	31359.0	31389.5	1466.0
2020-01-12 20:00:00	YM	Futures	31389.5	31434.2	31389.5	31393.9	3010.0
2020-01-12 21:00:00	YM	Futures	31393.9	31425.5	31384.1	31421.1	1631.0
2020-01-12 22:00:00	YM	Futures	31422.2	31426.5	31411.3	31416.8	823.0
2020-01-12 23:00:00	YM	Futures	31416.8	31417.8	31410.2	31411.3	426.0
2020-01-12 18:00:00	CL	Futures	52.31	52.38	51.92	52.2	5450.0
2020-01-12 19:00:00	CL	Futures	52.2	52.29	52.17	52.26	2085.0
2020-01-12 20:00:00	CL	Futures	52.27	52.34	52.11	52.3	4990.0
2020-01-12 21:00:00	CL	Futures	52.3	52.38	52.25	52.36	2538.0
2020-01-12 22:00:00	CL	Futures	52.36	52.43	52.31	52.32	3102.0
2020-01-12 23:00:00	CL	Futures	52.31	52.36	52.31	52.36	1170.0
2020-01-12 18:00:00	GC	Futures	1970.7	1970.8	1965.5	1967.0	5014.0
2020-01-12 19:00:00	GC	Futures	1967.3	1968.1	1965.9	1966.4	3507.0
2020-01-12 20:00:00	GC	Futures	1966.4	1966.4	1960.7	1964.0	13301.0
2020-01-12 21:00:00	GC	Futures	1964.0	1965.0	1962.2	1963.1	5568.0
2020-01-12 22:00:00	GC	Futures	1963.1	1964.1	1962.7	1963.9	3815.0
2020-01-12 23:00:00	GC	Futures	1964.0	1964.0	1962.2	1962.5	1733.0
2020-01-12 18:00:00	ZN	Futures	129.263571	129.263571	129.21664	129.247928	6139.0
2020-01-12 19:00:00	ZN	Futures	129.232284	129.263571	129.21664	129.247928	3377.0
2020-01-12 20:00:00	ZN	Futures	129.247928	129.247928	129.200997	129.232284	7272.0
2020-01-12 21:00:00	ZN	Futures	129.232284	129.247928	129.21664	129.232284	3164.0
2020-01-12 22:00:00	ZN	Futures	129.232284	129.247928	129.21664	129.247928	3189.0
2020-01-12 23:00:00	ZN	Futures	129.232284	129.247928	129.21664	129.232284	4113.0

> showing 36 of 358 rows — these rows as CSV

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