PREVIEW / futures_daily / 2019-08-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-09.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-09	ES	Futures	3159.48	3167.84	3128.19	3150.58	2026304.0
2019-08-09	NQ	Futures	8864.62	8892.83	8746.33	8819.44	619044.0
2019-08-09	YM	Futures	27601.0	27714.4	27378.4	27582.1	260221.0
2019-08-09	CL	Futures	53.96	56.04	53.44	55.61	726386.0
2019-08-09	GC	Futures	1869.9	1876.4	1858.0	1860.8	332605.0
2019-08-09	ZN	Futures	129.400013	129.664412	128.948979	129.088955	1594152.0
2019-08-09	A6	Futures	0.70049	0.70224	0.69843	0.69956	81596.0
2019-08-09	AD	Futures	0.76222	0.76428	0.75975	0.76363	76102.0
2019-08-09	ALI	Futures	2197.01	2200.67	2185.1	2189.98	280.0
2019-08-09	B	Futures	43.56	44.58	43.08	44.15	281803.0
2019-08-09	B6	Futures	1.2411	1.2419	1.2294	1.2323	100804.0
2019-08-09	BR	Futures	0.20359	0.20359	0.20183	0.20219	3505.0
2019-08-09	BTC	Futures	16322.3	16845.5	16239.7	16446.2	3517.0
2019-08-09	BZ	Futures	42.93	44.01	42.53	43.58	34015.0
2019-08-09	C	Futures	1628.0	1636.0	1624.0	1624.0	5241.0
2019-08-09	CB	Futures	274.532	275.699	274.532	275.699	10.0
2019-08-09	CC	Futures	1479.0	1483.0	1469.0	1471.0	30364.0
2019-08-09	CNH	Futures	7.0874	7.1139	7.0777	7.1014	701.0
2019-08-09	CSC	Futures	3.107	3.12	3.104	3.117	24.0
2019-08-09	CT	Futures	58.26	58.61	58.03	58.31	17.0
2019-08-09	DC	Futures	26.11	26.27	26.1	26.23	155.0
2019-08-09	DX	Futures	93.782	93.84	93.561	93.702	15800.0
2019-08-09	E1	Futures	1.19461	1.19832	1.19287	1.1967	22047.0
2019-08-09	E6	Futures	1.22418	1.22762	1.22331	1.22587	129361.0
2019-08-09	E7	Futures	1.2179	1.2213	1.2169	1.2195	3155.0
2019-08-09	EBM	Futures	195.47	197.49	195.47	196.34	15830.0
2019-08-09	ED	Futures	95.4207	95.4499	95.3915	95.4061	234007.0
2019-08-09	ER	Futures	98.553	98.553	98.543	98.548	43838.0
2019-08-09	EW	Futures	2015.4	2020.1	1990.7	1997.3	12996.0
2019-08-09	FBON	Futures	145.27	145.46	144.68	144.74	263.0
2019-08-09	FBTP	Futures	124.75	124.79	122.98	123.1	186175.0
2019-08-09	FBTS	Futures	107.111	107.312	106.622	106.775	122935.0
2019-08-09	FCE	Futures	4877.0	4897.5	4842.8	4852.4	87652.0
2019-08-09	FDAX	Futures	12440.5	12481.0	12279.9	12288.3	108164.0
2019-08-09	FDIV	Futures	141.82	141.82	140.48	140.57	135.0
2019-08-09	FDXM	Futures	12282.6	12327.3	12129.7	12137.0	57217.0
2019-08-09	FESX	Futures	2934.8	2939.2	2900.8	2901.6	1028319.0
2019-08-09	FGBL	Futures	168.78	168.83	168.26	168.45	535282.0
2019-08-09	FGBM	Futures	135.76	135.77	135.63	135.67	291056.0
2019-08-09	FGBS	Futures	113.328	113.328	113.303	113.308	245798.0
2019-08-09	FGBX	Futures	224.76	225.48	222.82	223.89	49211.0
2019-08-09	FMWO	Futures	7213.7	7214.8	7151.4	7151.4	1743.0
2019-08-09	FOAT	Futures	155.07	155.07	154.47	154.51	118147.0
2019-08-09	FTDX	Futures	2801.4	2803.4	2744.2	2745.6	87.0
2019-08-09	FTI	Futures	517.64	519.35	512.14	513.64	28976.0
2019-08-09	FTUK	Futures	6686.5	6710.9	6646.8	6651.4	108603.0
2019-08-09	FVSA	Futures	212.69	221.97	209.6	220.73	34101.0
2019-08-09	FXXP	Futures	334.2	335.5	331.7	331.8	60452.0
2019-08-09	G	Futures	123.45	123.71	123.25	123.48	156871.0
2019-08-09	GF	Futures	274.49	275.275	272.086	272.577	968.0

> showing 50 of 119 rows — these rows as CSV

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