PREVIEW / futures_daily / 2018-03-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-29.parquet
  size:    10 KB
  rows:    111

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-03-29	ES	Futures	2838.02	2892.12	2828.5	2874.18	2042949.0
2018-03-29	NQ	Futures	7596.99	7787.77	7541.98	7717.84	647977.0
2018-03-29	YM	Futures	25164.7	25585.0	25067.8	25436.5	300100.0
2018-03-29	CL	Futures	64.97	65.54	64.43	65.22	562819.0
2018-03-29	GC	Futures	1697.1	1701.3	1692.1	1694.5	251250.0
2018-03-29	ZN	Futures	119.912357	120.284563	119.896848	120.238037	1199682.0
2018-03-29	A6	Futures	0.78764	0.79082	0.78599	0.78928	82322.0
2018-03-29	AD	Futures	0.78414	0.78773	0.78288	0.78535	67077.0
2018-03-29	B	Futures	50.18	50.71	49.59	50.4	299617.0
2018-03-29	B6	Futures	1.4628	1.4642	1.4555	1.4559	119003.0
2018-03-29	BR	Futures	0.2278	0.22947	0.22753	0.22944	152.0
2018-03-29	BTC	Futures	11212.1	11375.5	10040.5	10416.9	1684.0
2018-03-29	BZ	Futures	49.51	50.05	48.97	49.75	37805.0
2018-03-29	C	Futures	1673.0	1681.0	1633.0	1637.0	24682.0
2018-03-29	CB	Futures	281.185	281.494	279.672	281.494	37.0
2018-03-29	CC	Futures	1894.0	1913.0	1867.0	1875.0	23102.0
2018-03-29	CNH	Futures	6.4017	6.4062	6.3794	6.3794	62.0
2018-03-29	CSC	Futures	3.314	3.314	3.3	3.304	16.0
2018-03-29	CT	Futures	92.81	94.49	92.74	93.64	17467.0
2018-03-29	DC	Futures	26.33	26.4	26.22	26.24	96.0
2018-03-29	DX	Futures	84.623	84.731	84.481	84.705	17761.0
2018-03-29	E1	Futures	1.26608	1.26946	1.26452	1.26632	24688.0
2018-03-29	E6	Futures	1.3946	1.39736	1.3915	1.39223	191994.0
2018-03-29	E7	Futures	1.3869	1.3898	1.3841	1.3848	2526.0
2018-03-29	EBM	Futures	174.79	176.13	174.52	175.86	16229.0
2018-03-29	ED	Futures	95.023	95.023	94.9986	95.0084	264461.0
2018-03-29	ER	Futures	98.337	98.342	98.332	98.337	77694.0
2018-03-29	EW	Futures	1969.3	2002.5	1962.4	1994.3	26270.0
2018-03-29	FBON	Futures	130.08	130.88	130.08	130.8	263.0
2018-03-29	FBTP	Futures	115.05	115.65	114.96	115.62	83221.0
2018-03-29	FBTS	Futures	104.232	104.287	104.213	104.278	51765.0
2018-03-29	FCE	Futures	4509.8	4573.3	4509.8	4547.3	81876.0
2018-03-29	FDAX	Futures	12412.9	12643.6	12396.3	12593.2	112292.0
2018-03-29	FDXM	Futures	12304.5	12529.0	12288.0	12481.1	37839.0
2018-03-29	FESX	Futures	2701.5	2744.8	2699.8	2733.1	1198726.0
2018-03-29	FEU3	Futures	99.026	99.026	99.021	99.021	11.0
2018-03-29	FGBL	Futures	149.85	150.08	149.76	150.03	578896.0
2018-03-29	FGBM	Futures	129.71	129.82	129.67	129.8	339003.0
2018-03-29	FGBS	Futures	112.563	112.583	112.558	112.578	225809.0
2018-03-29	FGBX	Futures	171.2	171.32	170.68	171.11	53521.0
2018-03-29	FMWO	Futures	6796.2	6866.2	6791.5	6846.4	1214.0
2018-03-29	FOAT	Futures	138.99	139.33	138.96	139.29	95633.0
2018-03-29	FTDX	Futures	2451.9	2475.7	2451.9	2468.3	123.0
2018-03-29	FTI	Futures	482.03	487.53	481.66	484.73	29281.0
2018-03-29	FTUK	Futures	6135.4	6208.3	6121.7	6179.6	135747.0
2018-03-29	FVSA	Futures	455.41	455.41	410.23	428.06	22221.0
2018-03-29	FXXP	Futures	313.0	316.2	312.4	315.0	30169.0
2018-03-29	G	Futures	114.0	114.41	114.0	114.31	230380.0
2018-03-29	GF	Futures	300.184	303.451	290.383	290.383	3294.0
2018-03-29	GSCI	Futures	513.82	518.57	513.59	517.14	1192.0

> showing 50 of 111 rows — these rows as CSV

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