PREVIEW / futures_daily / 2020-06-30

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-30.parquet
  size:    10 KB
  rows:    119

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
2020-06-30	ES	Futures	3428.54	3490.73	3410.81	3478.35	1724164.0
2020-06-30	NQ	Futures	11586.66	11805.44	11537.05	11777.3	422348.0
2020-06-30	YM	Futures	27305.6	27619.6	27114.9	27530.7	200320.0
2020-06-30	CL	Futures	28.74	29.06	28.16	28.47	370059.0
2020-06-30	GC	Futures	2142.1	2165.9	2130.9	2161.7	199417.0
2020-06-30	ZN	Futures	138.125099	138.187038	137.846371	137.923795	1240939.0
2020-06-30	A6	Futures	0.70629	0.71133	0.70311	0.70979	96937.0
2020-06-30	AD	Futures	0.74312	0.74814	0.74109	0.74728	72840.0
2020-06-30	ALI	Futures	1964.65	1964.65	1964.65	1964.65	0.0
2020-06-30	B	Futures	27.21	27.35	26.7	26.89	245222.0
2020-06-30	B6	Futures	1.2494	1.2598	1.2452	1.2588	99347.0
2020-06-30	BR	Futures	0.14619	0.14619	0.14385	0.14548	205.0
2020-06-30	BTC	Futures	12746.8	12801.9	12533.3	12650.4	2856.0
2020-06-30	BZ	Futures	26.55	26.74	26.11	26.29	29381.0
2020-06-30	C	Futures	1679.0	1679.0	1548.0	1553.0	21367.0
2020-06-30	CB	Futures	202.743	204.375	202.743	204.348	64.0
2020-06-30	CC	Futures	1471.0	1476.0	1425.0	1434.0	21815.0
2020-06-30	CNH	Futures	6.9977	7.0007	6.9837	6.9899	157.0
2020-06-30	CSC	Futures	3.673	3.745	3.673	3.708	59.0
2020-06-30	CT	Futures	61.06	62.18	60.7	62.18	6.0
2020-06-30	DC	Futures	30.27	30.97	30.17	30.55	313.0
2020-06-30	DX	Futures	94.072	94.478	93.874	94.033	18344.0
2020-06-30	E1	Futures	1.1965	1.20297	1.194	1.20161	25854.0
2020-06-30	E6	Futures	1.20795	1.21047	1.20264	1.20752	197872.0
2020-06-30	E7	Futures	1.202	1.2044	1.1967	1.2015	6301.0
2020-06-30	EBM	Futures	213.47	216.76	213.47	216.16	21863.0
2020-06-30	ED	Futures	96.4088	96.4185	96.4088	96.4088	90307.0
2020-06-30	ER	Futures	98.372	98.386	98.372	98.377	82929.0
2020-06-30	ESG	Futures	276.12	281.3	276.12	280.62	284.0
2020-06-30	EW	Futures	1867.0	1897.5	1856.7	1892.2	16237.0
2020-06-30	FBON	Futures	144.99	145.2	144.79	144.98	394.0
2020-06-30	FBTP	Futures	129.61	130.24	129.44	130.15	101888.0
2020-06-30	FBTS	Futures	108.405	108.454	108.357	108.444	43513.0
2020-06-30	FCE	Futures	4824.2	4852.6	4780.1	4814.9	57462.0
2020-06-30	FDAX	Futures	13022.2	13165.6	12930.8	13094.4	85360.0
2020-06-30	FDXM	Futures	13016.0	13117.6	12884.7	13047.2	44679.0
2020-06-30	FESX	Futures	2972.4	2993.6	2945.6	2976.1	965059.0
2020-06-30	FEU3	Futures	99.134	99.134	99.129	99.129	20.0
2020-06-30	FGBL	Futures	168.69	168.98	168.31	168.66	534564.0
2020-06-30	FGBM	Futures	134.91	135.01	134.83	134.93	328814.0
2020-06-30	FGBS	Futures	112.8	112.815	112.78	112.805	274878.0
2020-06-30	FGBX	Futures	227.03	228.17	225.05	226.81	49400.0
2020-06-30	FMWO	Futures	7626.1	7747.0	7607.1	7688.9	1763.0
2020-06-30	FOAT	Futures	155.55	155.88	155.27	155.6	133336.0
2020-06-30	FTDX	Futures	2972.9	3015.3	2972.9	3006.7	62.0
2020-06-30	FTI	Futures	519.96	523.9	515.09	518.98	27310.0
2020-06-30	FTUK	Futures	5873.1	5882.5	5770.5	5810.2	104888.0
2020-06-30	FVSA	Futures	285.24	289.27	266.85	275.37	14303.0
2020-06-30	FXXP	Futures	331.1	333.0	328.6	331.3	44998.0
2020-06-30	G	Futures	127.39	127.56	127.08	127.25	203746.0

> showing 50 of 119 rows — these rows as CSV

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