PREVIEW / futures_daily / 2018-07-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-26.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
2018-07-26	ES	Futures	3079.36	3091.58	3077.19	3087.23	1039552.0
2018-07-26	NQ	Futures	8641.96	8685.97	8583.37	8663.53	392494.0
2018-07-26	YM	Futures	26802.8	26940.8	26755.4	26895.5	156245.0
2018-07-26	CL	Futures	71.78	72.34	71.31	72.02	489059.0
2018-07-26	GC	Futures	1572.6	1577.4	1560.6	1565.6	101394.0
2018-07-26	ZN	Futures	118.717589	118.904056	118.624355	118.686511	1476232.0
2018-07-26	A6	Futures	0.76573	0.76789	0.75833	0.75894	104036.0
2018-07-26	AD	Futures	0.7772	0.77832	0.77422	0.77563	77984.0
2018-07-26	B	Futures	54.53	54.89	54.18	54.76	210326.0
2018-07-26	B6	Futures	1.3632	1.366	1.3549	1.3555	108449.0
2018-07-26	BR	Futures	0.2062	0.20692	0.20239	0.20273	7792.0
2018-07-26	BTC	Futures	11752.9	11824.2	11553.5	11760.1	918.0
2018-07-26	BZ	Futures	54.24	54.82	54.11	54.68	20159.0
2018-07-26	C	Futures	1572.0	1626.0	1560.0	1614.0	8643.0
2018-07-26	CB	Futures	272.912	273.902	272.912	273.182	18.0
2018-07-26	CC	Futures	1608.0	1683.0	1608.0	1659.0	20996.0
2018-07-26	CNH	Futures	6.8348	6.8905	6.8348	6.8905	36.0
2018-07-26	CSC	Futures	3.238	3.238	3.218	3.218	22.0
2018-07-26	CT	Futures	99.73	100.05	99.0	99.9	6.0
2018-07-26	DC	Futures	26.01	26.01	25.76	25.91	96.0
2018-07-26	DX	Futures	88.971	89.577	88.904	89.543	22628.0
2018-07-26	E1	Futures	1.21006	1.21185	1.20576	1.20648	19781.0
2018-07-26	E6	Futures	1.3161	1.31828	1.30654	1.30721	250043.0
2018-07-26	E7	Futures	1.3095	1.3115	1.2999	1.3006	4124.0
2018-07-26	EBM	Futures	212.9	214.2	207.67	207.93	33141.0
2018-07-26	ED	Futures	95.0205	95.0205	95.0059	95.0107	180316.0
2018-07-26	ER	Futures	98.367	98.367	98.362	98.367	32828.0
2018-07-26	EW	Futures	2107.7	2124.8	2105.3	2117.4	13514.0
2018-07-26	FBON	Futures	129.29	129.61	129.29	129.39	120.0
2018-07-26	FBTP	Futures	108.03	108.17	107.81	107.99	56881.0
2018-07-26	FBTS	Futures	102.754	102.828	102.744	102.8	31951.0
2018-07-26	FCE	Futures	4898.9	4915.0	4874.2	4915.0	80545.0
2018-07-26	FDAX	Futures	13250.1	13407.4	13244.4	13390.2	103509.0
2018-07-26	FDIV	Futures	152.09	152.72	152.09	152.72	49.0
2018-07-26	FDXM	Futures	13081.4	13235.1	13075.2	13219.1	38431.0
2018-07-26	FESX	Futures	2906.5	2927.4	2904.0	2925.7	857881.0
2018-07-26	FGBL	Futures	152.6	153.0	152.54	152.82	546245.0
2018-07-26	FGBM	Futures	130.82	130.99	130.77	130.93	341784.0
2018-07-26	FGBS	Futures	112.623	112.663	112.618	112.648	204502.0
2018-07-26	FGBX	Futures	176.53	177.3	176.31	176.85	36925.0
2018-07-26	FMWO	Futures	7198.7	7216.2	7196.4	7212.7	1170.0
2018-07-26	FOAT	Futures	140.62	140.93	140.51	140.77	82066.0
2018-07-26	FTDX	Futures	2878.9	2893.1	2863.2	2875.5	136.0
2018-07-26	FTI	Futures	529.06	529.66	525.41	527.12	30970.0
2018-07-26	FTUK	Futures	6784.0	6794.2	6753.7	6779.1	79750.0
2018-07-26	FVSA	Futures	268.47	268.47	257.0	261.78	19787.0
2018-07-26	FXXP	Futures	335.2	337.0	334.8	336.7	47378.0
2018-07-26	G	Futures	115.46	115.66	115.39	115.56	179734.0
2018-07-26	GF	Futures	317.054	319.488	310.321	313.688	9383.0
2018-07-26	GSCI	Futures	526.35	527.19	525.67	526.18	26.0

> showing 50 of 114 rows — these rows as CSV

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