PREVIEW / futures_daily / 2018-04-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-23.parquet
  size:    9 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-04-23	ES	Futures	2917.68	2919.58	2889.67	2904.9	1239828.0
2018-04-23	NQ	Futures	7848.34	7874.68	7744.46	7803.28	384306.0
2018-04-23	YM	Futures	25852.6	25865.2	25587.1	25717.7	174321.0
2018-04-23	CL	Futures	68.47	69.28	67.39	68.89	740941.0
2018-04-23	GC	Futures	1705.9	1707.7	1690.1	1690.3	294254.0
2018-04-23	ZN	Futures	118.594127	118.609636	118.314973	118.439042	1509849.0
2018-04-23	A6	Futures	0.78836	0.79	0.78147	0.78167	100688.0
2018-04-23	AD	Futures	0.79395	0.79431	0.78758	0.78819	73115.0
2018-04-23	B	Futures	53.62	54.59	53.16	54.3	317446.0
2018-04-23	B6	Futures	1.4532	1.4565	1.4457	1.4468	96604.0
2018-04-23	BR	Futures	0.2217	0.2217	0.21988	0.22026	845.0
2018-04-23	BTC	Futures	12653.6	12802.7	12461.9	12561.3	2952.0
2018-04-23	BZ	Futures	53.01	53.89	52.47	53.6	41835.0
2018-04-23	C	Futures	1670.0	1689.0	1655.0	1665.0	2267.0
2018-04-23	CB	Futures	296.504	297.74	296.504	296.504	28.0
2018-04-23	CC	Futures	1979.0	2009.0	1967.0	1987.0	14519.0
2018-04-23	CNH	Futures	6.3874	6.4151	6.3874	6.4121	156.0
2018-04-23	CSC	Futures	3.417	3.434	3.417	3.434	34.0
2018-04-23	CT	Futures	98.51	99.36	95.29	95.62	3444.0
2018-04-23	DC	Futures	27.39	27.8	27.39	27.73	164.0
2018-04-23	DX	Futures	85.014	85.589	84.957	85.547	31075.0
2018-04-23	E1	Futures	1.24019	1.24115	1.23597	1.23646	35341.0
2018-04-23	E6	Futures	1.38896	1.39003	1.37967	1.3804	224199.0
2018-04-23	E7	Futures	1.3824	1.3825	1.3722	1.3731	3184.0
2018-04-23	EBM	Futures	175.32	175.59	174.79	175.05	28140.0
2018-04-23	ED	Futures	94.9306	94.95	94.9306	94.9403	282669.0
2018-04-23	ER	Futures	98.342	98.342	98.337	98.337	19029.0
2018-04-23	EW	Futures	2021.7	2026.5	2005.1	2014.2	11333.0
2018-04-23	FBON	Futures	129.46	129.46	129.16	129.23	275.0
2018-04-23	FBTP	Futures	115.58	115.81	115.48	115.67	74865.0
2018-04-23	FBTS	Futures	104.232	104.25	104.204	104.232	44354.0
2018-04-23	FCE	Futures	4787.0	4802.1	4756.2	4799.0	51592.0
2018-04-23	FDAX	Futures	13081.6	13094.6	12960.5	13086.3	96147.0
2018-04-23	FDXM	Futures	12960.5	12978.0	12845.1	12969.8	30044.0
2018-04-23	FESX	Futures	2854.8	2868.1	2838.9	2865.6	726181.0
2018-04-23	FEU3	Futures	99.03	99.03	99.026	99.026	149.0
2018-04-23	FGBL	Futures	148.57	148.66	148.33	148.5	863219.0
2018-04-23	FGBM	Futures	129.26	129.32	129.12	129.22	448777.0
2018-04-23	FGBS	Futures	112.467	112.482	112.432	112.452	291307.0
2018-04-23	FGBX	Futures	167.68	167.78	167.08	167.41	53656.0
2018-04-23	FMWO	Futures	6959.6	6986.5	6949.1	6984.2	2889.0
2018-04-23	FOAT	Futures	137.93	138.05	137.77	137.9	128019.0
2018-04-23	FTDX	Futures	2595.4	2616.7	2595.4	2615.7	118.0
2018-04-23	FTI	Futures	503.1	506.79	501.71	506.65	20050.0
2018-04-23	FTUK	Futures	6469.9	6498.2	6454.4	6492.9	95193.0
2018-04-23	FVSA	Futures	344.42	351.31	336.38	338.68	29913.0
2018-04-23	FXXP	Futures	326.3	327.5	324.5	327.1	31993.0
2018-04-23	G	Futures	112.96	113.06	112.65	112.82	165037.0
2018-04-23	GF	Futures	302.356	303.97	301.173	302.571	6038.0
2018-04-23	GSCI	Futures	528.43	534.62	528.43	533.95	47.0

> showing 50 of 111 rows — these rows as CSV

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