PREVIEW / futures_1hour / 2019-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-14.parquet
  size:    16 KB
  rows:    334

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-14 18:00:00	ES	Futures	3157.8	3159.7	3155.63	3156.17	8056.0
2019-04-14 19:00:00	ES	Futures	3156.17	3157.53	3156.17	3156.99	3320.0
2019-04-14 20:00:00	ES	Futures	3156.99	3157.8	3155.9	3156.17	7169.0
2019-04-14 21:00:00	ES	Futures	3156.44	3157.53	3154.82	3157.26	9573.0
2019-04-14 22:00:00	ES	Futures	3157.26	3158.88	3156.71	3158.88	6049.0
2019-04-14 23:00:00	ES	Futures	3158.88	3158.88	3155.63	3156.71	6573.0
2019-04-14 18:00:00	NQ	Futures	8914.03	8917.53	8905.01	8906.46	2356.0
2019-04-14 19:00:00	NQ	Futures	8906.75	8910.25	8906.46	8909.38	1530.0
2019-04-14 20:00:00	NQ	Futures	8908.79	8913.16	8904.72	8905.88	3738.0
2019-04-14 21:00:00	NQ	Futures	8905.88	8911.41	8901.22	8907.92	4620.0
2019-04-14 22:00:00	NQ	Futures	8907.92	8914.91	8905.59	8913.74	2812.0
2019-04-14 23:00:00	NQ	Futures	8914.03	8914.03	8901.51	8903.55	3672.0
2019-04-14 18:00:00	YM	Futures	28720.9	28752.5	28714.4	28724.2	1335.0
2019-04-14 19:00:00	YM	Futures	28724.2	28739.4	28723.1	28732.9	808.0
2019-04-14 20:00:00	YM	Futures	28734.0	28744.9	28722.0	28729.6	1522.0
2019-04-14 21:00:00	YM	Futures	28729.6	28742.7	28711.2	28741.6	1707.0
2019-04-14 22:00:00	YM	Futures	28742.7	28762.3	28735.1	28755.7	1388.0
2019-04-14 23:00:00	YM	Futures	28755.7	28760.1	28726.4	28735.1	1200.0
2019-04-14 18:00:00	CL	Futures	57.13	57.18	56.9	56.95	924.0
2019-04-14 19:00:00	CL	Futures	56.94	57.02	56.91	57.0	359.0
2019-04-14 20:00:00	CL	Futures	57.02	57.06	56.81	56.87	839.0
2019-04-14 21:00:00	CL	Futures	56.88	56.97	56.81	56.97	916.0
2019-04-14 22:00:00	CL	Futures	56.97	57.06	56.96	57.04	1261.0
2019-04-14 23:00:00	CL	Futures	57.05	57.11	56.99	57.0	693.0
2019-04-14 18:00:00	GC	Futures	1660.6	1662.1	1660.6	1661.2	1724.0
2019-04-14 19:00:00	GC	Futures	1661.1	1661.2	1658.4	1659.2	3397.0
2019-04-14 20:00:00	GC	Futures	1659.2	1659.8	1657.7	1659.8	4884.0
2019-04-14 21:00:00	GC	Futures	1659.7	1659.9	1655.2	1656.3	10698.0
2019-04-14 22:00:00	GC	Futures	1656.3	1657.2	1655.6	1657.2	6484.0
2019-04-14 23:00:00	GC	Futures	1657.2	1658.0	1656.2	1658.0	4471.0
2019-04-14 18:00:00	ZN	Futures	123.705338	123.768172	123.689629	123.768172	15898.0
2019-04-14 19:00:00	ZN	Futures	123.768172	123.783881	123.752464	123.768172	4840.0
2019-04-14 20:00:00	ZN	Futures	123.768172	123.799589	123.736755	123.783881	22028.0
2019-04-14 21:00:00	ZN	Futures	123.799589	123.815298	123.736755	123.768172	28587.0
2019-04-14 22:00:00	ZN	Futures	123.768172	123.768172	123.736755	123.752464	11446.0
2019-04-14 23:00:00	ZN	Futures	123.752464	123.799589	123.736755	123.783881	9783.0

> showing 36 of 334 rows — these rows as CSV

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