PREVIEW / futures_1hour / 2018-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-23.parquet
  size:    16 KB
  rows:    309

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
2018-12-23 18:00:00	ES	Futures	2615.63	2631.38	2608.3	2625.95	38279.0
2018-12-23 19:00:00	ES	Futures	2625.68	2627.31	2616.99	2626.22	13127.0
2018-12-23 20:00:00	ES	Futures	2626.49	2635.46	2624.32	2634.64	13734.0
2018-12-23 21:00:00	ES	Futures	2634.64	2640.62	2632.47	2635.46	10011.0
2018-12-23 22:00:00	ES	Futures	2635.46	2638.99	2634.1	2635.46	6390.0
2018-12-23 23:00:00	ES	Futures	2635.46	2644.15	2635.19	2640.35	6329.0
2018-12-23 18:00:00	NQ	Futures	7070.69	7099.32	7030.66	7087.05	11570.0
2018-12-23 19:00:00	NQ	Futures	7086.47	7092.31	7056.96	7086.47	5497.0
2018-12-23 20:00:00	NQ	Futures	7086.47	7112.47	7078.58	7107.8	5545.0
2018-12-23 21:00:00	NQ	Futures	7107.8	7121.24	7100.2	7106.34	4375.0
2018-12-23 22:00:00	NQ	Futures	7105.17	7115.39	7101.37	7108.97	2831.0
2018-12-23 23:00:00	NQ	Futures	7109.26	7139.06	7107.21	7125.33	5235.0
2018-12-23 18:00:00	YM	Futures	24297.0	24394.7	24200.4	24343.7	5155.0
2018-12-23 19:00:00	YM	Futures	24341.5	24360.0	24269.9	24352.4	2458.0
2018-12-23 20:00:00	YM	Futures	24353.5	24437.1	24319.8	24425.1	2855.0
2018-12-23 21:00:00	YM	Futures	24426.2	24480.5	24403.4	24437.1	2346.0
2018-12-23 22:00:00	YM	Futures	24437.1	24474.0	24423.0	24442.5	1369.0
2018-12-23 23:00:00	YM	Futures	24440.3	24506.6	24440.3	24479.4	2648.0
2018-12-23 18:00:00	CL	Futures	41.49	41.74	41.46	41.61	4367.0
2018-12-23 19:00:00	CL	Futures	41.61	41.64	41.39	41.54	5630.0
2018-12-23 20:00:00	CL	Futures	41.55	41.67	41.47	41.66	7941.0
2018-12-23 21:00:00	CL	Futures	41.65	42.21	41.62	42.03	13004.0
2018-12-23 22:00:00	CL	Futures	42.03	42.2	41.92	41.93	7028.0
2018-12-23 23:00:00	CL	Futures	41.92	42.09	41.9	42.04	5139.0
2018-12-23 18:00:00	GC	Futures	1633.2	1635.6	1632.3	1635.1	2704.0
2018-12-23 19:00:00	GC	Futures	1635.1	1638.0	1634.8	1637.0	3386.0
2018-12-23 20:00:00	GC	Futures	1637.0	1638.5	1636.7	1637.7	3529.0
2018-12-23 21:00:00	GC	Futures	1637.7	1641.8	1637.3	1641.5	5058.0
2018-12-23 22:00:00	GC	Futures	1641.5	1642.1	1640.7	1641.6	2890.0
2018-12-23 23:00:00	GC	Futures	1641.7	1642.1	1640.5	1641.6	2752.0
2018-12-23 18:00:00	ZN	Futures	121.97469	122.037653	121.927468	121.97469	10513.0
2018-12-23 19:00:00	ZN	Futures	121.958949	122.006171	121.958949	121.990431	2542.0
2018-12-23 20:00:00	ZN	Futures	121.97469	122.006171	121.958949	121.97469	3854.0
2018-12-23 21:00:00	ZN	Futures	121.97469	121.97469	121.927468	121.97469	3213.0
2018-12-23 22:00:00	ZN	Futures	121.958949	121.97469	121.927468	121.943209	1246.0
2018-12-23 23:00:00	ZN	Futures	121.943209	121.958949	121.911727	121.927468	1968.0

> showing 36 of 309 rows — these rows as CSV

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