PREVIEW / futures_1hour / 2018-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-11.parquet
  size:    15 KB
  rows:    305

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-11-11 18:00:00	ES	Futures	3023.26	3024.08	3017.82	3022.99	10364.0
2018-11-11 19:00:00	ES	Futures	3022.72	3027.88	3022.44	3027.07	8415.0
2018-11-11 20:00:00	ES	Futures	3027.34	3035.23	3027.34	3033.6	13975.0
2018-11-11 21:00:00	ES	Futures	3033.32	3036.32	3032.24	3035.77	8214.0
2018-11-11 22:00:00	ES	Futures	3036.04	3041.21	3033.32	3037.95	10250.0
2018-11-11 23:00:00	ES	Futures	3037.95	3039.04	3036.32	3036.59	4278.0
2018-11-11 18:00:00	NQ	Futures	8243.59	8256.79	8227.46	8251.81	3886.0
2018-11-11 19:00:00	NQ	Futures	8251.51	8265.89	8250.34	8262.95	3319.0
2018-11-11 20:00:00	NQ	Futures	8262.95	8300.5	8262.95	8291.7	7071.0
2018-11-11 21:00:00	NQ	Futures	8291.4	8300.79	8286.71	8299.32	4340.0
2018-11-11 22:00:00	NQ	Futures	8299.32	8334.52	8289.06	8320.15	6334.0
2018-11-11 23:00:00	NQ	Futures	8320.15	8325.14	8310.76	8313.99	3348.0
2018-11-11 18:00:00	YM	Futures	28222.2	28231.9	28162.4	28209.1	1429.0
2018-11-11 19:00:00	YM	Futures	28206.9	28253.7	28206.9	28243.9	1985.0
2018-11-11 20:00:00	YM	Futures	28245.0	28311.3	28245.0	28290.6	3413.0
2018-11-11 21:00:00	YM	Futures	28289.5	28317.8	28278.7	28314.5	1821.0
2018-11-11 22:00:00	YM	Futures	28315.6	28353.6	28287.3	28326.5	2513.0
2018-11-11 23:00:00	YM	Futures	28327.6	28334.1	28308.0	28310.2	1438.0
2018-11-11 18:00:00	CL	Futures	55.8	56.05	55.67	55.87	13982.0
2018-11-11 19:00:00	CL	Futures	55.86	55.93	55.8	55.84	5534.0
2018-11-11 20:00:00	CL	Futures	55.84	55.86	55.68	55.79	9247.0
2018-11-11 21:00:00	CL	Futures	55.8	55.87	55.76	55.86	3912.0
2018-11-11 22:00:00	CL	Futures	55.86	55.92	55.82	55.91	3866.0
2018-11-11 23:00:00	CL	Futures	55.91	56.15	55.89	56.04	8830.0
2018-11-11 18:00:00	GC	Futures	1576.8	1578.0	1576.1	1578.0	2259.0
2018-11-11 19:00:00	GC	Futures	1578.0	1578.9	1577.8	1578.0	2906.0
2018-11-11 20:00:00	GC	Futures	1578.0	1578.8	1575.7	1577.8	6600.0
2018-11-11 21:00:00	GC	Futures	1577.8	1578.9	1577.2	1578.9	2807.0
2018-11-11 22:00:00	GC	Futures	1578.9	1579.1	1577.1	1577.1	2496.0
2018-11-11 23:00:00	GC	Futures	1577.1	1577.9	1576.7	1577.6	1964.0
2018-11-11 18:00:00	ZN	Futures	119.031527	119.078743	119.015788	119.031527	10753.0
2018-11-11 19:00:00	ZN	Futures	119.031527	119.047265	119.00005	119.015788	8710.0
2018-11-11 20:00:00	ZN	Futures	119.015788	119.015788	118.984311	119.00005	7521.0
2018-11-11 21:00:00	ZN	Futures	118.984311	119.00005	118.968572	118.984311	2666.0
2018-11-11 22:00:00	ZN	Futures	118.984311	119.00005	118.968572	118.968572	3080.0
2018-11-11 23:00:00	ZN	Futures	118.984311	118.984311	118.968572	118.968572	1043.0

> showing 36 of 305 rows — these rows as CSV

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