PREVIEW / futures_daily / 2019-07-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-18.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-07-18	ES	Futures	3216.4	3242.84	3209.65	3234.47	1345038.0
2019-07-18	NQ	Futures	9058.62	9158.5	9018.33	9134.03	413722.0
2019-07-18	YM	Futures	28522.9	28669.9	28410.5	28561.7	190637.0
2019-07-18	CL	Futures	57.88	58.62	55.97	56.55	764491.0
2019-07-18	GC	Futures	1777.9	1804.3	1761.9	1777.4	481325.0
2019-07-18	ZN	Futures	126.864893	127.222609	126.647152	127.051527	1741787.0
2019-07-18	A6	Futures	0.7226	0.72919	0.72188	0.72837	96965.0
2019-07-18	AD	Futures	0.77325	0.77466	0.77048	0.77355	68602.0
2019-07-18	ALI	Futures	2280.99	2293.82	2280.99	2283.13	27.0
2019-07-18	B	Futures	47.75	48.46	46.08	46.56	374891.0
2019-07-18	B6	Futures	1.2729	1.2853	1.272	1.2837	123852.0
2019-07-18	BR	Futures	0.2133	0.21358	0.21274	0.21346	76.0
2019-07-18	BTC	Futures	13753.9	15153.8	13082.0	14768.8	8514.0
2019-07-18	BZ	Futures	47.23	47.85	45.5	45.97	48628.0
2019-07-18	C	Futures	1723.0	1748.0	1723.0	1725.0	4664.0
2019-07-18	CB	Futures	291.162	291.162	289.44	289.732	96.0
2019-07-18	CC	Futures	1620.0	1638.0	1618.0	1625.0	10255.0
2019-07-18	CNH	Futures	6.8791	6.8883	6.8756	6.8773	717.0
2019-07-18	CSC	Futures	3.127	3.144	3.117	3.125	90.0
2019-07-18	CT	Futures	60.83	60.83	60.02	60.02	34.0
2019-07-18	DC	Futures	26.36	26.49	26.24	26.3	468.0
2019-07-18	DX	Futures	93.253	93.325	92.738	92.862	22352.0
2019-07-18	E1	Futures	1.18151	1.18835	1.17849	1.18603	26019.0
2019-07-18	E6	Futures	1.23045	1.23613	1.22794	1.23482	206122.0
2019-07-18	E7	Futures	1.2239	1.2296	1.2216	1.2284	3548.0
2019-07-18	EBM	Futures	203.25	203.25	200.94	201.23	21279.0
2019-07-18	ED	Futures	95.3525	95.4061	95.3233	95.3866	501237.0
2019-07-18	ER	Futures	98.533	98.563	98.529	98.529	188298.0
2019-07-18	EW	Futures	2034.0	2049.9	2029.3	2043.8	10558.0
2019-07-18	FBON	Futures	142.81	143.4	142.76	143.12	1104.0
2019-07-18	FBTP	Futures	125.04	125.97	124.91	125.33	95720.0
2019-07-18	FBTS	Futures	107.686	107.782	107.628	107.705	64121.0
2019-07-18	FCE	Futures	5046.4	5088.3	5035.9	5055.5	87693.0
2019-07-18	FDAX	Futures	12918.6	12942.8	12827.0	12873.8	120845.0
2019-07-18	FDIV	Futures	145.77	145.77	145.58	145.58	21.0
2019-07-18	FDXM	Futures	12766.2	12783.9	12668.4	12715.2	45137.0
2019-07-18	FESX	Futures	3040.5	3052.7	3023.0	3037.0	1047750.0
2019-07-18	FGBL	Futures	164.61	165.1	164.52	164.74	630896.0
2019-07-18	FGBM	Futures	134.56	134.77	134.52	134.61	444898.0
2019-07-18	FGBS	Futures	113.091	113.131	113.066	113.086	306430.0
2019-07-18	FGBX	Futures	209.05	210.23	208.44	209.16	42258.0
2019-07-18	FMWO	Futures	7379.8	7421.4	7366.0	7379.8	2470.0
2019-07-18	FOAT	Futures	151.87	152.31	151.83	152.03	111538.0
2019-07-18	FTDX	Futures	2802.4	2812.8	2791.5	2800.4	125.0
2019-07-18	FTI	Futures	537.39	541.61	537.01	539.33	23299.0
2019-07-18	FTUK	Futures	6874.8	6885.9	6846.6	6859.1	81351.0
2019-07-18	FVSA	Futures	179.93	181.16	174.98	178.69	44473.0
2019-07-18	FXXP	Futures	343.9	346.6	343.8	345.5	54182.0
2019-07-18	G	Futures	120.83	120.94	120.51	120.66	164949.0
2019-07-18	GF	Futures	277.238	277.434	272.871	273.607	3300.0

> showing 50 of 119 rows — these rows as CSV

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