PREVIEW / futures_1hour / 2019-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-19.parquet
  size:    17 KB
  rows:    357

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-05-19 18:00:00	ES	Futures	3103.04	3109.27	3102.77	3107.1	8373.0
2019-05-19 19:00:00	ES	Futures	3106.83	3115.51	3106.56	3113.07	10087.0
2019-05-19 20:00:00	ES	Futures	3113.07	3116.86	3111.44	3114.97	15310.0
2019-05-19 21:00:00	ES	Futures	3114.69	3119.3	3112.25	3112.53	15294.0
2019-05-19 22:00:00	ES	Futures	3112.53	3117.68	3109.27	3114.97	14951.0
2019-05-19 23:00:00	ES	Futures	3114.97	3115.24	3111.98	3112.8	5944.0
2019-05-19 18:00:00	NQ	Futures	8751.86	8770.2	8748.66	8760.3	3954.0
2019-05-19 19:00:00	NQ	Futures	8759.72	8789.71	8759.43	8783.01	4212.0
2019-05-19 20:00:00	NQ	Futures	8783.01	8795.24	8779.23	8789.13	6360.0
2019-05-19 21:00:00	NQ	Futures	8788.84	8803.69	8776.9	8778.06	9493.0
2019-05-19 22:00:00	NQ	Futures	8778.35	8792.62	8763.8	8785.34	8282.0
2019-05-19 23:00:00	NQ	Futures	8785.63	8787.09	8776.32	8780.1	3538.0
2019-05-19 18:00:00	YM	Futures	28035.7	28080.3	28018.3	28061.8	1939.0
2019-05-19 19:00:00	YM	Futures	28060.7	28146.7	28057.5	28128.2	4211.0
2019-05-19 20:00:00	YM	Futures	28130.3	28160.8	28097.7	28127.1	3124.0
2019-05-19 21:00:00	YM	Futures	28127.1	28171.7	28114.0	28117.3	3715.0
2019-05-19 22:00:00	YM	Futures	28118.4	28161.9	28089.0	28139.0	3786.0
2019-05-19 23:00:00	YM	Futures	28140.1	28144.5	28117.3	28122.7	1602.0
2019-05-19 18:00:00	CL	Futures	56.26	56.84	56.23	56.65	9576.0
2019-05-19 19:00:00	CL	Futures	56.65	56.73	56.59	56.67	3502.0
2019-05-19 20:00:00	CL	Futures	56.67	56.82	56.59	56.8	5960.0
2019-05-19 21:00:00	CL	Futures	56.79	57.03	56.77	56.83	17375.0
2019-05-19 22:00:00	CL	Futures	56.84	56.88	56.77	56.84	7007.0
2019-05-19 23:00:00	CL	Futures	56.84	56.93	56.81	56.86	5473.0
2019-05-19 18:00:00	GC	Futures	1639.5	1640.9	1638.6	1640.0	1843.0
2019-05-19 19:00:00	GC	Futures	1639.9	1640.2	1638.5	1639.4	2079.0
2019-05-19 20:00:00	GC	Futures	1639.5	1639.8	1638.2	1639.8	3616.0
2019-05-19 21:00:00	GC	Futures	1639.9	1640.7	1638.2	1638.5	6772.0
2019-05-19 22:00:00	GC	Futures	1638.4	1639.0	1637.0	1637.5	5300.0
2019-05-19 23:00:00	GC	Futures	1637.5	1639.0	1637.0	1638.1	3688.0
2019-05-19 18:00:00	ZN	Futures	125.166239	125.197656	125.134822	125.181947	5899.0
2019-05-19 19:00:00	ZN	Futures	125.181947	125.197656	125.056279	125.103404	21955.0
2019-05-19 20:00:00	ZN	Futures	125.087696	125.103404	125.071987	125.071987	14600.0
2019-05-19 21:00:00	ZN	Futures	125.071987	125.087696	125.04057	125.087696	21650.0
2019-05-19 22:00:00	ZN	Futures	125.087696	125.103404	125.056279	125.071987	11953.0
2019-05-19 23:00:00	ZN	Futures	125.071987	125.103404	125.071987	125.071987	4116.0

> showing 36 of 357 rows — these rows as CSV

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