PREVIEW / futures_daily / 2019-04-04

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-04.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-04	ES	Futures	3111.71	3117.12	3101.18	3113.87	1045539.0
2019-04-04	NQ	Futures	8735.15	8754.45	8666.88	8712.4	432440.0
2019-04-04	YM	Futures	27752.7	27877.3	27651.4	27854.0	173294.0
2019-04-04	CL	Futures	64.18	64.45	63.55	63.77	684973.0
2019-04-04	GC	Futures	1611.0	1616.4	1599.2	1610.9	262537.0
2019-04-04	ZN	Futures	122.761893	123.026065	122.746354	122.87067	1191134.0
2019-04-04	A6	Futures	0.73456	0.7358	0.73271	0.73498	72747.0
2019-04-04	AD	Futures	0.75913	0.75928	0.75731	0.75827	48674.0
2019-04-04	B	Futures	50.58	51.01	50.16	50.55	281879.0
2019-04-04	B6	Futures	1.353	1.356	1.3425	1.3428	82889.0
2019-04-04	BR	Futures	0.20565	0.20705	0.20565	0.20705	44.0
2019-04-04	BTC	Futures	8050.0	8150.4	7385.6	7478.3	21775.0
2019-04-04	BZ	Futures	50.48	50.85	50.03	50.41	37531.0
2019-04-04	C	Futures	1586.0	1610.0	1577.0	1608.0	13995.0
2019-04-04	CB	Futures	276.33	277.527	276.091	276.181	28.0
2019-04-04	CC	Futures	1604.0	1623.0	1593.0	1616.0	41106.0
2019-04-04	CNH	Futures	6.7228	6.7348	6.7228	6.7233	147.0
2019-04-04	CSC	Futures	2.871	2.878	2.856	2.87	28.0
2019-04-04	CT	Futures	81.59	82.6	81.59	82.09	14261.0
2019-04-04	DC	Futures	24.2	24.34	24.17	24.25	215.0
2019-04-04	DX	Futures	92.612	92.923	92.598	92.904	16275.0
2019-04-04	E1	Futures	1.17811	1.17823	1.17449	1.17473	18955.0
2019-04-04	E6	Futures	1.2409	1.24189	1.23728	1.23887	129698.0
2019-04-04	E7	Futures	1.2347	1.2357	1.2312	1.2327	2548.0
2019-04-04	EBM	Futures	200.04	201.36	200.04	200.57	21034.0
2019-04-04	ED	Futures	95.1453	95.155	95.1453	95.1502	180977.0
2019-04-04	ER	Futures	98.416	98.421	98.416	98.416	59368.0
2019-04-04	EW	Futures	2050.3	2059.2	2045.5	2057.2	9656.0
2019-04-04	FBON	Futures	134.55	134.94	134.51	134.94	436.0
2019-04-04	FBTP	Futures	114.2	114.74	113.94	114.69	79674.0
2019-04-04	FBTS	Futures	105.56	105.636	105.455	105.617	58244.0
2019-04-04	FCE	Futures	4864.8	4874.2	4850.1	4863.9	57617.0
2019-04-04	FDAX	Futures	12600.6	12687.4	12559.0	12646.9	100451.0
2019-04-04	FDXM	Futures	12485.7	12577.5	12451.2	12537.3	48297.0
2019-04-04	FESX	Futures	2935.7	2948.8	2926.9	2943.5	868281.0
2019-04-04	FGBL	Futures	159.52	159.89	159.43	159.75	596502.0
2019-04-04	FGBM	Futures	132.91	133.04	132.89	132.96	434520.0
2019-04-04	FGBS	Futures	112.764	112.779	112.754	112.764	231587.0
2019-04-04	FGBX	Futures	193.1	194.06	192.1	193.94	55992.0
2019-04-04	FMWO	Futures	7184.9	7198.8	7182.6	7189.5	3059.0
2019-04-04	FOAT	Futures	146.32	146.79	146.25	146.66	196315.0
2019-04-04	FTDX	Futures	2729.4	2740.2	2726.9	2727.9	91.0
2019-04-04	FTI	Futures	524.91	526.6	523.88	525.69	17749.0
2019-04-04	FTUK	Futures	6725.2	6745.4	6699.0	6733.0	91800.0
2019-04-04	FVSA	Futures	243.57	246.83	240.31	243.57	23356.0
2019-04-04	FXXP	Futures	341.3	342.0	340.7	341.4	56295.0
2019-04-04	G	Futures	118.35	118.51	118.25	118.37	158491.0
2019-04-04	GF	Futures	310.092	314.583	309.878	312.926	2796.0
2019-04-04	GSCI	Futures	503.3	503.92	501.43	503.92	5.0
2019-04-04	HE	Futures	85.911	90.033	85.911	89.688	1096.0

> showing 50 of 114 rows — these rows as CSV

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