PREVIEW / futures_1hour / 2019-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-21.parquet
  size:    15 KB
  rows:    300

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-04-21 18:00:00	ES	Futures	3154.27	3161.87	3152.92	3158.61	7829.0
2019-04-21 19:00:00	ES	Futures	3158.34	3159.7	3156.71	3157.53	4092.0
2019-04-21 20:00:00	ES	Futures	3157.53	3160.24	3156.17	3158.34	14242.0
2019-04-21 21:00:00	ES	Futures	3158.61	3158.88	3145.87	3151.56	18277.0
2019-04-21 22:00:00	ES	Futures	3151.84	3152.92	3148.85	3151.29	7798.0
2019-04-21 23:00:00	ES	Futures	3151.02	3151.84	3149.12	3149.4	4602.0
2019-04-21 18:00:00	NQ	Futures	8985.37	8999.05	8978.09	8992.35	3695.0
2019-04-21 19:00:00	NQ	Futures	8992.06	8995.27	8985.37	8987.4	1730.0
2019-04-21 20:00:00	NQ	Futures	8987.7	8995.56	8982.46	8990.61	4807.0
2019-04-21 21:00:00	NQ	Futures	8991.19	8992.35	8952.76	8971.39	8494.0
2019-04-21 22:00:00	NQ	Futures	8971.68	8975.76	8964.11	8967.61	4569.0
2019-04-21 23:00:00	NQ	Futures	8967.9	8971.1	8959.45	8960.91	2544.0
2019-04-21 18:00:00	YM	Futures	28893.9	28960.2	28871.0	28940.6	2282.0
2019-04-21 19:00:00	YM	Futures	28938.5	28949.3	28927.6	28933.0	1258.0
2019-04-21 20:00:00	YM	Futures	28933.0	28963.5	28923.2	28951.5	3357.0
2019-04-21 21:00:00	YM	Futures	28951.5	28955.9	28838.4	28888.4	5225.0
2019-04-21 22:00:00	YM	Futures	28888.4	28893.9	28864.5	28878.7	2253.0
2019-04-21 23:00:00	YM	Futures	28877.6	28885.2	28853.6	28858.0	1906.0
2019-04-21 18:00:00	CL	Futures	57.28	57.61	57.26	57.5	5124.0
2019-04-21 19:00:00	CL	Futures	57.49	57.69	57.49	57.65	4726.0
2019-04-21 20:00:00	CL	Futures	57.65	57.96	57.64	57.9	11963.0
2019-04-21 21:00:00	CL	Futures	57.9	58.33	57.9	58.24	20902.0
2019-04-21 22:00:00	CL	Futures	58.24	59.0	58.24	58.94	39858.0
2019-04-21 23:00:00	CL	Futures	58.93	58.98	58.57	58.6	19625.0
2019-04-21 18:00:00	GC	Futures	1640.0	1640.8	1639.4	1640.5	1747.0
2019-04-21 19:00:00	GC	Futures	1640.5	1641.6	1639.9	1641.2	2163.0
2019-04-21 20:00:00	GC	Futures	1641.2	1642.0	1639.3	1640.0	4111.0
2019-04-21 21:00:00	GC	Futures	1640.2	1643.0	1639.6	1643.0	6120.0
2019-04-21 22:00:00	GC	Futures	1642.9	1643.9	1642.5	1643.4	5277.0
2019-04-21 23:00:00	GC	Futures	1643.5	1645.0	1643.0	1643.1	5910.0
2019-04-21 18:00:00	ZN	Futures	123.783881	123.831007	123.768172	123.799589	6833.0
2019-04-21 19:00:00	ZN	Futures	123.799589	123.831007	123.799589	123.815298	3737.0
2019-04-21 20:00:00	ZN	Futures	123.799589	123.831007	123.736755	123.752464	23785.0
2019-04-21 21:00:00	ZN	Futures	123.752464	123.799589	123.689629	123.705338	34662.0
2019-04-21 22:00:00	ZN	Futures	123.705338	123.721046	123.705338	123.705338	7212.0
2019-04-21 23:00:00	ZN	Futures	123.705338	123.768172	123.705338	123.752464	12133.0

> showing 36 of 300 rows — these rows as CSV

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