PREVIEW / futures_daily / 2019-11-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-18.parquet
  size:    10 KB
  rows:    122

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-11-18	ES	Futures	3376.53	3386.0	3367.87	3379.5	1034214.0
2019-11-18	NQ	Futures	9586.7	9642.3	9541.18	9603.7	370609.0
2019-11-18	YM	Futures	29352.2	29456.1	29316.5	29402.5	127718.0
2019-11-18	CL	Futures	59.19	59.4	57.83	58.35	420045.0
2019-11-18	GC	Futures	1810.6	1818.7	1796.8	1815.7	331235.0
2019-11-18	ZN	Futures	127.978665	128.288354	127.808337	128.164478	1198151.0
2019-11-18	A6	Futures	0.69978	0.7005	0.69804	0.69937	82299.0
2019-11-18	AD	Futures	0.76186	0.76312	0.76111	0.76262	60752.0
2019-11-18	ALI	Futures	2144.2	2147.23	2139.34	2140.55	127.0
2019-11-18	B	Futures	50.54	50.7	49.4	49.8	228249.0
2019-11-18	B6	Futures	1.3142	1.3215	1.3136	1.3182	87892.0
2019-11-18	BFX	Futures	4718.2	4718.2	4701.9	4701.9	50.0
2019-11-18	BR	Futures	0.19404	0.19433	0.19138	0.19243	6157.0
2019-11-18	BTC	Futures	12346.7	12368.4	11559.7	11848.5	4004.0
2019-11-18	BZ	Futures	49.8	50.02	48.73	49.12	29294.0
2019-11-18	C	Futures	1809.0	1813.0	1791.0	1797.0	1777.0
2019-11-18	CB	Futures	249.105	249.105	247.363	247.895	7.0
2019-11-18	CC	Futures	1757.0	1762.0	1740.0	1743.0	18761.0
2019-11-18	CNH	Futures	7.0044	7.0218	7.0011	7.0152	641.0
2019-11-18	CSC	Futures	3.357	3.357	3.297	3.321	90.0
2019-11-18	CT	Futures	63.17	63.17	61.82	62.5	8768.0
2019-11-18	DC	Futures	27.89	27.89	27.54	27.72	415.0
2019-11-18	DX	Futures	94.594	94.594	94.285	94.394	12901.0
2019-11-18	E1	Futures	1.16462	1.16807	1.16255	1.16588	25317.0
2019-11-18	E6	Futures	1.20006	1.20412	1.1999	1.20244	134057.0
2019-11-18	E7	Futures	1.1937	1.1979	1.1936	1.1962	2446.0
2019-11-18	EBM	Futures	194.0	195.09	193.72	194.82	26072.0
2019-11-18	ED	Futures	95.3326	95.3472	95.3277	95.3472	260984.0
2019-11-18	ER	Futures	98.396	98.396	98.391	98.396	35018.0
2019-11-18	ESG	Futures	278.54	278.67	277.25	278.67	45.0
2019-11-18	EW	Futures	2101.0	2106.4	2092.2	2098.2	9432.0
2019-11-18	FBON	Futures	142.81	143.13	142.63	143.03	716.0
2019-11-18	FBTP	Futures	128.84	129.28	128.62	128.97	70082.0
2019-11-18	FBTS	Futures	108.028	108.105	107.98	108.066	36129.0
2019-11-18	FCE	Futures	5366.5	5375.1	5332.1	5359.3	59727.0
2019-11-18	FDAX	Futures	13945.5	14016.7	13856.3	13916.5	91203.0
2019-11-18	FDIV	Futures	160.98	160.98	160.19	160.66	90.0
2019-11-18	FDXM	Futures	13770.2	13833.7	13675.4	13734.7	45585.0
2019-11-18	FESX	Futures	3243.9	3255.3	3228.1	3239.5	721122.0
2019-11-18	FGBL	Futures	165.08	165.25	164.75	165.03	481338.0
2019-11-18	FGBM	Futures	133.93	133.96	133.79	133.87	321321.0
2019-11-18	FGBS	Futures	112.724	112.724	112.684	112.699	191427.0
2019-11-18	FGBX	Futures	215.19	215.57	213.86	214.72	41270.0
2019-11-18	FMWO	Futures	7632.6	7637.2	7592.8	7611.0	7383.0
2019-11-18	FOAT	Futures	152.37	152.62	152.18	152.45	101015.0
2019-11-18	FTDX	Futures	2987.5	2994.4	2957.9	2973.7	160.0
2019-11-18	FTI	Futures	572.87	574.3	570.38	572.5	21981.0
2019-11-18	FTUK	Futures	6762.0	6792.6	6752.3	6762.0	70059.0
2019-11-18	FVSA	Futures	135.82	138.86	133.8	135.82	44626.0
2019-11-18	FXXP	Futures	366.8	368.0	365.6	366.5	57735.0

> showing 50 of 122 rows — these rows as CSV

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