PREVIEW / futures_daily / 2019-01-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-29.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
2019-01-29	ES	Futures	2858.52	2869.07	2845.8	2858.52	1261703.0
2019-01-29	NQ	Futures	7751.45	7781.26	7660.57	7686.04	441622.0
2019-01-29	YM	Futures	25797.6	25987.4	25683.7	25897.8	180579.0
2019-01-29	CL	Futures	54.2	56.09	53.91	55.44	660527.0
2019-01-29	GC	Futures	1635.6	1646.4	1634.7	1644.0	185535.0
2019-01-29	ZN	Futures	120.973522	121.315871	120.957961	121.284748	1191668.0
2019-01-29	A6	Futures	0.73827	0.73992	0.736	0.73703	79410.0
2019-01-29	AD	Futures	0.7643	0.76547	0.76294	0.76299	49136.0
2019-01-29	B	Futures	43.28	44.73	43.22	44.37	298432.0
2019-01-29	B6	Futures	1.3537	1.3587	1.3438	1.3481	186126.0
2019-01-29	BR	Futures	0.21125	0.21413	0.21054	0.21365	7249.0
2019-01-29	BTC	Futures	4991.1	5005.8	4865.7	4968.9	2453.0
2019-01-29	BZ	Futures	43.02	44.26	42.77	43.91	24436.0
2019-01-29	C	Futures	1404.0	1421.0	1387.0	1392.0	10484.0
2019-01-29	CB	Futures	275.478	276.996	275.478	276.693	39.0
2019-01-29	CC	Futures	1552.0	1574.0	1520.0	1526.0	21665.0
2019-01-29	CNH	Futures	6.7664	6.7755	6.7571	6.7591	694.0
2019-01-29	CSC	Futures	2.685	2.721	2.685	2.704	122.0
2019-01-29	CT	Futures	80.24	81.1	80.06	80.77	15274.0
2019-01-29	DC	Futures	23.01	23.2	22.87	23.07	286.0
2019-01-29	DX	Futures	91.016	91.135	90.892	91.093	14838.0
2019-01-29	E1	Futures	1.19065	1.19194	1.18606	1.18701	14096.0
2019-01-29	E6	Futures	1.26773	1.27028	1.26597	1.2679	151084.0
2019-01-29	E7	Futures	1.2616	1.2641	1.2598	1.2617	2554.0
2019-01-29	EBM	Futures	211.03	212.31	210.51	211.54	21000.0
2019-01-29	ED	Futures	95.0281	95.0379	95.0281	95.033	147713.0
2019-01-29	ER	Futures	98.396	98.401	98.396	98.401	19304.0
2019-01-29	EW	Futures	1933.1	1942.0	1925.1	1934.7	10202.0
2019-01-29	FBON	Futures	131.89	131.96	131.63	131.72	322.0
2019-01-29	FBTP	Futures	112.61	113.02	112.49	113.0	65848.0
2019-01-29	FBTS	Futures	105.436	105.531	105.37	105.502	37946.0
2019-01-29	FCE	Futures	4376.1	4431.6	4368.9	4411.9	74270.0
2019-01-29	FDAX	Futures	11779.0	11848.4	11723.3	11780.1	93630.0
2019-01-29	FDXM	Futures	11750.3	11820.6	11695.8	11751.4	39451.0
2019-01-29	FESX	Futures	2678.2	2698.7	2668.0	2686.8	769065.0
2019-01-29	FEU3	Futures	99.001	99.001	98.996	99.001	28.0
2019-01-29	FGBL	Futures	156.83	157.15	156.74	156.96	566210.0
2019-01-29	FGBM	Futures	132.26	132.3	132.18	132.25	364401.0
2019-01-29	FGBS	Futures	112.708	112.718	112.678	112.683	304584.0
2019-01-29	FGBX	Futures	186.56	187.23	186.21	186.74	43988.0
2019-01-29	FMWO	Futures	6665.9	6703.2	6665.9	6681.1	943.0
2019-01-29	FOAT	Futures	142.55	142.76	142.55	142.66	100964.0
2019-01-29	FTDX	Futures	2597.5	2624.8	2594.5	2614.9	153.0
2019-01-29	FTI	Futures	481.76	487.71	481.48	485.3	27053.0
2019-01-29	FTUK	Futures	6090.0	6204.8	6090.0	6166.5	116919.0
2019-01-29	FVSA	Futures	319.82	321.69	306.69	317.0	16469.0
2019-01-29	FXXP	Futures	310.2	313.7	309.7	312.2	38501.0
2019-01-29	G	Futures	116.76	116.94	116.55	116.77	186084.0
2019-01-29	GF	Futures	315.345	317.094	315.126	315.454	4622.0
2019-01-29	GSCI	Futures	461.19	465.59	461.19	464.62	82.0

> showing 50 of 115 rows — these rows as CSV

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