PREVIEW / futures_1hour / 2019-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-02.parquet
  size:    17 KB
  rows:    361

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
2019-06-02 18:00:00	ES	Futures	2972.37	2976.16	2962.88	2966.13	34159.0
2019-06-02 19:00:00	ES	Futures	2966.13	2969.38	2965.32	2966.94	13102.0
2019-06-02 20:00:00	ES	Futures	2966.94	2971.82	2965.05	2971.55	20999.0
2019-06-02 21:00:00	ES	Futures	2971.55	2972.37	2968.03	2969.93	23166.0
2019-06-02 22:00:00	ES	Futures	2969.93	2970.74	2966.94	2969.11	13963.0
2019-06-02 23:00:00	ES	Futures	2969.11	2970.74	2967.76	2969.38	9996.0
2019-06-02 18:00:00	NQ	Futures	8280.48	8281.06	8241.17	8250.78	12714.0
2019-06-02 19:00:00	NQ	Futures	8250.78	8259.51	8244.96	8247.87	5244.0
2019-06-02 20:00:00	NQ	Futures	8247.58	8261.55	8241.46	8258.93	7904.0
2019-06-02 21:00:00	NQ	Futures	8258.93	8267.08	8249.03	8257.19	8991.0
2019-06-02 22:00:00	NQ	Futures	8256.89	8259.22	8247.87	8250.2	7386.0
2019-06-02 23:00:00	NQ	Futures	8250.2	8252.82	8242.34	8247.0	5292.0
2019-06-02 18:00:00	YM	Futures	26912.1	26916.5	26775.1	26796.9	7376.0
2019-06-02 19:00:00	YM	Futures	26800.1	26826.2	26789.2	26807.7	4860.0
2019-06-02 20:00:00	YM	Futures	26807.7	26863.2	26792.5	26861.0	5418.0
2019-06-02 21:00:00	YM	Futures	26861.0	26873.0	26826.2	26848.0	4931.0
2019-06-02 22:00:00	YM	Futures	26846.9	26854.5	26824.0	26840.4	2873.0
2019-06-02 23:00:00	YM	Futures	26839.3	26852.3	26826.2	26842.5	1783.0
2019-06-02 18:00:00	CL	Futures	47.63	47.64	46.47	46.71	20891.0
2019-06-02 19:00:00	CL	Futures	46.71	47.12	46.71	47.11	10952.0
2019-06-02 20:00:00	CL	Futures	47.11	47.29	46.91	47.02	14997.0
2019-06-02 21:00:00	CL	Futures	47.02	47.29	46.92	47.15	20110.0
2019-06-02 22:00:00	CL	Futures	47.15	47.37	47.09	47.35	10502.0
2019-06-02 23:00:00	CL	Futures	47.35	47.47	47.27	47.28	11195.0
2019-06-02 18:00:00	GC	Futures	1677.9	1679.3	1675.9	1678.9	5290.0
2019-06-02 19:00:00	GC	Futures	1678.8	1680.3	1677.1	1680.2	4289.0
2019-06-02 20:00:00	GC	Futures	1680.2	1681.1	1679.2	1679.2	7517.0
2019-06-02 21:00:00	GC	Futures	1679.2	1683.1	1679.1	1683.1	12602.0
2019-06-02 22:00:00	GC	Futures	1683.1	1684.4	1682.1	1684.3	6350.0
2019-06-02 23:00:00	GC	Futures	1684.4	1684.7	1682.8	1683.5	4552.0
2019-06-02 18:00:00	ZN	Futures	126.988438	127.30261	126.988438	127.255485	1087.0
2019-06-02 19:00:00	ZN	Futures	127.239776	127.239776	127.161233	127.19265	1115.0
2019-06-02 20:00:00	ZN	Futures	127.176941	127.19265	127.145524	127.161233	1399.0
2019-06-02 21:00:00	ZN	Futures	127.176941	127.224067	127.129816	127.129816	4223.0
2019-06-02 22:00:00	ZN	Futures	127.129816	127.224067	127.129816	127.208359	176.0
2019-06-02 23:00:00	ZN	Futures	127.208359	127.208359	127.161233	127.19265	662.0

> showing 36 of 361 rows — these rows as CSV

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