PREVIEW / futures_daily / 2019-07-11

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-11.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-07-11	ES	Futures	3232.85	3244.45	3229.08	3241.49	1181911.0
2019-07-11	NQ	Futures	9123.38	9168.29	9088.85	9117.05	407894.0
2019-07-11	YM	Futures	28202.6	28447.3	28194.2	28431.5	184871.0
2019-07-11	CL	Futures	61.83	62.34	61.52	61.58	573019.0
2019-07-11	GC	Futures	1768.7	1779.1	1745.8	1750.8	400086.0
2019-07-11	ZN	Futures	126.84934	127.051527	126.165013	126.398306	1751719.0
2019-07-11	A6	Futures	0.71787	0.72034	0.71684	0.719	78768.0
2019-07-11	AD	Futures	0.77189	0.77381	0.77083	0.77209	63640.0
2019-07-11	ALI	Futures	2278.24	2278.24	2278.24	2278.24	5.0
2019-07-11	B	Futures	50.23	50.86	49.94	50.01	283017.0
2019-07-11	B6	Futures	1.2806	1.287	1.2802	1.2824	83755.0
2019-07-11	BR	Futures	0.21318	0.21318	0.21138	0.21198	1214.0
2019-07-11	BTC	Futures	16980.6	17337.6	15461.8	16420.7	9616.0
2019-07-11	BZ	Futures	49.53	50.21	49.32	49.38	37676.0
2019-07-11	C	Futures	1768.0	1770.0	1740.0	1745.0	11890.0
2019-07-11	CB	Futures	284.16	284.16	283.576	283.576	8.0
2019-07-11	CC	Futures	1682.0	1684.0	1649.0	1659.0	13392.0
2019-07-11	CNH	Futures	6.8718	6.8776	6.863	6.8763	550.0
2019-07-11	CSC	Futures	3.154	3.157	3.135	3.147	56.0
2019-07-11	CT	Futures	62.84	62.96	61.79	62.11	32.0
2019-07-11	DC	Futures	26.33	26.39	26.21	26.27	142.0
2019-07-11	DX	Futures	93.079	93.176	92.829	93.071	15617.0
2019-07-11	E1	Futures	1.17907	1.18475	1.17768	1.17838	21484.0
2019-07-11	E6	Futures	1.23411	1.23749	1.23307	1.23443	181383.0
2019-07-11	E7	Futures	1.2274	1.2309	1.2267	1.228	3635.0
2019-07-11	EBM	Futures	200.08	204.4	199.79	203.53	22099.0
2019-07-11	ED	Futures	95.3574	95.3817	95.3233	95.3379	388258.0
2019-07-11	ER	Futures	98.509	98.519	98.504	98.509	93960.0
2019-07-11	EW	Futures	2045.7	2052.3	2032.8	2041.6	11944.0
2019-07-11	FBON	Futures	143.04	143.22	142.37	142.44	340.0
2019-07-11	FBTP	Futures	123.86	124.38	123.72	123.88	111163.0
2019-07-11	FBTS	Futures	107.302	107.485	107.274	107.398	94843.0
2019-07-11	FCE	Futures	5107.6	5110.8	5069.2	5072.8	56455.0
2019-07-11	FDAX	Futures	13031.2	13084.9	12945.9	12975.4	109865.0
2019-07-11	FDIV	Futures	146.88	146.88	146.18	146.18	40.0
2019-07-11	FDXM	Futures	12881.6	12924.3	12788.0	12815.6	36571.0
2019-07-11	FESX	Futures	3056.2	3066.7	3042.2	3047.5	762646.0
2019-07-11	FGBL	Futures	164.06	164.24	163.07	163.38	812515.0
2019-07-11	FGBM	Futures	134.33	134.38	134.09	134.18	470992.0
2019-07-11	FGBS	Futures	113.061	113.071	113.026	113.041	292201.0
2019-07-11	FGBX	Futures	207.8	208.23	203.8	204.77	61442.0
2019-07-11	FMWO	Futures	7430.6	7446.8	7412.1	7429.5	4392.0
2019-07-11	FOAT	Futures	151.64	151.74	150.85	150.94	138745.0
2019-07-11	FTDX	Futures	2864.6	2864.6	2832.0	2841.9	58.0
2019-07-11	FTI	Futures	535.25	536.63	534.02	534.67	255.0
2019-07-11	FTUK	Futures	6912.7	6921.9	6866.5	6878.5	70525.0
2019-07-11	FVSA	Futures	175.82	177.2	171.67	173.74	46218.0
2019-07-11	FXXP	Futures	347.1	347.2	344.8	345.4	39555.0
2019-07-11	G	Futures	120.7	120.82	119.8	119.87	228705.0
2019-07-11	GF	Futures	280.819	282.095	278.759	279.887	6386.0

> showing 50 of 119 rows — these rows as CSV

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