PREVIEW / futures_daily / 2019-04-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-29.parquet
  size:    10 KB
  rows:    114

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-29	ES	Futures	3174.9	3188.14	3173.28	3178.96	944846.0
2019-04-29	NQ	Futures	9030.12	9065.26	8993.53	9003.04	320324.0
2019-04-29	YM	Futures	27972.3	28060.9	27955.4	28022.9	117095.0
2019-04-29	CL	Futures	64.63	65.39	64.13	65.19	654076.0
2019-04-29	GC	Futures	1604.3	1604.4	1593.0	1595.0	208956.0
2019-04-29	ZN	Futures	122.994986	123.026065	122.715275	122.761893	918956.0
2019-04-29	A6	Futures	0.72652	0.72869	0.72632	0.72828	57759.0
2019-04-29	AD	Futures	0.7518	0.75312	0.75089	0.75266	47366.0
2019-04-29	B	Futures	52.38	53.05	52.05	52.72	351734.0
2019-04-29	B6	Futures	1.3267	1.3297	1.3253	1.3284	61646.0
2019-04-29	BR	Futures	0.20304	0.20364	0.2024	0.20264	3333.0
2019-04-29	BTC	Futures	7879.4	8018.5	7840.7	7949.0	3421.0
2019-04-29	BZ	Futures	52.4	52.91	51.92	52.57	39955.0
2019-04-29	C	Futures	1671.0	1699.0	1668.0	1698.0	4063.0
2019-04-29	CB	Futures	279.62	280.218	279.62	279.919	31.0
2019-04-29	CC	Futures	1570.0	1606.0	1561.0	1604.0	19641.0
2019-04-29	CNH	Futures	6.747	6.7538	6.7422	6.7477	558.0
2019-04-29	CSC	Futures	2.989	2.992	2.973	2.98	90.0
2019-04-29	CT	Futures	81.33	81.74	80.44	80.55	13724.0
2019-04-29	DC	Futures	25.13	25.13	24.97	25.07	223.0
2019-04-29	DX	Futures	93.695	93.781	93.499	93.533	8419.0
2019-04-29	E1	Futures	1.14987	1.15092	1.14754	1.1494	22632.0
2019-04-29	E6	Futures	1.22839	1.23289	1.22817	1.23239	150906.0
2019-04-29	E7	Futures	1.2226	1.2268	1.2221	1.2263	3460.0
2019-04-29	EBM	Futures	194.48	195.01	193.69	194.75	14047.0
2019-04-29	ED	Futures	95.1599	95.1648	95.1502	95.1599	152470.0
2019-04-29	ER	Futures	98.416	98.416	98.411	98.416	19019.0
2019-04-29	EW	Futures	2097.0	2104.2	2094.1	2097.9	7786.0
2019-04-29	FBON	Futures	135.8	136.21	135.8	136.17	566.0
2019-04-29	FBTP	Futures	115.83	116.11	115.38	115.59	62527.0
2019-04-29	FBTS	Futures	105.874	105.969	105.779	105.836	34276.0
2019-04-29	FCE	Futures	4979.4	4994.7	4951.1	4983.0	58258.0
2019-04-29	FDAX	Futures	12984.3	13049.0	12930.1	12991.7	82741.0
2019-04-29	FDIV	Futures	149.99	149.99	149.71	149.76	120.0
2019-04-29	FDXM	Futures	12884.3	12936.5	12818.5	12879.1	32036.0
2019-04-29	FESX	Futures	3003.0	3015.2	2989.0	3006.5	683619.0
2019-04-29	FGBL	Futures	160.02	160.06	159.57	159.78	523115.0
2019-04-29	FGBM	Futures	133.12	133.12	132.95	133.03	354957.0
2019-04-29	FGBS	Futures	112.779	112.779	112.744	112.759	226160.0
2019-04-29	FGBX	Futures	194.14	194.14	192.49	193.36	27398.0
2019-04-29	FMWO	Futures	7307.5	7323.7	7291.3	7309.8	1058.0
2019-04-29	FOAT	Futures	146.83	146.89	146.48	146.77	96013.0
2019-04-29	FTDX	Futures	2863.1	2872.0	2853.7	2864.1	272.0
2019-04-29	FTI	Futures	535.09	536.42	532.86	535.42	17665.0
2019-04-29	FTUK	Futures	6781.6	6798.1	6746.7	6780.2	65511.0
2019-04-29	FVSA	Futures	197.6	199.7	194.11	194.81	25995.0
2019-04-29	FXXP	Futures	346.2	347.0	344.7	346.2	22640.0
2019-04-29	G	Futures	117.7	117.79	117.57	117.74	125417.0
2019-04-29	GF	Futures	300.632	301.153	297.718	298.55	2375.0
2019-04-29	GSCI	Futures	498.64	503.04	498.64	502.02	64.0

> showing 50 of 114 rows — these rows as CSV

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