PREVIEW / futures_daily / 2019-08-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-05.parquet
  size:    10 KB
  rows:    119

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2019-08-05	ES	Futures	3160.83	3165.41	3043.48	3053.73	3072122.0
2019-08-05	NQ	Futures	8867.22	8871.53	8473.46	8502.82	848399.0
2019-08-05	YM	Futures	27753.2	27783.7	26749.4	26828.2	399217.0
2019-08-05	CL	Futures	56.51	56.74	55.33	55.81	823844.0
2019-08-05	GC	Futures	1790.1	1827.9	1787.2	1821.3	534188.0
2019-08-05	ZN	Futures	128.311311	129.400013	128.2491	129.244484	2625894.0
2019-08-05	A6	Futures	0.69987	0.701	0.69514	0.69647	115003.0
2019-08-05	AD	Futures	0.76363	0.76559	0.76146	0.76312	71087.0
2019-08-05	ALI	Futures	2173.19	2173.19	2163.72	2167.38	110.0
2019-08-05	B	Futures	46.36	46.44	45.01	45.12	378858.0
2019-08-05	B6	Futures	1.2428	1.2465	1.2377	1.2419	121188.0
2019-08-05	BR	Futures	0.20399	0.20399	0.20051	0.20119	13518.0
2019-08-05	BTC	Futures	15241.5	16700.9	15241.5	16398.0	4071.0
2019-08-05	BZ	Futures	45.83	45.83	44.43	44.54	47722.0
2019-08-05	C	Futures	1717.0	1720.0	1682.0	1686.0	8692.0
2019-08-05	CB	Futures	275.816	275.991	275.291	275.991	25.0
2019-08-05	CC	Futures	1545.0	1559.0	1525.0	1540.0	29488.0
2019-08-05	CNH	Futures	6.9919	7.1179	6.9808	7.1109	3734.0
2019-08-05	CSC	Futures	3.104	3.117	3.09	3.115	106.0
2019-08-05	CT	Futures	58.27	58.27	55.79	57.19	64.0
2019-08-05	DC	Futures	26.08	26.21	25.94	26.14	278.0
2019-08-05	DX	Futures	94.259	94.288	93.575	93.689	26779.0
2019-08-05	E1	Futures	1.18499	1.19797	1.18441	1.19554	41221.0
2019-08-05	E6	Futures	1.21551	1.22718	1.21534	1.22604	239517.0
2019-08-05	E7	Futures	1.2097	1.2208	1.209	1.2196	4856.0
2019-08-05	EBM	Futures	198.64	199.5	198.06	198.93	15044.0
2019-08-05	ED	Futures	95.3476	95.4499	95.3476	95.4353	775705.0
2019-08-05	ER	Futures	98.543	98.558	98.538	98.548	76825.0
2019-08-05	EW	Futures	2006.8	2011.2	1935.6	1954.1	21014.0
2019-08-05	FBON	Futures	145.18	145.5	145.05	145.13	151.0
2019-08-05	FBTP	Futures	126.21	126.36	125.3	125.45	71064.0
2019-08-05	FBTS	Futures	107.82	107.82	107.532	107.561	36390.0
2019-08-05	FCE	Futures	4832.8	4843.7	4725.3	4774.0	150493.0
2019-08-05	FDAX	Futures	12530.5	12530.5	12152.0	12285.7	177929.0
2019-08-05	FDIV	Futures	140.2	140.2	139.22	139.41	87.0
2019-08-05	FDXM	Futures	12358.5	12374.1	12002.8	12134.4	91386.0
2019-08-05	FESX	Futures	2947.9	2948.8	2856.2	2890.3	1831846.0
2019-08-05	FEU3	Futures	99.164	99.174	99.164	99.174	100.0
2019-08-05	FGBL	Futures	167.33	167.95	167.28	167.56	588132.0
2019-08-05	FGBM	Futures	135.12	135.32	135.1	135.22	356974.0
2019-08-05	FGBS	Futures	113.137	113.222	113.137	113.197	257650.0
2019-08-05	FGBX	Futures	220.72	224.0	220.62	221.32	80965.0
2019-08-05	FMWO	Futures	7169.8	7169.8	7000.2	7081.0	3380.0
2019-08-05	FOAT	Futures	154.58	154.67	154.08	154.13	102480.0
2019-08-05	FTDX	Futures	2775.3	2775.3	2732.3	2738.2	199.0
2019-08-05	FTI	Futures	519.02	519.97	505.39	511.46	47305.0
2019-08-05	FTUK	Futures	6737.7	6750.2	6549.3	6603.8	188635.0
2019-08-05	FVSA	Futures	215.17	244.23	212.08	229.39	77278.0
2019-08-05	FXXP	Futures	334.7	335.0	326.4	330.0	124551.0
2019-08-05	G	Futures	123.23	123.51	123.14	123.31	221273.0

> showing 50 of 119 rows — these rows as CSV

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