PREVIEW / futures_daily / 2019-04-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-05.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-05	ES	Futures	3113.6	3130.35	3111.44	3128.19	1221029.0
2019-04-05	NQ	Futures	8716.43	8771.45	8706.06	8761.65	358710.0
2019-04-05	YM	Futures	27854.0	27981.8	27826.6	27860.4	157732.0
2019-04-05	CL	Futures	63.85	65.04	63.48	64.77	686862.0
2019-04-05	GC	Futures	1613.7	1615.3	1603.4	1612.5	231451.0
2019-04-05	ZN	Futures	122.839591	123.010525	122.590959	122.917288	1419966.0
2019-04-05	A6	Futures	0.73425	0.73632	0.73209	0.73333	86668.0
2019-04-05	AD	Futures	0.75812	0.75863	0.75534	0.7563	62725.0
2019-04-05	B	Futures	50.35	51.34	50.2	51.23	263869.0
2019-04-05	B6	Futures	1.3439	1.3488	1.335	1.3393	95946.0
2019-04-05	BTC	Futures	7625.1	7833.7	7555.6	7756.4	9560.0
2019-04-05	BZ	Futures	50.31	51.19	50.07	51.09	36491.0
2019-04-05	C	Futures	1607.0	1611.0	1583.0	1610.0	12600.0
2019-04-05	CB	Futures	276.36	277.527	276.33	277.228	31.0
2019-04-05	CC	Futures	1613.0	1627.0	1606.0	1623.0	37374.0
2019-04-05	CNH	Futures	6.7233	6.7281	6.7145	6.7188	79.0
2019-04-05	CSC	Futures	2.861	2.884	2.861	2.875	28.0
2019-04-05	CT	Futures	82.09	83.32	81.8	83.08	22971.0
2019-04-05	DC	Futures	24.31	24.37	24.28	24.31	139.0
2019-04-05	DX	Futures	92.9	93.048	92.689	92.978	10234.0
2019-04-05	E1	Futures	1.17531	1.17624	1.17321	1.17473	15831.0
2019-04-05	E6	Futures	1.23898	1.24249	1.23766	1.23848	133366.0
2019-04-05	E7	Futures	1.2328	1.236	1.2315	1.2324	3759.0
2019-04-05	EBM	Futures	199.78	200.57	199.51	200.31	12695.0
2019-04-05	ED	Futures	95.1453	95.1502	95.1404	95.1453	204620.0
2019-04-05	ER	Futures	98.416	98.421	98.416	98.416	43542.0
2019-04-05	EW	Futures	2056.3	2074.6	2055.0	2073.0	13577.0
2019-04-05	FBON	Futures	134.74	135.03	134.73	134.94	299.0
2019-04-05	FBTP	Futures	114.38	115.04	114.38	114.98	68503.0
2019-04-05	FBTS	Futures	105.541	105.712	105.503	105.684	41412.0
2019-04-05	FCE	Futures	4869.3	4886.7	4865.7	4875.5	65943.0
2019-04-05	FDAX	Futures	12663.2	12681.1	12620.6	12671.1	81716.0
2019-04-05	FDIV	Futures	147.16	147.76	147.16	147.76	7.0
2019-04-05	FDXM	Futures	12534.7	12591.1	12510.7	12561.3	33275.0
2019-04-05	FESX	Futures	2947.0	2951.4	2937.4	2948.8	780923.0
2019-04-05	FGBL	Futures	159.59	159.75	159.32	159.6	552916.0
2019-04-05	FGBM	Futures	132.92	132.97	132.83	132.91	344475.0
2019-04-05	FGBS	Futures	112.759	112.764	112.734	112.744	220157.0
2019-04-05	FGBX	Futures	193.45	194.1	192.55	193.69	38582.0
2019-04-05	FMWO	Futures	7204.5	7225.4	7201.1	7219.6	1127.0
2019-04-05	FOAT	Futures	146.42	146.83	146.32	146.73	118959.0
2019-04-05	FTDX	Futures	2733.3	2740.7	2732.3	2740.2	45.0
2019-04-05	FTI	Futures	526.41	527.4	525.47	526.65	17300.0
2019-04-05	FTUK	Futures	6737.1	6786.6	6728.8	6782.5	84968.0
2019-04-05	FVSA	Futures	241.12	244.38	236.24	237.05	24042.0
2019-04-05	FXXP	Futures	342.0	342.6	341.2	342.4	41194.0
2019-04-05	G	Futures	118.16	118.25	117.84	118.05	173594.0
2019-04-05	GF	Futures	312.658	314.69	310.948	312.552	1183.0
2019-04-05	GSCI	Futures	502.22	506.87	502.22	506.64	2295.0
2019-04-05	HE	Futures	90.354	92.082	87.688	89.861	529.0

> showing 50 of 114 rows — these rows as CSV

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