PREVIEW / futures_daily / 2018-04-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-20.parquet
  size:    9 KB
  rows:    111

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
2018-04-20	ES	Futures	2928.01	2934.26	2892.39	2905.17	1604973.0
2018-04-20	NQ	Futures	7932.9	7947.54	7778.7	7814.11	422339.0
2018-04-20	YM	Futures	25948.4	25982.1	25637.7	25737.7	201071.0
2018-04-20	CL	Futures	68.47	68.91	67.74	68.65	724906.0
2018-04-20	GC	Futures	1721.6	1722.1	1706.9	1708.6	282920.0
2018-04-20	ZN	Futures	118.950825	119.028368	118.578619	118.656162	1328046.0
2018-04-20	A6	Futures	0.79463	0.79483	0.78722	0.78846	104107.0
2018-04-20	AD	Futures	0.79957	0.80169	0.79304	0.79436	78409.0
2018-04-20	B	Futures	53.75	53.93	52.94	53.83	371895.0
2018-04-20	B6	Futures	1.462	1.4624	1.4529	1.4556	133382.0
2018-04-20	BR	Futures	0.22304	0.22304	0.2222	0.22281	35.0
2018-04-20	BTC	Futures	11787.3	12192.1	11695.0	12128.2	2318.0
2018-04-20	BZ	Futures	53.09	53.24	52.25	53.14	32478.0
2018-04-20	C	Futures	1718.0	1718.0	1656.0	1669.0	6046.0
2018-04-20	CB	Futures	293.756	295.887	293.756	295.763	25.0
2018-04-20	CC	Futures	2025.0	2038.0	1971.0	1990.0	23664.0
2018-04-20	CNH	Futures	6.3847	6.394	6.3817	6.3837	32.0
2018-04-20	CSC	Futures	3.419	3.423	3.4	3.4	34.0
2018-04-20	CT	Futures	95.41	98.43	95.41	98.24	5827.0
2018-04-20	DC	Futures	27.48	27.66	27.35	27.39	100.0
2018-04-20	DX	Futures	84.557	85.113	84.542	84.953	31758.0
2018-04-20	E1	Futures	1.24537	1.24621	1.23959	1.24103	24719.0
2018-04-20	E6	Futures	1.39629	1.3973	1.38553	1.3893	231789.0
2018-04-20	E7	Futures	1.3889	1.3897	1.3781	1.3819	3439.0
2018-04-20	EBM	Futures	175.86	176.13	175.05	175.05	16708.0
2018-04-20	ED	Futures	94.9306	94.9452	94.9257	94.9306	309453.0
2018-04-20	ER	Futures	98.337	98.342	98.337	98.342	15915.0
2018-04-20	EW	Futures	2026.8	2030.9	2009.1	2013.6	12036.0
2018-04-20	FBON	Futures	129.63	129.64	129.3	129.54	264.0
2018-04-20	FBTP	Futures	115.75	115.89	115.42	115.74	86609.0
2018-04-20	FBTS	Futures	104.213	104.26	104.176	104.241	51396.0
2018-04-20	FCE	Futures	4763.4	4787.9	4746.4	4775.4	70928.0
2018-04-20	FDAX	Futures	13074.8	13089.9	12987.6	13039.5	85970.0
2018-04-20	FDXM	Futures	12955.3	12972.8	12871.9	12923.4	27680.0
2018-04-20	FESX	Futures	2843.9	2858.9	2835.6	2848.1	863958.0
2018-04-20	FEU3	Futures	99.021	99.026	99.021	99.026	99.0
2018-04-20	FGBL	Futures	148.95	149.06	148.59	148.81	744536.0
2018-04-20	FGBM	Futures	129.35	129.42	129.23	129.36	460282.0
2018-04-20	FGBS	Futures	112.472	112.487	112.452	112.477	284030.0
2018-04-20	FGBX	Futures	168.71	168.92	167.68	168.17	57256.0
2018-04-20	FMWO	Futures	7000.5	7012.2	6958.5	6964.3	3889.0
2018-04-20	FOAT	Futures	138.26	138.37	138.0	138.19	107423.0
2018-04-20	FTDX	Futures	2626.1	2626.1	2588.5	2591.9	189.0
2018-04-20	FTI	Futures	502.45	504.16	500.93	502.59	29982.0
2018-04-20	FTUK	Futures	6443.8	6468.6	6437.2	6458.4	105980.0
2018-04-20	FVSA	Futures	344.42	352.45	340.97	347.86	23036.0
2018-04-20	FXXP	Futures	325.0	326.2	324.3	325.6	29495.0
2018-04-20	G	Futures	113.46	113.55	112.98	113.1	227319.0
2018-04-20	GF	Futures	298.752	300.635	295.147	299.828	7126.0
2018-04-20	GSCI	Futures	531.42	533.44	529.16	533.44	42.0

> showing 50 of 111 rows — these rows as CSV

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