PREVIEW / futures_daily / 2019-10-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-23.parquet
  size:    10 KB
  rows:    122

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-10-23	ES	Futures	3239.04	3254.2	3228.22	3253.93	1055958.0
2019-10-23	NQ	Futures	9042.18	9125.16	9000.69	9105.85	348671.0
2019-10-23	YM	Futures	28084.0	28189.0	27911.8	28136.5	147111.0
2019-10-23	CL	Futures	55.47	57.28	54.78	57.18	620202.0
2019-10-23	GC	Futures	1839.3	1849.6	1838.9	1845.0	244615.0
2019-10-23	ZN	Futures	128.706433	128.969668	128.598042	128.690948	887398.0
2019-10-23	A6	Futures	0.7042	0.70512	0.70225	0.7042	64101.0
2019-10-23	AD	Futures	0.76967	0.77113	0.76871	0.77063	55778.0
2019-10-23	ALI	Futures	2097.75	2109.89	2097.75	2109.89	25.0
2019-10-23	B	Futures	47.12	48.56	46.62	48.46	313229.0
2019-10-23	B6	Futures	1.3111	1.3162	1.308	1.3146	104153.0
2019-10-23	BFX	Futures	4514.8	4529.9	4514.8	4529.9	6.0
2019-10-23	BR	Futures	0.19784	0.20015	0.19724	0.19986	1759.0
2019-10-23	BTC	Futures	11621.2	11664.3	10420.2	10751.0	5767.0
2019-10-23	BZ	Futures	46.58	47.88	45.97	47.78	37010.0
2019-10-23	C	Futures	1654.0	1669.0	1641.0	1668.0	6950.0
2019-10-23	CB	Futures	243.939	244.5	242.168	243.555	39.0
2019-10-23	CC	Futures	1612.0	1621.0	1586.0	1612.0	19743.0
2019-10-23	CNH	Futures	7.0714	7.0783	7.0538	7.055	365.0
2019-10-23	CSC	Futures	3.286	3.303	3.286	3.292	41.0
2019-10-23	CT	Futures	62.73	63.45	62.69	63.22	12477.0
2019-10-23	DC	Futures	27.59	27.63	27.44	27.48	289.0
2019-10-23	DX	Futures	93.975	94.13	93.898	93.981	10405.0
2019-10-23	E1	Futures	1.16749	1.16818	1.16485	1.16588	19494.0
2019-10-23	E6	Futures	1.21019	1.21182	1.20808	1.21052	115184.0
2019-10-23	E7	Futures	1.204	1.2055	1.2018	1.2043	1879.0
2019-10-23	EBM	Futures	198.37	198.65	197.28	198.1	29012.0
2019-10-23	ED	Futures	95.3569	95.3618	95.3375	95.3423	186426.0
2019-10-23	ER	Futures	98.406	98.416	98.406	98.406	45124.0
2019-10-23	EW	Futures	2044.1	2050.0	2038.0	2047.1	5600.0
2019-10-23	FBON	Futures	145.2	145.43	145.12	145.13	194.0
2019-10-23	FBTP	Futures	131.77	131.94	131.18	131.38	79406.0
2019-10-23	FBTS	Futures	108.539	108.539	108.346	108.394	36709.0
2019-10-23	FCE	Futures	5104.2	5135.1	5094.2	5129.2	58109.0
2019-10-23	FDAX	Futures	13363.6	13519.7	13337.7	13504.9	89223.0
2019-10-23	FDIV	Futures	156.76	157.36	156.67	157.32	190.0
2019-10-23	FDXM	Futures	13197.4	13343.2	13166.2	13328.6	34379.0
2019-10-23	FESX	Futures	3128.1	3157.9	3125.5	3155.3	671718.0
2019-10-23	FEU3	Futures	99.114	99.114	99.109	99.109	200.0
2019-10-23	FGBL	Futures	165.84	166.09	165.61	165.84	491291.0
2019-10-23	FGBM	Futures	134.16	134.28	134.11	134.15	329726.0
2019-10-23	FGBS	Futures	112.795	112.8	112.764	112.769	204805.0
2019-10-23	FGBX	Futures	216.61	218.54	216.52	217.87	36857.0
2019-10-23	FMWO	Futures	7329.0	7365.4	7324.4	7360.8	1442.0
2019-10-23	FOAT	Futures	153.17	153.49	153.06	153.23	87798.0
2019-10-23	FTDX	Futures	2759.5	2769.3	2748.6	2766.4	50.0
2019-10-23	FTI	Futures	545.35	548.74	544.87	547.6	24707.0
2019-10-23	FTUK	Futures	6654.5	6712.4	6638.3	6709.2	95493.0
2019-10-23	FVSA	Futures	166.18	167.24	159.81	160.87	18470.0
2019-10-23	FXXP	Futures	354.4	356.7	354.2	356.5	39437.0

> showing 50 of 122 rows — these rows as CSV

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