PREVIEW / futures_daily / 2018-07-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-31.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-31	ES	Futures	3047.05	3071.21	3044.06	3059.54	1366896.0
2018-07-31	NQ	Futures	8406.15	8508.75	8381.96	8446.67	430194.0
2018-07-31	YM	Futures	26662.6	26854.4	26628.9	26758.5	148713.0
2018-07-31	CL	Futures	72.48	72.65	70.33	71.14	519070.0
2018-07-31	GC	Futures	1559.6	1568.8	1549.5	1563.5	297825.0
2018-07-31	ZN	Futures	118.717589	118.99729	118.686511	118.764206	1915199.0
2018-07-31	A6	Futures	0.76213	0.76552	0.76162	0.76511	104070.0
2018-07-31	AD	Futures	0.77791	0.7809	0.77396	0.77984	105014.0
2018-07-31	B	Futures	55.0	55.12	53.83	54.1	288571.0
2018-07-31	B6	Futures	1.3574	1.3619	1.3531	1.3567	100969.0
2018-07-31	BR	Futures	0.20365	0.20376	0.20167	0.20205	4099.0
2018-07-31	BTC	Futures	11567.7	11681.7	10883.9	11012.2	9415.0
2018-07-31	BZ	Futures	54.88	55.05	53.74	54.02	20721.0
2018-07-31	C	Futures	1566.0	1574.0	1520.0	1526.0	11680.0
2018-07-31	CB	Futures	273.152	275.071	273.152	275.071	32.0
2018-07-31	CC	Futures	1606.0	1618.0	1543.0	1555.0	24635.0
2018-07-31	CNH	Futures	6.9116	6.9204	6.85	6.8664	97.0
2018-07-31	CSC	Futures	3.218	3.224	3.204	3.214	110.0
2018-07-31	CT	Futures	101.48	101.62	101.3	101.3	5.0
2018-07-31	DC	Futures	26.0	26.0	25.83	25.93	119.0
2018-07-31	DX	Futures	89.141	89.373	88.971	89.288	15480.0
2018-07-31	E1	Futures	1.21389	1.2158	1.2109	1.21174	28426.0
2018-07-31	E6	Futures	1.3138	1.31856	1.31118	1.31269	227953.0
2018-07-31	E7	Futures	1.3072	1.3117	1.3045	1.3061	3693.0
2018-07-31	EBM	Futures	210.8	215.25	210.8	211.59	19283.0
2018-07-31	ED	Futures	95.0107	95.0107	94.9961	95.001	162205.0
2018-07-31	ER	Futures	98.367	98.367	98.362	98.367	30814.0
2018-07-31	EW	Futures	2085.9	2109.8	2083.1	2102.6	17609.0
2018-07-31	FBON	Futures	129.14	129.14	128.81	129.04	148.0
2018-07-31	FBTP	Futures	107.54	107.93	107.26	107.77	61456.0
2018-07-31	FBTS	Futures	102.661	102.754	102.596	102.707	22830.0
2018-07-31	FCE	Futures	4921.3	4959.4	4912.3	4942.8	62953.0
2018-07-31	FDAX	Futures	13382.4	13436.7	13304.5	13395.4	81619.0
2018-07-31	FDXM	Futures	13211.4	13265.1	13136.1	13224.3	38507.0
2018-07-31	FESX	Futures	2929.9	2950.8	2926.5	2944.1	1028220.0
2018-07-31	FEU3	Futures	99.011	99.016	99.011	99.016	198.0
2018-07-31	FGBL	Futures	152.55	152.7	152.09	152.25	692914.0
2018-07-31	FGBM	Futures	130.76	130.87	130.59	130.66	437053.0
2018-07-31	FGBS	Futures	112.613	112.628	112.578	112.588	255428.0
2018-07-31	FGBX	Futures	176.15	176.55	174.99	175.73	50014.0
2018-07-31	FMWO	Futures	7159.1	7180.1	7153.3	7176.6	1329.0
2018-07-31	FOAT	Futures	140.6	140.67	140.16	140.35	142407.0
2018-07-31	FTDX	Futures	2861.7	2861.7	2817.1	2830.9	634.0
2018-07-31	FTI	Futures	526.93	529.2	526.43	527.77	27745.0
2018-07-31	FTUK	Futures	6796.0	6881.1	6791.1	6862.9	129256.0
2018-07-31	FVSA	Futures	265.6	267.51	260.83	262.74	13679.0
2018-07-31	FXXP	Futures	336.7	338.7	336.6	338.2	46934.0
2018-07-31	G	Futures	115.18	115.27	114.97	115.1	272263.0
2018-07-31	GF	Futures	313.221	313.843	308.405	309.337	5011.0
2018-07-31	GSCI	Futures	527.36	527.36	523.59	524.21	52.0

> showing 50 of 113 rows — these rows as CSV

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