PREVIEW / futures_daily / 2009-01-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-27.parquet
  size:    8 KB
  rows:    85

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-01-27	ES	Futures	787.06	800.28	784.94	792.49	1925806.0
2009-01-27	NQ	Futures	1320.34	1341.86	1315.03	1325.65	248890.0
2009-01-27	YM	Futures	7176.6	7279.8	7150.7	7205.9	187270.0
2009-01-27	CL	Futures	151.65	157.76	137.57	138.13	308439.0
2009-01-27	GC	Futures	1256.6	1261.9	1240.8	1250.9	49245.0
2009-01-27	ZN	Futures	94.546982	95.431492	94.355736	95.407587	461231.0
2009-01-27	A6	Futures	0.52321	0.53074	0.51893	0.52337	26344.0
2009-01-27	AD	Futures	0.80291	0.80802	0.79603	0.80104	25543.0
2009-01-27	B	Futures	48.96	50.39	45.89	46.08	85816.0
2009-01-27	B6	Futures	1.4547	1.479	1.446	1.4694	77924.0
2009-01-27	BFX	Futures	2078.4	2082.5	2037.6	2061.6	332.0
2009-01-27	BZ	Futures	49.17	49.17	47.36	47.36	84.0
2009-01-27	C	Futures	1953.0	2011.0	1921.0	1998.0	6495.0
2009-01-27	CB	Futures	76.837	76.837	76.837	76.837	2.0
2009-01-27	CC	Futures	2344.0	2446.0	2314.0	2422.0	7427.0
2009-01-27	CT	Futures	50.63	51.01	49.55	49.98	11313.0
2009-01-27	DC	Futures	26.97	26.97	26.59	26.7	125.0
2009-01-27	DX	Futures	88.263	88.45	87.367	88.066	3594.0
2009-01-27	E1	Futures	1.17099	1.17551	1.16301	1.16966	29653.0
2009-01-27	E6	Futures	1.56204	1.57684	1.5515	1.55884	179580.0
2009-01-27	E7	Futures	1.544	1.5587	1.5337	1.541	2553.0
2009-01-27	EBM	Futures	233.92	236.61	233.92	234.31	2985.0
2009-01-27	ED	Futures	93.1143	93.1849	93.0907	93.1708	191771.0
2009-01-27	ER	Futures	96.194	96.233	96.145	96.204	194027.0
2009-01-27	EW	Futures	490.9	500.3	489.5	496.6	26662.0
2009-01-27	FCE	Futures	1819.6	1841.9	1797.3	1827.6	117619.0
2009-01-27	FDAX	Futures	4727.0	4774.5	4663.7	4742.3	153889.0
2009-01-27	FESX	Futures	1278.3	1290.4	1258.8	1280.1	1161172.0
2009-01-27	FEU3	Futures	96.741	96.776	96.741	96.771	385.0
2009-01-27	FGBL	Futures	91.42	92.06	91.11	91.67	613836.0
2009-01-27	FGBM	Futures	96.71	96.9	96.43	96.71	413181.0
2009-01-27	FGBS	Futures	103.22	103.249	103.037	103.172	519249.0
2009-01-27	FGBX	Futures	80.62	82.54	80.43	82.42	2387.0
2009-01-27	FTDX	Futures	413.5	429.6	413.5	425.1	535.0
2009-01-27	FTI	Futures	198.58	200.64	194.91	199.91	33023.0
2009-01-27	FTUK	Futures	2724.3	2739.4	2681.7	2725.6	111501.0
2009-01-27	G	Futures	73.32	73.77	73.18	73.64	75693.0
2009-01-27	GF	Futures	257.33	258.452	253.052	253.262	637.0
2009-01-27	GSCI	Futures	816.88	817.34	778.65	780.76	213.0
2009-01-27	HE	Futures	121.398	121.93	116.469	117.339	6643.0
2009-01-27	HG	Futures	2.2329	2.2871	2.0472	2.0894	16624.0
2009-01-27	HO	Futures	1.577	1.6317	1.5149	1.5204	32671.0
2009-01-27	HRC	Futures	3189.6	3189.6	3189.6	3189.6	0.0
2009-01-27	J1	Futures	0.014195	0.0142974	0.0140321	0.014219	74374.0
2009-01-27	J7	Futures	0.013986	0.014119	0.013866	0.014048	78.0
2009-01-27	JB	Futures	116.4	116.86	116.28	116.29	1.0
2009-01-27	KC	Futures	349.97	352.68	343.96	348.39	10006.0
2009-01-27	KE	Futures	3104.08	3136.56	3050.37	3072.85	4996.0
2009-01-27	L	Futures	96.95	96.96	96.861	96.881	53080.0
2009-01-27	LBS	Futures	831.9	844.2	829.0	832.4	28.0

> showing 50 of 85 rows — these rows as CSV

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