PREVIEW / futures_1hour / 2019-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-25.parquet
  size:    18 KB
  rows:    364

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-08-25 18:00:00	ES	Futures	3065.46	3065.73	3043.0	3055.18	59036.0
2019-08-25 19:00:00	ES	Futures	3055.45	3061.67	3052.2	3058.16	25344.0
2019-08-25 20:00:00	ES	Futures	3058.43	3068.71	3055.18	3058.7	37725.0
2019-08-25 21:00:00	ES	Futures	3058.7	3069.8	3057.34	3067.09	38942.0
2019-08-25 22:00:00	ES	Futures	3066.82	3078.46	3064.38	3076.56	24391.0
2019-08-25 23:00:00	ES	Futures	3076.56	3078.19	3072.5	3075.75	13161.0
2019-08-25 18:00:00	NQ	Futures	8628.84	8628.84	8533.96	8587.93	15914.0
2019-08-25 19:00:00	NQ	Futures	8588.22	8610.27	8576.9	8600.69	6979.0
2019-08-25 20:00:00	NQ	Futures	8601.27	8641.6	8591.99	8604.46	17903.0
2019-08-25 21:00:00	NQ	Futures	8605.04	8640.44	8601.27	8629.13	15198.0
2019-08-25 22:00:00	NQ	Futures	8628.55	8671.78	8622.16	8665.39	9071.0
2019-08-25 23:00:00	NQ	Futures	8665.39	8674.97	8650.31	8664.81	5619.0
2019-08-25 18:00:00	YM	Futures	27689.9	27689.9	27476.8	27592.1	9012.0
2019-08-25 19:00:00	YM	Futures	27593.1	27643.2	27560.5	27612.7	4178.0
2019-08-25 20:00:00	YM	Futures	27613.8	27718.2	27600.8	27630.1	6938.0
2019-08-25 21:00:00	YM	Futures	27631.2	27737.8	27618.2	27711.7	7493.0
2019-08-25 22:00:00	YM	Futures	27709.5	27830.2	27686.7	27803.0	5778.0
2019-08-25 23:00:00	YM	Futures	27803.0	27820.4	27774.8	27799.8	2357.0
2019-08-25 18:00:00	CL	Futures	47.27	47.43	47.02	47.11	13317.0
2019-08-25 19:00:00	CL	Futures	47.11	47.25	47.11	47.15	5460.0
2019-08-25 20:00:00	CL	Futures	47.16	47.35	47.13	47.2	8549.0
2019-08-25 21:00:00	CL	Futures	47.2	47.51	47.19	47.45	16004.0
2019-08-25 22:00:00	CL	Futures	47.44	47.66	47.4	47.6	10109.0
2019-08-25 23:00:00	CL	Futures	47.6	47.71	47.52	47.58	6540.0
2019-08-25 18:00:00	GC	Futures	1957.8	1982.6	1957.8	1973.0	27480.0
2019-08-25 19:00:00	GC	Futures	1973.0	1974.3	1967.4	1972.8	11984.0
2019-08-25 20:00:00	GC	Futures	1972.8	1975.5	1967.9	1969.8	14326.0
2019-08-25 21:00:00	GC	Futures	1969.8	1972.1	1965.7	1968.8	25243.0
2019-08-25 22:00:00	GC	Futures	1969.0	1969.3	1961.4	1963.1	16556.0
2019-08-25 23:00:00	GC	Futures	1963.1	1966.4	1961.6	1962.7	10122.0
2019-08-25 18:00:00	ZN	Futures	132.112813	132.348616	132.112813	132.238575	47869.0
2019-08-25 19:00:00	ZN	Futures	132.222854	132.301456	132.175694	132.238575	21147.0
2019-08-25 20:00:00	ZN	Futures	132.222854	132.270015	132.112813	132.191414	35309.0
2019-08-25 21:00:00	ZN	Futures	132.191414	132.191414	132.081372	132.128533	36234.0
2019-08-25 22:00:00	ZN	Futures	132.112813	132.159974	132.034212	132.097093	28827.0
2019-08-25 23:00:00	ZN	Futures	132.112813	132.159974	132.081372	132.144253	17815.0

> showing 36 of 364 rows — these rows as CSV

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