PREVIEW / futures_daily / 2019-09-25

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-25.parquet
  size:    10 KB
  rows:    120

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-09-25	ES	Futures	3216.31	3238.77	3197.63	3232.82	1501723.0
2019-09-25	NQ	Futures	8917.72	9039.88	8831.0	9012.22	540081.0
2019-09-25	YM	Futures	28169.0	28360.1	28045.2	28300.3	199414.0
2019-09-25	CL	Futures	58.21	58.54	57.03	58.0	563550.0
2019-09-25	GC	Futures	1899.4	1903.1	1859.5	1865.5	481457.0
2019-09-25	ZN	Futures	129.403231	129.57356	128.721917	128.783855	1777604.0
2019-09-25	A6	Futures	0.69937	0.69999	0.69332	0.69496	92191.0
2019-09-25	AD	Futures	0.76207	0.76207	0.75899	0.76076	67848.0
2019-09-25	ALI	Futures	2133.27	2135.38	2132.96	2135.38	21.0
2019-09-25	B	Futures	48.74	48.96	47.77	48.66	295095.0
2019-09-25	B6	Futures	1.2744	1.2744	1.2595	1.2598	128420.0
2019-09-25	BR	Futures	0.19206	0.1936	0.19206	0.1936	31.0
2019-09-25	BTC	Futures	12505.7	12678.3	11880.1	12088.6	1667.0
2019-09-25	BZ	Futures	48.01	48.24	47.11	47.98	30213.0
2019-09-25	C	Futures	1647.0	1690.0	1646.0	1689.0	12687.0
2019-09-25	CB	Futures	255.364	257.017	255.364	255.659	27.0
2019-09-25	CC	Futures	1601.0	1626.0	1598.0	1620.0	18577.0
2019-09-25	CNH	Futures	7.1069	7.1347	7.1039	7.1246	843.0
2019-09-25	CSC	Futures	3.107	3.132	3.107	3.117	60.0
2019-09-25	CT	Futures	59.07	59.08	58.04	58.84	10102.0
2019-09-25	DC	Futures	26.21	26.42	26.18	26.24	206.0
2019-09-25	DX	Futures	94.71	95.387	94.686	95.357	17348.0
2019-09-25	E1	Futures	1.1744	1.17555	1.16703	1.16726	28387.0
2019-09-25	E6	Futures	1.20152	1.20179	1.19263	1.19307	175587.0
2019-09-25	E7	Futures	1.1955	1.1956	1.1864	1.1869	3680.0
2019-09-25	EBM	Futures	186.61	187.43	186.33	186.88	18625.0
2019-09-25	ED	Futures	95.2694	95.284	95.2354	95.2403	327798.0
2019-09-25	ER	Futures	98.45	98.455	98.445	98.45	62089.0
2019-09-25	EW	Futures	2025.4	2051.8	2013.9	2048.0	12270.0
2019-09-25	FBON	Futures	146.6	146.82	146.09	146.23	76.0
2019-09-25	FBTP	Futures	132.5	132.91	132.26	132.49	86567.0
2019-09-25	FBTS	Futures	108.481	108.558	108.452	108.51	36273.0
2019-09-25	FCE	Futures	5076.7	5077.1	4999.7	5047.2	94224.0
2019-09-25	FDAX	Futures	12933.0	12960.5	12795.9	12893.0	116515.0
2019-09-25	FDIV	Futures	146.97	147.11	146.14	147.11	70.0
2019-09-25	FDXM	Futures	12763.1	12790.2	12627.8	12724.6	44582.0
2019-09-25	FESX	Futures	3076.4	3082.5	3037.8	3063.2	1132080.0
2019-09-25	FGBL	Futures	168.94	169.02	168.02	168.43	693102.0
2019-09-25	FGBM	Futures	135.13	135.19	134.97	135.06	371258.0
2019-09-25	FGBS	Futures	112.971	112.976	112.946	112.951	222500.0
2019-09-25	FGBX	Futures	228.25	229.89	225.85	227.61	52578.0
2019-09-25	FMWO	Futures	7284.6	7290.3	7217.5	7257.3	2574.0
2019-09-25	FOAT	Futures	155.45	155.73	154.84	155.17	127177.0
2019-09-25	FTDX	Futures	2794.0	2794.0	2734.8	2752.1	134.0
2019-09-25	FTI	Futures	543.43	545.42	537.98	543.71	31670.0
2019-09-25	FTUK	Futures	6708.3	6744.4	6649.4	6717.1	96226.0
2019-09-25	FVSA	Futures	189.74	198.72	189.18	193.67	42695.0
2019-09-25	FXXP	Futures	349.7	350.3	346.0	348.8	52420.0
2019-09-25	G	Futures	122.55	122.99	122.24	122.65	227174.0
2019-09-25	GF	Futures	296.715	298.442	294.988	298.18	3204.0

> showing 50 of 120 rows — these rows as CSV

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