PREVIEW / futures_daily / 2019-04-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-24.parquet
  size:    10 KB
  rows:    115

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-04-24	ES	Futures	3172.74	3175.44	3162.48	3165.72	1125250.0
2019-04-24	NQ	Futures	9025.8	9047.98	8989.79	9042.21	387633.0
2019-04-24	YM	Futures	28131.6	28177.0	27991.3	28015.5	139857.0
2019-04-24	CL	Futures	67.93	68.2	67.41	67.65	678386.0
2019-04-24	GC	Futures	1586.1	1594.0	1581.3	1592.4	246046.0
2019-04-24	ZN	Futures	122.466643	122.901749	122.435564	122.85513	1330691.0
2019-04-24	A6	Futures	0.7326	0.73281	0.72281	0.72292	142815.0
2019-04-24	AD	Futures	0.75362	0.75398	0.74852	0.75024	126176.0
2019-04-24	B	Futures	54.1	54.43	53.91	54.31	276670.0
2019-04-24	B6	Futures	1.3281	1.3316	1.3237	1.3256	96337.0
2019-04-24	BR	Futures	0.20392	0.2042	0.19992	0.19996	3252.0
2019-04-24	BTC	Futures	8637.1	8691.3	8320.1	8405.2	1508.0
2019-04-24	BZ	Futures	53.98	54.28	53.75	54.17	46326.0
2019-04-24	C	Futures	1633.0	1644.0	1612.0	1627.0	4231.0
2019-04-24	CB	Futures	277.048	277.168	276.689	276.929	15.0
2019-04-24	CC	Futures	1542.0	1542.0	1504.0	1513.0	23671.0
2019-04-24	CNH	Futures	6.7378	6.7465	6.7294	6.7465	669.0
2019-04-24	CSC	Futures	2.917	2.922	2.901	2.92	64.0
2019-04-24	CT	Futures	81.29	81.57	80.65	80.73	16564.0
2019-04-24	DC	Futures	24.58	24.66	24.45	24.58	239.0
2019-04-24	DX	Futures	93.23	93.82	93.23	93.796	19996.0
2019-04-24	E1	Futures	1.14987	1.15337	1.14765	1.14789	29500.0
2019-04-24	E6	Futures	1.23755	1.23766	1.22828	1.22844	263952.0
2019-04-24	E7	Futures	1.2314	1.2315	1.2222	1.2223	4997.0
2019-04-24	EBM	Futures	192.63	193.69	191.84	192.1	19950.0
2019-04-24	ED	Futures	95.1404	95.1697	95.1404	95.1599	225493.0
2019-04-24	ER	Futures	98.416	98.421	98.411	98.416	70126.0
2019-04-24	EW	Futures	2096.6	2109.8	2090.8	2101.5	10244.0
2019-04-24	FBON	Futures	135.1	135.5	134.96	135.49	272.0
2019-04-24	FBTP	Futures	114.74	115.17	114.51	115.13	79575.0
2019-04-24	FBTS	Futures	105.703	105.731	105.608	105.722	39918.0
2019-04-24	FCE	Futures	4972.7	4989.3	4952.9	4970.0	71867.0
2019-04-24	FDAX	Futures	12905.3	13030.6	12859.6	12972.2	104181.0
2019-04-24	FDIV	Futures	149.9	150.22	149.2	149.43	156.0
2019-04-24	FDXM	Futures	12805.0	12917.7	12748.6	12859.8	42258.0
2019-04-24	FESX	Futures	3003.0	3011.7	2989.9	2998.6	829697.0
2019-04-24	FGBL	Futures	159.24	160.0	159.21	159.95	717025.0
2019-04-24	FGBM	Futures	132.8	133.07	132.78	133.05	411989.0
2019-04-24	FGBS	Futures	112.734	112.774	112.729	112.764	187617.0
2019-04-24	FGBX	Futures	191.71	194.33	191.69	194.02	37624.0
2019-04-24	FMWO	Futures	7286.7	7304.0	7277.4	7291.3	630.0
2019-04-24	FOAT	Futures	146.39	146.95	146.31	146.91	101014.0
2019-04-24	FTDX	Futures	2813.3	2867.6	2813.3	2850.8	153.0
2019-04-24	FTI	Futures	533.76	534.9	531.77	532.97	21289.0
2019-04-24	FTUK	Futures	6849.4	6849.4	6788.0	6799.5	85710.0
2019-04-24	FVSA	Futures	197.6	200.39	196.2	196.9	30538.0
2019-04-24	FXXP	Futures	345.3	346.5	344.7	345.4	40136.0
2019-04-24	G	Futures	117.11	117.54	117.1	117.54	202792.0
2019-04-24	GF	Futures	311.042	311.198	304.12	305.057	4609.0
2019-04-24	GSCI	Futures	515.68	515.68	513.31	513.53	8.0

> showing 50 of 115 rows — these rows as CSV

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