PREVIEW / futures_daily / 2009-12-31

all futures daily files

  file:    by_date/futures_daily/2009/2009-12-31.parquet
  size:    8 KB
  rows:    78

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
2009-12-31	ES	Futures	1087.36	1090.76	1075.73	1076.7	638861.0
2009-12-31	NQ	Futures	2121.85	2128.63	2102.34	2102.34	112919.0
2009-12-31	YM	Futures	9577.4	9603.9	9463.2	9467.8	39645.0
2009-12-31	CL	Futures	188.01	189.72	187.73	188.2	120372.0
2009-12-31	GC	Futures	1505.9	1524.5	1504.6	1508.8	64594.0
2009-12-31	ZN	Futures	93.308043	93.308043	92.602786	93.056165	315230.0
2009-12-31	A6	Futures	0.72136	0.72713	0.7203	0.72461	32642.0
2009-12-31	AD	Futures	0.93592	0.94441	0.93542	0.94401	32266.0
2009-12-31	B	Futures	71.84	72.17	71.16	71.32	28611.0
2009-12-31	B6	Futures	1.6694	1.6856	1.6661	1.677	54286.0
2009-12-31	BFX	Futures	2861.1	2861.1	2844.7	2846.1	7.0
2009-12-31	BR	Futures	0.22982	0.23168	0.22982	0.22982	12.0
2009-12-31	C	Futures	2257.0	2283.0	2242.0	2283.0	2252.0
2009-12-31	CC	Futures	2795.0	2853.0	2777.0	2826.0	5648.0
2009-12-31	CT	Futures	61.55	61.92	61.45	61.63	3635.0
2009-12-31	DC	Futures	23.98	24.0	23.8	23.93	398.0
2009-12-31	DX	Futures	79.545	79.723	79.108	79.545	7947.0
2009-12-31	E1	Futures	1.27284	1.28247	1.27007	1.27495	27308.0
2009-12-31	E6	Futures	1.69753	1.70949	1.69339	1.69694	103125.0
2009-12-31	E7	Futures	1.6855	1.6976	1.6817	1.6851	1688.0
2009-12-31	EBM	Futures	226.47	226.89	224.78	225.62	342.0
2009-12-31	ED	Futures	94.3205	94.3205	94.3015	94.311	84528.0
2009-12-31	ER	Futures	97.228	97.242	97.228	97.233	15576.0
2009-12-31	EW	Futures	714.3	715.9	701.4	704.4	15639.0
2009-12-31	FCE	Futures	2577.6	2589.0	2569.7	2574.6	13677.0
2009-12-31	FTI	Futures	274.02	275.44	272.79	273.61	2561.0
2009-12-31	FTUK	Futures	3616.4	3616.8	3583.9	3591.0	20500.0
2009-12-31	G	Futures	74.79	75.22	74.69	75.15	16139.0
2009-12-31	GF	Futures	258.086	260.527	257.95	259.984	820.0
2009-12-31	GSCI	Futures	998.16	1003.46	995.12	995.31	243.0
2009-12-31	HE	Futures	87.245	88.65	87.178	87.78	8918.0
2009-12-31	HG	Futures	4.6118	4.6615	4.6022	4.6166	9792.0
2009-12-31	HO	Futures	1.9838	1.9984	1.9733	1.9753	9040.0
2009-12-31	HRC	Futures	2633.5	2633.5	2633.5	2633.5	10.0
2009-12-31	J1	Futures	0.0136238	0.0136993	0.0135131	0.0135156	52456.0
2009-12-31	J7	Futures	0.013457	0.013509	0.013338	0.013346	958.0
2009-12-31	KC	Futures	359.07	359.73	353.48	353.87	5256.0
2009-12-31	KE	Futures	2436.46	2464.72	2416.11	2425.15	3587.0
2009-12-31	L	Futures	97.769	97.799	97.769	97.789	12113.0
2009-12-31	LBS	Futures	768.8	773.8	767.5	772.8	316.0
2009-12-31	LE	Futures	139.612	141.903	139.53	141.003	22225.0
2009-12-31	MFS	Futures	1272.3	1272.3	1255.8	1259.7	443.0
2009-12-31	MME	Futures	837.4	839.2	829.9	832.6	585.0
2009-12-31	MP	Futures	0.0405	0.04065	0.04033	0.0405	7874.0
2009-12-31	N6	Futures	0.57397	0.57771	0.57158	0.57532	3651.0
2009-12-31	NG	Futures	185.85	191.189	179.209	181.39	59409.0
2009-12-31	NIY	Futures	8618.9	8651.3	8582.4	8606.7	2287.0
2009-12-31	NKD	Futures	10187.9	10187.9	10083.6	10116.8	1188.0
2009-12-31	NOK	Futures	0.169166	0.169166	0.167731	0.168209	45.0
2009-12-31	OJ	Futures	86.88	86.88	81.17	81.84	2882.0

> showing 50 of 78 rows — these rows as CSV

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