PREVIEW / futures_1hour / 2019-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-22.parquet
  size:    16 KB
  rows:    355

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-12-22 18:00:00	ES	Futures	3497.9	3500.1	3495.5	3499.3	8982.0
2019-12-22 19:00:00	ES	Futures	3499.3	3499.6	3497.4	3498.5	5396.0
2019-12-22 20:00:00	ES	Futures	3498.5	3499.8	3498.2	3499.6	5295.0
2019-12-22 21:00:00	ES	Futures	3499.3	3499.8	3498.5	3498.5	3430.0
2019-12-22 22:00:00	ES	Futures	3498.5	3499.6	3498.2	3499.3	2610.0
2019-12-22 23:00:00	ES	Futures	3499.3	3499.6	3498.8	3499.0	1411.0
2019-12-22 18:00:00	NQ	Futures	10075.66	10090.41	10071.91	10088.97	3502.0
2019-12-22 19:00:00	NQ	Futures	10088.97	10090.7	10084.05	10086.36	2077.0
2019-12-22 20:00:00	NQ	Futures	10086.36	10089.54	10084.92	10087.81	2124.0
2019-12-22 21:00:00	NQ	Futures	10087.81	10089.26	10084.34	10084.63	1646.0
2019-12-22 22:00:00	NQ	Futures	10084.63	10087.52	10084.05	10086.07	1104.0
2019-12-22 23:00:00	NQ	Futures	10086.07	10086.94	10084.63	10085.79	453.0
2019-12-22 18:00:00	YM	Futures	31019.4	31039.0	31001.9	31031.3	1469.0
2019-12-22 19:00:00	YM	Futures	31031.3	31032.4	31011.7	31021.5	1011.0
2019-12-22 20:00:00	YM	Futures	31021.5	31031.3	31016.1	31025.9	1311.0
2019-12-22 21:00:00	YM	Futures	31025.9	31028.1	31016.1	31017.2	854.0
2019-12-22 22:00:00	YM	Futures	31017.2	31024.8	31015.0	31022.6	701.0
2019-12-22 23:00:00	YM	Futures	31022.6	31025.9	31019.4	31021.5	349.0
2019-12-22 18:00:00	CL	Futures	53.53	53.57	53.46	53.56	2356.0
2019-12-22 19:00:00	CL	Futures	53.56	53.57	53.5	53.52	1874.0
2019-12-22 20:00:00	CL	Futures	53.52	53.53	53.4	53.43	3065.0
2019-12-22 21:00:00	CL	Futures	53.43	53.45	53.4	53.4	1367.0
2019-12-22 22:00:00	CL	Futures	53.4	53.43	53.37	53.38	1813.0
2019-12-22 23:00:00	CL	Futures	53.37	53.4	53.32	53.34	2455.0
2019-12-22 18:00:00	GC	Futures	1869.0	1869.2	1867.5	1868.7	2021.0
2019-12-22 19:00:00	GC	Futures	1868.7	1869.8	1868.5	1869.4	2367.0
2019-12-22 20:00:00	GC	Futures	1869.4	1870.3	1869.2	1870.2	3147.0
2019-12-22 21:00:00	GC	Futures	1870.3	1870.7	1869.7	1870.7	2367.0
2019-12-22 22:00:00	GC	Futures	1870.6	1872.6	1870.6	1871.7	6344.0
2019-12-22 23:00:00	GC	Futures	1871.7	1872.7	1871.6	1871.7	1705.0
2019-12-22 18:00:00	ZN	Futures	128.371883	128.371883	128.309308	128.356239	6452.0
2019-12-22 19:00:00	ZN	Futures	128.356239	128.434457	128.356239	128.40317	13301.0
2019-12-22 20:00:00	ZN	Futures	128.40317	128.434457	128.371883	128.40317	7351.0
2019-12-22 21:00:00	ZN	Futures	128.40317	128.434457	128.40317	128.434457	1481.0
2019-12-22 22:00:00	ZN	Futures	128.434457	128.434457	128.40317	128.434457	4668.0
2019-12-22 23:00:00	ZN	Futures	128.434457	128.434457	128.40317	128.418814	1762.0

> showing 36 of 355 rows — these rows as CSV

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