PREVIEW / futures_daily / 2018-06-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-18.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-06-18	ES	Futures	3019.35	3026.68	2998.99	3019.08	993118.0
2018-06-18	NQ	Futures	8483.1	8498.55	8404.7	8483.1	291954.0
2018-06-18	YM	Futures	26420.3	26498.3	26172.7	26359.2	163171.0
2018-06-18	CL	Futures	65.05	66.67	64.22	66.54	543015.0
2018-06-18	GC	Futures	1635.6	1640.4	1633.5	1634.3	195743.0
2018-06-18	ZN	Futures	118.950673	119.121601	118.904056	118.935134	917718.0
2018-06-18	A6	Futures	0.76532	0.76696	0.76275	0.76295	81750.0
2018-06-18	AD	Futures	0.76865	0.77087	0.76642	0.76758	72872.0
2018-06-18	B	Futures	53.5	55.28	53.05	55.17	316116.0
2018-06-18	B6	Futures	1.3751	1.3754	1.3702	1.3718	70617.0
2018-06-18	BFX	Futures	4345.6	4354.2	4345.6	4354.2	9.0
2018-06-18	BR	Futures	0.20125	0.20201	0.20121	0.20121	18.0
2018-06-18	BTC	Futures	9230.3	9642.4	9010.0	9514.5	2794.0
2018-06-18	BZ	Futures	52.99	54.8	52.55	54.65	31861.0
2018-06-18	C	Futures	1590.0	1606.0	1560.0	1590.0	4293.0
2018-06-18	CB	Futures	288.144	288.144	285.116	285.386	134.0
2018-06-18	CC	Futures	1798.0	1808.0	1743.0	1775.0	18565.0
2018-06-18	CNH	Futures	6.526	6.5587	6.526	6.5545	19.0
2018-06-18	CSC	Futures	3.399	3.399	3.363	3.371	119.0
2018-06-18	CT	Futures	102.93	102.93	98.67	99.26	9387.0
2018-06-18	DC	Futures	27.11	27.23	26.66	26.71	216.0
2018-06-18	DX	Futures	89.496	89.695	89.383	89.46	14938.0
2018-06-18	E1	Futures	1.20696	1.21209	1.20552	1.21054	14449.0
2018-06-18	E6	Futures	1.30581	1.30905	1.30229	1.30799	181774.0
2018-06-18	E7	Futures	1.2992	1.3024	1.2956	1.3014	3830.0
2018-06-18	EBM	Futures	185.17	185.7	182.3	182.56	24054.0
2018-06-18	ED	Futures	94.9718	94.9815	94.9669	94.9718	171783.0
2018-06-18	ER	Futures	98.362	98.362	98.357	98.357	51336.0
2018-06-18	EW	Futures	2111.9	2120.9	2100.2	2117.5	10844.0
2018-06-18	FBON	Futures	129.17	129.87	129.14	129.71	369.0
2018-06-18	FBTP	Futures	108.12	108.76	107.65	108.59	52919.0
2018-06-18	FBTS	Futures	102.661	103.106	102.661	103.023	37028.0
2018-06-18	FCE	Futures	4936.8	4939.5	4861.7	4891.4	72521.0
2018-06-18	FDAX	Futures	13586.2	13588.3	13342.6	13402.2	90832.0
2018-06-18	FDIV	Futures	153.44	153.44	152.45	152.45	49.0
2018-06-18	FDXM	Futures	13418.8	13418.8	13172.2	13231.0	37505.0
2018-06-18	FESX	Futures	2915.7	2917.4	2873.9	2888.1	949434.0
2018-06-18	FGBL	Futures	151.87	152.09	151.72	151.85	456451.0
2018-06-18	FGBM	Futures	130.74	130.82	130.65	130.77	308794.0
2018-06-18	FGBS	Futures	112.688	112.688	112.658	112.673	200261.0
2018-06-18	FGBX	Futures	173.11	173.11	171.85	172.23	45632.0
2018-06-18	FMWO	Futures	7084.6	7089.2	7057.8	7084.6	1829.0
2018-06-18	FOAT	Futures	140.12	140.36	139.96	140.25	120497.0
2018-06-18	FTDX	Futures	2799.5	2807.3	2776.0	2790.7	84.0
2018-06-18	FTI	Futures	518.15	518.29	513.35	516.4	24410.0
2018-06-18	FTUK	Futures	6759.1	6769.7	6711.4	6739.5	83055.0
2018-06-18	FVSA	Futures	275.04	294.48	272.13	283.79	39113.0
2018-06-18	FXXP	Futures	334.5	334.6	330.9	332.2	42111.0
2018-06-18	G	Futures	115.05	115.21	114.88	114.97	117293.0
2018-06-18	GF	Futures	305.816	309.234	304.262	308.612	5457.0

> showing 50 of 113 rows — these rows as CSV

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