PREVIEW / futures_daily / 2018-11-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-21.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
2018-11-21	ES	Futures	2862.84	2897.0	2854.7	2872.87	1454916.0
2018-11-21	NQ	Futures	7582.15	7721.53	7560.37	7638.48	569302.0
2018-11-21	YM	Futures	25730.1	25967.0	25675.3	25762.7	200252.0
2018-11-21	CL	Futures	56.49	59.1	56.49	57.8	734277.0
2018-11-21	GC	Futures	1549.3	1560.1	1546.4	1556.4	227212.0
2018-11-21	ZN	Futures	118.732494	118.794748	118.545735	118.763621	1824157.0
2018-11-21	A6	Futures	0.74167	0.74908	0.74136	0.74764	91869.0
2018-11-21	AD	Futures	0.7602	0.7647	0.75955	0.76334	73020.0
2018-11-21	B	Futures	46.27	47.66	46.24	46.92	334983.0
2018-11-21	B6	Futures	1.3163	1.32	1.3142	1.3159	80732.0
2018-11-21	BR	Futures	0.20174	0.20228	0.20033	0.20125	1608.0
2018-11-21	BTC	Futures	6123.2	6687.7	6029.1	6354.8	6540.0
2018-11-21	BZ	Futures	45.81	47.32	45.81	46.6	41292.0
2018-11-21	C	Futures	1461.0	1461.0	1441.0	1443.0	1134.0
2018-11-21	CB	Futures	266.761	266.761	266.67	266.73	32.0
2018-11-21	CC	Futures	1507.0	1507.0	1469.0	1478.0	18729.0
2018-11-21	CNH	Futures	6.9834	6.9917	6.9641	6.9646	461.0
2018-11-21	CSC	Futures	2.896	2.912	2.871	2.885	98.0
2018-11-21	CT	Futures	84.52	86.65	84.31	85.88	10508.0
2018-11-21	DC	Futures	23.98	24.13	23.71	23.89	768.0
2018-11-21	DX	Futures	91.887	91.915	91.54	91.754	23452.0
2018-11-21	E1	Futures	1.19331	1.19639	1.19272	1.19449	19172.0
2018-11-21	E6	Futures	1.26649	1.27277	1.26621	1.26872	186238.0
2018-11-21	E7	Futures	1.2604	1.2665	1.2599	1.2625	3816.0
2018-11-21	EBM	Futures	206.9	207.16	206.12	207.16	21422.0
2018-11-21	ED	Futures	94.9914	94.9914	94.967	94.9719	353216.0
2018-11-21	ER	Futures	98.386	98.386	98.381	98.386	17193.0
2018-11-21	EW	Futures	1899.3	1938.5	1894.9	1921.8	13261.0
2018-11-21	FBON	Futures	126.84	127.05	126.84	126.96	600.0
2018-11-21	FBTP	Futures	104.25	104.85	103.76	104.56	150397.0
2018-11-21	FBTS	Futures	102.565	102.911	102.452	102.827	104110.0
2018-11-21	FCE	Futures	4413.6	4443.6	4398.4	4440.0	78214.0
2018-11-21	FDAX	Futures	11703.5	11840.8	11677.8	11830.8	112538.0
2018-11-21	FDXM	Futures	11500.9	11635.2	11476.1	11625.9	56064.0
2018-11-21	FESX	Futures	2621.8	2646.2	2619.3	2644.5	1121657.0
2018-11-21	FEU3	Futures	99.016	99.016	99.011	99.011	300.0
2018-11-21	FGBL	Futures	153.8	153.87	153.58	153.68	627640.0
2018-11-21	FGBM	Futures	131.36	131.39	131.27	131.32	402018.0
2018-11-21	FGBS	Futures	112.718	112.724	112.693	112.703	308348.0
2018-11-21	FGBX	Futures	178.48	178.64	177.88	177.9	43472.0
2018-11-21	FMWO	Futures	6594.0	6647.3	6590.5	6642.6	2928.0
2018-11-21	FOAT	Futures	140.58	140.63	140.42	140.57	137606.0
2018-11-21	FTDX	Futures	2452.2	2483.1	2439.4	2482.1	426.0
2018-11-21	FTI	Futures	475.18	480.79	475.18	479.92	26854.0
2018-11-21	FTUK	Futures	6188.8	6310.4	6182.1	6299.2	106679.0
2018-11-21	FVSA	Futures	350.78	353.8	343.72	345.74	37594.0
2018-11-21	FXXP	Futures	304.8	307.7	304.3	307.4	48528.0
2018-11-21	G	Futures	115.52	115.81	115.4	115.66	205638.0
2018-11-21	GF	Futures	316.863	322.89	316.54	319.93	6866.0
2018-11-21	GSCI	Futures	477.34	482.14	474.92	474.92	9.0

> showing 50 of 115 rows — these rows as CSV

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