PREVIEW / futures_daily / 2019-11-04

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-04.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-11-04	ES	Futures	3317.8	3338.37	3317.8	3329.71	1179714.0
2019-11-04	NQ	Futures	9409.52	9488.74	9408.36	9468.0	325479.0
2019-11-04	YM	Futures	28636.2	28816.8	28632.0	28743.3	135057.0
2019-11-04	CL	Futures	57.63	58.67	57.04	57.76	580350.0
2019-11-04	GC	Futures	1870.6	1871.4	1858.3	1864.0	260197.0
2019-11-04	ZN	Futures	128.861277	128.90773	128.365776	128.412229	1107605.0
2019-11-04	A6	Futures	0.70984	0.71138	0.70645	0.70697	82606.0
2019-11-04	AD	Futures	0.76655	0.7672	0.76549	0.76615	49999.0
2019-11-04	ALI	Futures	2173.95	2209.77	2170.0	2209.77	61.0
2019-11-04	B	Futures	49.29	50.07	48.88	49.56	235379.0
2019-11-04	B6	Futures	1.3171	1.3177	1.3108	1.3112	64864.0
2019-11-04	BR	Futures	0.20221	0.20301	0.20083	0.20136	7022.0
2019-11-04	BTC	Futures	13386.5	14137.4	13242.1	13812.5	3453.0
2019-11-04	BZ	Futures	48.78	49.39	48.22	48.88	28961.0
2019-11-04	C	Futures	1661.0	1688.0	1661.0	1680.0	6852.0
2019-11-04	CB	Futures	246.655	246.684	246.625	246.684	3.0
2019-11-04	CC	Futures	1626.0	1652.0	1622.0	1639.0	28996.0
2019-11-04	CNH	Futures	7.0292	7.0327	7.0154	7.0271	560.0
2019-11-04	CSC	Futures	3.534	3.556	3.531	3.543	134.0
2019-11-04	CT	Futures	63.01	63.25	61.85	61.97	24139.0
2019-11-04	DC	Futures	29.58	29.7	29.45	29.57	537.0
2019-11-04	DX	Futures	93.782	94.12	93.729	94.107	11560.0
2019-11-04	E1	Futures	1.17037	1.17083	1.16657	1.16772	23748.0
2019-11-04	E6	Futures	1.2135	1.21453	1.209	1.20933	150669.0
2019-11-04	E7	Futures	1.2072	1.2082	1.2028	1.2031	2195.0
2019-11-04	EBM	Futures	194.82	194.82	193.18	193.45	21157.0
2019-11-04	ED	Futures	95.3326	95.3326	95.3132	95.3229	192542.0
2019-11-04	ER	Futures	98.406	98.411	98.401	98.401	34836.0
2019-11-04	EW	Futures	2083.2	2099.7	2083.2	2095.3	11628.0
2019-11-04	FBON	Futures	144.75	144.75	144.33	144.47	501.0
2019-11-04	FBTP	Futures	130.65	130.87	130.31	130.82	69803.0
2019-11-04	FBTS	Futures	108.307	108.385	108.24	108.365	26725.0
2019-11-04	FCE	Futures	5254.0	5293.9	5244.0	5284.9	68766.0
2019-11-04	FDAX	Futures	13701.2	13892.7	13685.9	13842.6	96285.0
2019-11-04	FDIV	Futures	160.19	160.7	160.19	160.57	140.0
2019-11-04	FDXM	Futures	13505.6	13710.8	13504.6	13661.8	39762.0
2019-11-04	FESX	Futures	3180.7	3215.0	3176.4	3207.1	915774.0
2019-11-04	FGBL	Futures	165.64	165.64	165.1	165.18	449131.0
2019-11-04	FGBM	Futures	134.13	134.15	134.02	134.04	295453.0
2019-11-04	FGBS	Futures	112.749	112.759	112.734	112.739	130679.0
2019-11-04	FGBX	Futures	216.48	216.48	214.03	214.28	36133.0
2019-11-04	FMWO	Futures	7522.3	7556.4	7517.8	7543.9	3780.0
2019-11-04	FOAT	Futures	152.91	152.95	152.47	152.63	91265.0
2019-11-04	FTDX	Futures	2816.2	2847.8	2810.8	2842.9	129.0
2019-11-04	FTI	Futures	555.51	559.19	554.85	557.69	25508.0
2019-11-04	FTUK	Futures	6766.2	6831.1	6756.9	6805.1	85749.0
2019-11-04	FVSA	Futures	146.54	147.07	138.04	146.01	21510.0
2019-11-04	FXXP	Futures	362.6	364.9	361.7	364.2	68108.0
2019-11-04	G	Futures	121.19	121.26	120.67	120.81	128097.0
2019-11-04	GF	Futures	312.049	312.52	310.165	312.102	842.0

> showing 50 of 119 rows — these rows as CSV

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