PREVIEW / futures_daily / 2018-07-10

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-10.parquet
  size:    10 KB
  rows:    113

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-07-10	ES	Futures	3027.5	3038.63	3019.89	3037.54	925706.0
2018-07-10	NQ	Futures	8511.96	8552.47	8463.87	8512.83	286748.0
2018-07-10	YM	Futures	26110.5	26275.9	26073.6	26265.4	160488.0
2018-07-10	CL	Futures	75.0	75.67	74.6	75.07	586829.0
2018-07-10	GC	Futures	1606.7	1609.9	1592.9	1602.7	272630.0
2018-07-10	ZN	Futures	119.463458	119.541153	119.339147	119.354686	1011141.0
2018-07-10	A6	Futures	0.76738	0.76954	0.76419	0.76789	73284.0
2018-07-10	AD	Futures	0.7732	0.77406	0.77138	0.7729	45781.0
2018-07-10	B	Futures	57.72	58.65	57.65	58.17	261549.0
2018-07-10	B6	Futures	1.3714	1.3764	1.3683	1.3727	126910.0
2018-07-10	BR	Futures	0.19565	0.19969	0.1955	0.19911	326.0
2018-07-10	BTC	Futures	9537.7	9665.9	8967.9	9053.3	3084.0
2018-07-10	BZ	Futures	57.41	58.33	57.38	57.86	19767.0
2018-07-10	C	Futures	1699.0	1735.0	1697.0	1731.0	9168.0
2018-07-10	CB	Futures	270.154	271.713	270.154	271.683	17.0
2018-07-10	CC	Futures	1763.0	1808.0	1752.0	1793.0	21779.0
2018-07-10	CNH	Futures	6.6898	6.7255	6.6895	6.7109	48.0
2018-07-10	CSC	Futures	3.178	3.208	3.166	3.196	68.0
2018-07-10	CT	Futures	97.24	98.18	96.84	98.18	12.0
2018-07-10	DC	Futures	25.08	25.25	24.8	25.08	307.0
2018-07-10	DX	Futures	88.843	89.241	88.791	88.922	14451.0
2018-07-10	E1	Futures	1.21185	1.21281	1.20636	1.21114	21899.0
2018-07-10	E6	Futures	1.32074	1.32219	1.31403	1.32012	176362.0
2018-07-10	E7	Futures	1.3137	1.3154	1.3073	1.3134	2772.0
2018-07-10	EBM	Futures	191.71	191.71	188.83	189.1	15907.0
2018-07-10	ED	Futures	94.9815	94.9864	94.9718	94.9718	178440.0
2018-07-10	ER	Futures	98.362	98.367	98.362	98.367	15692.0
2018-07-10	EW	Futures	2131.7	2138.6	2119.4	2130.8	11510.0
2018-07-10	FBON	Futures	129.29	129.52	129.18	129.46	271.0
2018-07-10	FBTP	Futures	108.06	108.38	107.72	108.01	43796.0
2018-07-10	FBTS	Futures	102.54	102.67	102.438	102.559	24953.0
2018-07-10	FCE	Futures	4864.0	4886.5	4852.8	4882.9	51754.0
2018-07-10	FDAX	Futures	13135.1	13202.6	13083.9	13171.2	73852.0
2018-07-10	FDXM	Futures	12966.8	13033.9	12916.3	13002.9	25633.0
2018-07-10	FESX	Futures	2892.3	2901.5	2878.9	2894.8	793080.0
2018-07-10	FGBL	Futures	153.11	153.19	152.89	153.01	488734.0
2018-07-10	FGBM	Futures	131.16	131.18	131.05	131.09	288955.0
2018-07-10	FGBS	Futures	112.723	112.734	112.698	112.713	219316.0
2018-07-10	FGBX	Futures	177.42	177.66	177.04	177.44	38745.0
2018-07-10	FMWO	Futures	7105.5	7127.7	7104.4	7114.9	2494.0
2018-07-10	FOAT	Futures	141.25	141.3	141.08	141.21	78673.0
2018-07-10	FTDX	Futures	2744.1	2750.0	2732.8	2749.5	132.0
2018-07-10	FTI	Futures	514.64	515.2	514.64	514.64	33.0
2018-07-10	FTUK	Futures	6815.6	6819.6	6784.0	6803.2	73735.0
2018-07-10	FVSA	Futures	279.9	282.82	262.41	264.35	20879.0
2018-07-10	FXXP	Futures	331.6	333.3	331.4	332.9	49390.0
2018-07-10	G	Futures	115.58	115.59	115.23	115.33	142527.0
2018-07-10	GF	Futures	313.791	315.656	312.134	314.568	6927.0
2018-07-10	GSCI	Futures	541.0	541.0	537.62	537.62	2430.0
2018-07-10	HE	Futures	81.066	81.066	77.751	77.751	41417.0

> showing 50 of 113 rows — these rows as CSV

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