PREVIEW / futures_daily / 2019-01-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-18.parquet
  size:    10 KB
  rows:    118

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-18	ES	Futures	2854.73	2899.12	2850.4	2892.35	1753852.0
2019-01-18	NQ	Futures	7783.29	7905.43	7770.84	7864.33	499881.0
2019-01-18	YM	Futures	25668.9	26100.3	25628.8	26039.1	215532.0
2019-01-18	CL	Futures	54.63	56.3	54.46	56.2	669504.0
2019-01-18	GC	Futures	1627.8	1628.2	1612.9	1616.1	225565.0
2019-01-18	ZN	Futures	121.004645	121.051329	120.568929	120.677858	1468412.0
2019-01-18	A6	Futures	0.74126	0.74393	0.73816	0.73909	88467.0
2019-01-18	AD	Futures	0.76354	0.76638	0.76243	0.7639	60381.0
2019-01-18	B	Futures	44.28	45.48	44.27	45.27	288912.0
2019-01-18	B6	Futures	1.3374	1.338	1.3238	1.3255	96988.0
2019-01-18	BFX	Futures	4031.5	4077.7	4031.5	4077.7	1.0
2019-01-18	BR	Futures	0.21225	0.21333	0.21125	0.21125	27.0
2019-01-18	BTC	Futures	5285.0	5306.9	5175.3	5241.1	2669.0
2019-01-18	BZ	Futures	43.81	45.09	43.71	44.89	39637.0
2019-01-18	C	Futures	1484.0	1486.0	1461.0	1463.0	6551.0
2019-01-18	CB	Futures	273.959	273.959	272.744	273.321	47.0
2019-01-18	CC	Futures	1618.0	1622.0	1583.0	1589.0	12131.0
2019-01-18	CNH	Futures	6.79	6.8212	6.7895	6.8186	583.0
2019-01-18	CSC	Futures	2.736	2.743	2.717	2.734	120.0
2019-01-18	CT	Futures	81.01	81.33	80.35	80.49	12292.0
2019-01-18	DC	Futures	23.54	23.55	23.28	23.47	401.0
2019-01-18	DX	Futures	91.288	91.603	91.236	91.548	15837.0
2019-01-18	E1	Futures	1.18924	1.19018	1.18677	1.18771	11362.0
2019-01-18	E6	Futures	1.26453	1.26674	1.26044	1.26232	150810.0
2019-01-18	E7	Futures	1.2583	1.2606	1.2543	1.2562	2830.0
2019-01-18	EBM	Futures	210.0	210.51	209.48	209.74	12415.0
2019-01-18	ED	Futures	95.0232	95.033	95.0135	95.0135	281122.0
2019-01-18	ER	Futures	98.406	98.406	98.401	98.401	25072.0
2019-01-18	EW	Futures	1910.5	1941.4	1908.0	1936.5	14281.0
2019-01-18	FBON	Futures	130.36	130.58	130.36	130.5	602.0
2019-01-18	FBTP	Futures	111.71	112.21	111.64	111.97	79440.0
2019-01-18	FBTS	Futures	105.152	105.37	105.114	105.237	52981.0
2019-01-18	FCE	Futures	4314.3	4372.0	4312.0	4365.3	101830.0
2019-01-18	FDAX	Futures	11545.2	11826.3	11517.4	11782.2	132548.0
2019-01-18	FDIV	Futures	137.55	137.55	137.15	137.15	3.0
2019-01-18	FDXM	Futures	11499.8	11797.5	11490.4	11753.5	55828.0
2019-01-18	FESX	Futures	2629.5	2676.5	2626.1	2671.4	1475010.0
2019-01-18	FEU3	Futures	99.001	99.001	99.001	99.001	600.0
2019-01-18	FGBL	Futures	156.2	156.25	155.78	156.0	712268.0
2019-01-18	FGBM	Futures	132.18	132.18	132.0	132.06	566724.0
2019-01-18	FGBS	Futures	112.718	112.723	112.683	112.703	270692.0
2019-01-18	FGBX	Futures	184.39	184.59	183.31	183.88	32165.0
2019-01-18	FMWO	Futures	6665.9	6741.7	6663.6	6726.5	4634.0
2019-01-18	FOAT	Futures	142.17	142.22	141.94	142.07	92429.0
2019-01-18	FTDX	Futures	2519.0	2565.2	2516.0	2564.7	254.0
2019-01-18	FTI	Futures	473.72	481.76	473.3	480.18	40077.0
2019-01-18	FTUK	Futures	6187.9	6322.7	6187.9	6298.1	120440.0
2019-01-18	FVSA	Futures	318.88	320.76	302.0	305.75	36267.0
2019-01-18	FXXP	Futures	308.4	312.7	308.3	312.2	53854.0
2019-01-18	G	Futures	116.02	116.21	115.81	116.04	178368.0

> showing 50 of 118 rows — these rows as CSV

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