PREVIEW / futures_daily / 2018-07-24

all futures daily files

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

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-24	ES	Futures	3052.48	3075.01	3052.21	3063.88	1347688.0
2018-07-24	NQ	Futures	8651.28	8732.31	8612.23	8646.62	406774.0
2018-07-24	YM	Futures	26370.8	26624.7	26365.5	26567.8	183688.0
2018-07-24	CL	Futures	70.15	71.44	69.9	70.89	524591.0
2018-07-24	GC	Futures	1563.2	1569.9	1555.1	1564.6	299064.0
2018-07-24	ZN	Futures	118.904056	118.981751	118.733128	118.904056	1311962.0
2018-07-24	A6	Futures	0.75946	0.7648	0.75709	0.76285	87570.0
2018-07-24	AD	Futures	0.76971	0.77173	0.76844	0.77042	52351.0
2018-07-24	B	Futures	53.78	54.59	53.61	54.17	215150.0
2018-07-24	B6	Futures	1.3544	1.3608	1.3517	1.3588	99705.0
2018-07-24	BR	Futures	0.2001	0.20323	0.2001	0.20281	1287.0
2018-07-24	BTC	Futures	11019.3	11909.6	10983.7	11774.3	1257.0
2018-07-24	BZ	Futures	53.56	54.3	53.32	53.88	21747.0
2018-07-24	C	Futures	1595.0	1601.0	1571.0	1576.0	10731.0
2018-07-24	CB	Futures	272.852	272.852	271.023	272.283	105.0
2018-07-24	CC	Futures	1642.0	1650.0	1610.0	1618.0	17781.0
2018-07-24	CNH	Futures	6.9083	6.9201	6.8707	6.8876	97.0
2018-07-24	CSC	Futures	3.2	3.248	3.198	3.236	42.0
2018-07-24	CT	Futures	98.66	98.66	97.98	97.98	6.0
2018-07-24	DC	Futures	25.73	26.08	25.61	26.05	206.0
2018-07-24	DX	Futures	89.43	89.629	89.184	89.395	13352.0
2018-07-24	E1	Futures	1.20911	1.2097	1.206	1.20779	23010.0
2018-07-24	E6	Futures	1.31269	1.31565	1.3086	1.31185	199833.0
2018-07-24	E7	Futures	1.3061	1.3088	1.3019	1.3052	3013.0
2018-07-24	EBM	Futures	201.13	205.31	199.56	204.53	24260.0
2018-07-24	ED	Futures	95.0107	95.0253	95.0059	95.0205	353685.0
2018-07-24	ER	Futures	98.372	98.372	98.367	98.367	30967.0
2018-07-24	EW	Futures	2118.3	2127.1	2094.2	2102.0	16786.0
2018-07-24	FBON	Futures	129.06	129.36	128.94	129.33	64.0
2018-07-24	FBTP	Futures	108.34	108.59	107.84	108.29	61557.0
2018-07-24	FBTS	Futures	102.958	102.995	102.689	102.865	35720.0
2018-07-24	FCE	Futures	4841.0	4891.2	4833.4	4873.8	68390.0
2018-07-24	FDAX	Futures	13177.5	13324.3	13141.4	13269.5	93942.0
2018-07-24	FDIV	Futures	150.21	151.19	150.21	151.19	31.0
2018-07-24	FDXM	Futures	13007.1	13154.6	12974.1	13100.0	34952.0
2018-07-24	FESX	Futures	2892.3	2913.2	2884.8	2907.3	973828.0
2018-07-24	FEU3	Futures	99.021	99.021	99.021	99.021	3.0
2018-07-24	FGBL	Futures	152.68	152.96	152.48	152.91	536810.0
2018-07-24	FGBM	Futures	130.9	131.0	130.82	130.99	352663.0
2018-07-24	FGBS	Futures	112.638	112.668	112.628	112.663	217172.0
2018-07-24	FGBX	Futures	176.25	177.14	175.87	177.0	33667.0
2018-07-24	FMWO	Futures	7137.0	7190.6	7134.7	7177.8	1184.0
2018-07-24	FOAT	Futures	140.59	140.8	140.36	140.77	89145.0
2018-07-24	FTDX	Futures	2848.5	2863.2	2835.8	2849.0	246.0
2018-07-24	FTI	Futures	526.38	529.01	524.16	527.03	26491.0
2018-07-24	FTUK	Futures	6784.9	6841.0	6757.3	6824.5	93708.0
2018-07-24	FVSA	Futures	271.33	274.2	265.6	266.56	19736.0
2018-07-24	FXXP	Futures	332.8	335.7	332.4	335.1	53459.0
2018-07-24	G	Futures	115.52	115.75	115.34	115.69	223728.0
2018-07-24	GF	Futures	317.624	318.193	315.345	316.432	5584.0

> showing 50 of 115 rows — these rows as CSV

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