PREVIEW / futures_daily / 2019-05-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-05-24.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-05-24	ES	Futures	3047.98	3069.86	3045.28	3058.79	1201967.0
2019-05-24	NQ	Futures	8430.39	8502.98	8411.67	8428.95	407810.0
2019-05-24	YM	Futures	26910.4	27089.8	26871.3	27043.4	201024.0
2019-05-24	CL	Futures	59.74	60.66	59.01	60.17	758099.0
2019-05-24	GC	Futures	1604.2	1605.9	1600.3	1604.6	77728.0
2019-05-24	ZN	Futures	124.253684	124.393539	124.160447	124.207065	2851424.0
2019-05-24	A6	Futures	0.71168	0.71529	0.70972	0.71343	91429.0
2019-05-24	AD	Futures	0.75074	0.75317	0.75024	0.75251	60023.0
2019-05-24	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-05-24	B	Futures	50.1	51.07	49.61	50.62	292087.0
2019-05-24	B6	Futures	1.2982	1.3057	1.2969	1.3037	123594.0
2019-05-24	BR	Futures	0.197	0.19732	0.197	0.19732	85.0
2019-05-24	BTC	Futures	12078.1	12654.3	12047.3	12439.2	427.0
2019-05-24	BZ	Futures	49.07	49.99	48.66	49.58	46818.0
2019-05-24	C	Futures	1721.0	1742.0	1715.0	1737.0	5860.0
2019-05-24	CB	Futures	285.56	285.56	284.918	285.444	23.0
2019-05-24	CC	Futures	1637.0	1668.0	1633.0	1661.0	18281.0
2019-05-24	CNH	Futures	6.9397	6.9447	6.9223	6.9259	583.0
2019-05-24	CSC	Futures	2.994	2.994	2.959	2.966	66.0
2019-05-24	CT	Futures	70.5	71.8	70.5	71.59	13422.0
2019-05-24	DC	Futures	25.18	25.3	24.97	24.98	267.0
2019-05-24	DX	Futures	93.666	93.719	93.369	93.433	9772.0
2019-05-24	E1	Futures	1.16539	1.16843	1.16446	1.16749	22912.0
2019-05-24	E6	Futures	1.22948	1.23283	1.22894	1.23206	151706.0
2019-05-24	E7	Futures	1.2234	1.2266	1.2229	1.2259	3668.0
2019-05-24	EBM	Futures	201.52	205.26	201.23	204.97	13539.0
2019-05-24	ED	Futures	95.1917	95.1941	95.1819	95.1819	155405.0
2019-05-24	ER	Futures	98.421	98.421	98.416	98.421	18438.0
2019-05-24	EW	Futures	1967.9	1983.6	1964.8	1977.4	11668.0
2019-05-24	FBON	Futures	138.09	138.42	138.05	138.37	473.0
2019-05-24	FBTP	Futures	115.4	116.25	115.38	116.24	132099.0
2019-05-24	FBTS	Futures	105.789	106.046	105.77	106.017	67363.0
2019-05-24	FCE	Futures	4773.5	4803.5	4762.6	4784.4	62525.0
2019-05-24	FDAX	Futures	12593.8	12714.3	12590.1	12634.3	100159.0
2019-05-24	FDXM	Futures	12476.3	12603.6	12476.3	12524.8	39688.0
2019-05-24	FESX	Futures	2899.0	2929.6	2898.1	2914.7	809712.0
2019-05-24	FGBL	Futures	161.45	161.5	161.28	161.41	525059.0
2019-05-24	FGBM	Futures	133.61	133.65	133.56	133.6	306606.0
2019-05-24	FGBS	Futures	112.87	112.875	112.855	112.865	168995.0
2019-05-24	FGBX	Futures	197.88	198.05	197.17	197.76	34451.0
2019-05-24	FMWO	Futures	7037.9	7069.2	7032.1	7034.5	2550.0
2019-05-24	FOAT	Futures	147.82	148.01	147.77	147.9	94576.0
2019-05-24	FTDX	Futures	2848.8	2852.3	2790.1	2804.9	84.0
2019-05-24	FTI	Futures	514.28	518.05	513.43	515.86	23346.0
2019-05-24	FTUK	Futures	6612.4	6687.6	6611.9	6661.4	79685.0
2019-05-24	FVSA	Futures	228.1	233.09	223.12	230.24	17921.0
2019-05-24	FXXP	Futures	334.8	336.6	334.1	335.4	46108.0
2019-05-24	G	Futures	118.87	119.03	118.68	118.95	405912.0
2019-05-24	GF	Futures	280.672	283.174	279.789	281.064	4873.0
2019-05-24	GSCI	Futures	481.68	483.04	478.29	482.76	50.0

> showing 50 of 119 rows — these rows as CSV

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