PREVIEW / futures_daily / 2019-12-27

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-27.parquet
  size:    10 KB
  rows:    120

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-12-27	ES	Futures	3501.4	3514.36	3494.38	3496.54	984389.0
2019-12-27	NQ	Futures	10094.92	10143.66	10058.21	10074.56	322888.0
2019-12-27	YM	Futures	30039.0	30162.9	30031.7	30046.4	121521.0
2019-12-27	CL	Futures	63.29	63.53	62.78	63.27	351899.0
2019-12-27	GC	Futures	1865.7	1869.9	1860.3	1867.7	204993.0
2019-12-27	ZN	Futures	127.266324	127.529591	127.250838	127.514105	667285.0
2019-12-27	A6	Futures	0.71332	0.71783	0.71301	0.71773	87785.0
2019-12-27	AD	Futures	0.76872	0.77184	0.76857	0.77159	62536.0
2019-12-27	ALI	Futures	2221.79	2221.79	2221.79	2221.79	5.0
2019-12-27	B	Futures	54.62	54.84	54.26	54.67	222365.0
2019-12-27	B6	Futures	1.3225	1.3334	1.3186	1.331	87806.0
2019-12-27	BR	Futures	0.20005	0.20107	0.19932	0.20013	23.0
2019-12-27	BTC	Futures	10982.5	11088.6	10732.3	11012.8	4441.0
2019-12-27	BZ	Futures	53.78	54.06	53.5	53.9	29265.0
2019-12-27	C	Futures	1672.0	1739.0	1672.0	1727.0	12471.0
2019-12-27	CB	Futures	248.779	248.779	247.659	247.659	9.0
2019-12-27	CC	Futures	1578.0	1646.0	1578.0	1633.0	27076.0
2019-12-27	CNH	Futures	6.971	6.9723	6.9657	6.967	163.0
2019-12-27	CSC	Futures	3.342	3.342	3.342	3.342	4.0
2019-12-27	CT	Futures	65.39	65.95	65.16	65.56	13708.0
2019-12-27	DC	Futures	27.8	27.94	27.8	27.94	63.0
2019-12-27	DX	Futures	94.288	94.303	93.696	93.707	14109.0
2019-12-27	E1	Futures	1.1717	1.18095	1.17056	1.1805	25805.0
2019-12-27	E6	Futures	1.20226	1.21158	1.20216	1.21137	172945.0
2019-12-27	E7	Futures	1.196	1.2053	1.196	1.2051	3606.0
2019-12-27	EBM	Futures	206.6	207.97	206.32	207.7	14811.0
2019-12-27	ED	Futures	95.2841	95.3035	95.2841	95.3035	104173.0
2019-12-27	ER	Futures	98.367	98.372	98.367	98.367	24321.0
2019-12-27	EW	Futures	2179.7	2187.4	2170.4	2174.3	9982.0
2019-12-27	FBON	Futures	143.29	143.47	143.29	143.39	109.0
2019-12-27	FBTP	Futures	127.96	128.29	127.38	128.13	30404.0
2019-12-27	FBTS	Futures	108.038	108.249	107.913	108.191	25112.0
2019-12-27	FCE	Futures	5477.0	5485.2	5446.7	5460.3	48197.0
2019-12-27	FDAX	Futures	14114.7	14167.6	14042.8	14087.3	70603.0
2019-12-27	FDIV	Futures	161.49	161.49	161.17	161.17	20.0
2019-12-27	FDXM	Futures	13932.4	13988.7	13866.6	13910.4	25395.0
2019-12-27	FESX	Futures	3325.0	3336.5	3312.7	3320.6	481165.0
2019-12-27	FEU3	Futures	99.075	99.075	99.075	99.075	100.0
2019-12-27	FGBL	Futures	163.99	164.09	163.73	163.91	168137.0
2019-12-27	FGBM	Futures	133.6	133.63	133.52	133.58	104487.0
2019-12-27	FGBS	Futures	112.689	112.694	112.654	112.669	140637.0
2019-12-27	FGBX	Futures	210.77	211.14	209.95	210.64	16117.0
2019-12-27	FMWO	Futures	7845.1	7913.2	7845.1	7897.3	2067.0
2019-12-27	FOAT	Futures	151.58	151.65	151.3	151.44	38256.0
2019-12-27	FTDX	Futures	3046.9	3054.4	3044.9	3047.4	84.0
2019-12-27	FTI	Futures	586.15	586.77	583.23	585.27	19301.0
2019-12-27	FTUK	Futures	7129.1	7154.0	7099.6	7117.4	59774.0
2019-12-27	FVSA	Futures	124.11	128.79	123.17	127.85	11010.0
2019-12-27	FXXP	Futures	382.1	382.5	380.1	381.2	29531.0
2019-12-27	G	Futures	120.29	120.59	120.19	120.47	71774.0

> showing 50 of 120 rows — these rows as CSV

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