PREVIEW / futures_1hour / 2019-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-04.parquet
  size:    18 KB
  rows:    373

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-08-04 18:00:00	ES	Futures	3171.85	3174.56	3168.06	3172.12	10901.0
2019-08-04 19:00:00	ES	Futures	3172.12	3173.2	3167.52	3169.69	7151.0
2019-08-04 20:00:00	ES	Futures	3169.41	3174.83	3168.6	3173.75	17431.0
2019-08-04 21:00:00	ES	Futures	3173.75	3176.45	3145.59	3153.44	68142.0
2019-08-04 22:00:00	ES	Futures	3153.17	3153.98	3138.83	3140.99	63334.0
2019-08-04 23:00:00	ES	Futures	3141.26	3143.43	3133.68	3138.83	29122.0
2019-08-04 18:00:00	NQ	Futures	8938.42	8938.42	8911.14	8924.78	6149.0
2019-08-04 19:00:00	NQ	Futures	8924.2	8930.0	8906.79	8915.21	4073.0
2019-08-04 20:00:00	NQ	Futures	8915.21	8933.78	8910.85	8930.29	7100.0
2019-08-04 21:00:00	NQ	Futures	8930.0	8942.77	8829.61	8856.02	24449.0
2019-08-04 22:00:00	NQ	Futures	8855.44	8861.82	8806.98	8819.75	23932.0
2019-08-04 23:00:00	NQ	Futures	8820.33	8823.23	8788.41	8805.53	12791.0
2019-08-04 18:00:00	YM	Futures	28743.7	28752.4	28695.9	28733.9	3172.0
2019-08-04 19:00:00	YM	Futures	28732.8	28744.8	28701.3	28715.4	1750.0
2019-08-04 20:00:00	YM	Futures	28714.4	28753.5	28708.9	28745.9	2832.0
2019-08-04 21:00:00	YM	Futures	28745.9	28775.3	28529.5	28591.5	11634.0
2019-08-04 22:00:00	YM	Futures	28588.2	28596.9	28476.2	28490.3	12505.0
2019-08-04 23:00:00	YM	Futures	28491.4	28511.0	28416.4	28456.6	7489.0
2019-08-04 18:00:00	CL	Futures	49.17	49.17	48.92	49.11	4732.0
2019-08-04 19:00:00	CL	Futures	49.12	49.16	49.04	49.12	2330.0
2019-08-04 20:00:00	CL	Futures	49.12	49.22	49.11	49.16	4043.0
2019-08-04 21:00:00	CL	Futures	49.17	49.3	48.9	49.2	24662.0
2019-08-04 22:00:00	CL	Futures	49.2	49.27	48.96	48.98	19244.0
2019-08-04 23:00:00	CL	Futures	48.98	49.05	48.8	48.81	8674.0
2019-08-04 18:00:00	GC	Futures	1838.5	1842.8	1835.4	1837.0	4695.0
2019-08-04 19:00:00	GC	Futures	1837.0	1839.7	1837.0	1839.1	2660.0
2019-08-04 20:00:00	GC	Futures	1839.1	1845.2	1838.0	1843.8	9110.0
2019-08-04 21:00:00	GC	Futures	1843.9	1854.7	1838.7	1851.3	42143.0
2019-08-04 22:00:00	GC	Futures	1851.4	1855.8	1847.0	1853.7	29756.0
2019-08-04 23:00:00	GC	Futures	1853.5	1860.1	1853.2	1855.2	19468.0
2019-08-04 18:00:00	ZN	Futures	129.691897	129.707618	129.644737	129.676177	6516.0
2019-08-04 19:00:00	ZN	Futures	129.676177	129.707618	129.644737	129.660457	7955.0
2019-08-04 20:00:00	ZN	Futures	129.660457	129.754778	129.629016	129.739058	21580.0
2019-08-04 21:00:00	ZN	Futures	129.739058	130.226385	129.660457	130.037742	137813.0
2019-08-04 22:00:00	ZN	Futures	130.037742	130.383588	130.006302	130.336427	95031.0
2019-08-04 23:00:00	ZN	Futures	130.336427	130.415028	130.273546	130.304986	33385.0

> showing 36 of 373 rows — these rows as CSV

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