PREVIEW / futures_daily / 2020-01-06

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-06.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-01-06	ES	Futures	3477.91	3509.5	3465.49	3503.02	1502748.0
2020-01-06	NQ	Futures	10061.94	10177.5	10005.45	10148.25	469514.0
2020-01-06	YM	Futures	29924.5	30140.9	29774.4	30080.0	218793.0
2020-01-06	CL	Futures	65.31	66.35	64.22	64.86	724236.0
2020-01-06	GC	Futures	1922.5	1957.2	1922.1	1930.0	558969.0
2020-01-06	ZN	Futures	128.350365	128.505227	128.009666	128.102584	1666524.0
2020-01-06	A6	Futures	0.71239	0.71455	0.71116	0.71209	94758.0
2020-01-06	AD	Futures	0.77592	0.77769	0.77577	0.77738	54162.0
2020-01-06	ALI	Futures	2221.49	2235.66	2221.49	2234.15	189.0
2020-01-06	B	Futures	56.7	57.84	55.77	56.34	341137.0
2020-01-06	B6	Futures	1.3273	1.3387	1.3272	1.3374	72218.0
2020-01-06	BR	Futures	0.19936	0.19997	0.19924	0.19957	32.0
2020-01-06	BTC	Futures	11270.5	11649.4	11194.7	11543.3	6104.0
2020-01-06	BZ	Futures	55.68	57.01	54.97	55.55	51933.0
2020-01-06	C	Futures	1737.0	1737.0	1692.0	1701.0	10294.0
2020-01-06	CB	Futures	247.099	247.099	242.442	243.179	94.0
2020-01-06	CC	Futures	1645.0	1647.0	1614.0	1625.0	15577.0
2020-01-06	CNH	Futures	6.9377	6.9511	6.9369	6.945	217.0
2020-01-06	CSC	Futures	3.344	3.351	3.333	3.35	139.0
2020-01-06	CT	Futures	65.91	66.68	65.91	66.62	21680.0
2020-01-06	DC	Futures	27.81	27.91	27.78	27.88	85.0
2020-01-06	DX	Futures	93.725	93.745	93.4	93.517	10956.0
2020-01-06	E1	Futures	1.18153	1.18621	1.1813	1.18484	24819.0
2020-01-06	E6	Futures	1.20749	1.21245	1.20722	1.21094	140402.0
2020-01-06	E7	Futures	1.2011	1.2062	1.2009	1.2047	2257.0
2020-01-06	EBM	Futures	206.6	208.52	206.05	206.87	19030.0
2020-01-06	ED	Futures	95.3374	95.3423	95.3229	95.3277	191549.0
2020-01-06	ER	Futures	98.372	98.377	98.372	98.377	43986.0
2020-01-06	ESG	Futures	288.14	289.29	288.14	289.29	20.0
2020-01-06	EW	Futures	2154.7	2165.8	2144.8	2163.9	14940.0
2020-01-06	FBON	Futures	144.23	144.23	143.45	143.74	162.0
2020-01-06	FBTP	Futures	128.72	128.84	128.24	128.47	47766.0
2020-01-06	FBTS	Futures	108.278	108.307	108.191	108.211	31882.0
2020-01-06	FCE	Futures	5425.4	5456.2	5390.1	5443.5	77151.0
2020-01-06	FDAX	Futures	13868.3	13915.4	13683.3	13868.3	129081.0
2020-01-06	FDIV	Futures	158.01	158.39	156.62	158.39	267.0
2020-01-06	FDXM	Futures	13704.7	13738.1	13511.5	13694.3	55443.0
2020-01-06	FESX	Futures	3290.7	3301.3	3256.3	3293.3	870867.0
2020-01-06	FGBL	Futures	164.72	164.86	164.35	164.52	496635.0
2020-01-06	FGBM	Futures	133.92	133.92	133.74	133.79	264931.0
2020-01-06	FGBS	Futures	112.709	112.714	112.679	112.689	229076.0
2020-01-06	FGBX	Futures	212.9	213.3	211.71	212.29	39654.0
2020-01-06	FMWO	Futures	7844.0	7895.0	7805.5	7864.4	1148.0
2020-01-06	FOAT	Futures	152.01	152.18	151.82	151.98	102854.0
2020-01-06	FTDX	Futures	3009.7	3018.2	2969.0	3015.2	143.0
2020-01-06	FTI	Futures	581.02	582.89	576.14	581.44	31016.0
2020-01-06	FTUK	Futures	7050.3	7070.5	7001.5	7040.9	91580.0
2020-01-06	FVSA	Futures	136.75	141.9	132.07	134.88	35785.0
2020-01-06	FXXP	Futures	377.3	378.9	374.1	378.0	45762.0
2020-01-06	G	Futures	120.97	120.97	120.19	120.35	183580.0

> showing 50 of 119 rows — these rows as CSV

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