PREVIEW / futures_daily / 2009-04-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-04-27.parquet
  size:    8 KB
  rows:    86

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-04-27	ES	Futures	822.76	825.14	807.03	816.56	2460914.0
2009-04-27	NQ	Futures	1536.96	1554.38	1517.02	1542.86	283010.0
2009-04-27	YM	Futures	7209.1	7242.3	7085.3	7177.7	168139.0
2009-04-27	CL	Futures	138.58	138.58	129.31	135.05	265293.0
2009-04-27	GC	Futures	1266.9	1273.4	1254.2	1257.5	59465.0
2009-04-27	ZN	Futures	94.536504	95.034128	94.500092	94.997717	609303.0
2009-04-27	A6	Futures	0.57373	0.57381	0.56344	0.56512	40782.0
2009-04-27	AD	Futures	0.81364	0.81551	0.80596	0.80744	42503.0
2009-04-27	B	Futures	49.98	50.31	47.7	49.45	51610.0
2009-04-27	B6	Futures	1.5253	1.5289	1.51	1.5228	60426.0
2009-04-27	BFX	Futures	2097.9	2099.0	2073.7	2099.0	69.0
2009-04-27	BR	Futures	0.17202	0.17202	0.1699	0.1699	1.0
2009-04-27	BZ	Futures	52.76	54.49	52.76	53.59	5.0
2009-04-27	C	Futures	1856.0	1856.0	1831.0	1840.0	1161.0
2009-04-27	CC	Futures	2145.0	2145.0	2090.0	2101.0	4136.0
2009-04-27	CT	Futures	48.11	49.38	47.49	49.1	10134.0
2009-04-27	DC	Futures	26.71	26.71	26.28	26.42	156.0
2009-04-27	DX	Futures	87.39	88.636	87.39	88.477	4285.0
2009-04-27	E1	Futures	1.16536	1.16788	1.14322	1.14746	29459.0
2009-04-27	E6	Futures	1.5696	1.56972	1.54044	1.54328	152030.0
2009-04-27	E7	Futures	1.5516	1.5516	1.5227	1.5254	2570.0
2009-04-27	EBM	Futures	215.56	216.72	214.01	215.95	4104.0
2009-04-27	ED	Futures	93.3179	93.365	93.3037	93.3367	180123.0
2009-04-27	ER	Futures	96.679	96.694	96.669	96.674	71141.0
2009-04-27	EW	Futures	531.9	533.3	520.0	526.7	43797.0
2009-04-27	FCE	Futures	1921.2	1949.1	1903.7	1943.4	122714.0
2009-04-27	FDAX	Futures	5050.8	5144.4	4986.5	5133.0	156122.0
2009-04-27	FESX	Futures	1341.1	1359.7	1325.5	1358.5	1120678.0
2009-04-27	FEU3	Futures	97.259	97.268	97.254	97.259	265.0
2009-04-27	FGBL	Futures	92.63	93.11	92.58	92.67	627343.0
2009-04-27	FGBM	Futures	97.79	98.05	97.67	97.74	391872.0
2009-04-27	FGBS	Futures	103.752	103.839	103.675	103.695	513820.0
2009-04-27	FGBX	Futures	83.92	84.14	83.4	83.51	1472.0
2009-04-27	FTDX	Futures	500.9	508.1	494.6	505.4	260.0
2009-04-27	FTI	Futures	192.84	195.68	191.19	194.73	32318.0
2009-04-27	FTUK	Futures	2709.4	2755.0	2694.0	2750.0	89777.0
2009-04-27	G	Futures	76.97	77.11	76.53	76.6	62940.0
2009-04-27	GF	Futures	274.769	277.561	273.094	275.328	714.0
2009-04-27	GSCI	Futures	748.53	773.63	745.34	766.08	391.0
2009-04-27	HE	Futures	108.92	115.727	108.92	108.92	495.0
2009-04-27	HG	Futures	2.8757	2.9109	2.7442	2.7934	11809.0
2009-04-27	HO	Futures	1.501	1.5055	1.4118	1.4633	35759.0
2009-04-27	HRC	Futures	2595.1	2595.1	2595.1	2595.1	0.0
2009-04-27	J1	Futures	0.0130173	0.0130778	0.0129845	0.0130387	57866.0
2009-04-27	J7	Futures	0.012822	0.012898	0.012822	0.012862	39.0
2009-04-27	JB	Futures	114.96	114.98	114.4	114.5	2541.0
2009-04-27	KC	Futures	328.35	329.04	316.71	319.76	9402.0
2009-04-27	KE	Futures	2876.7	2915.71	2784.06	2786.5	9715.0
2009-04-27	L	Futures	96.993	97.013	96.964	96.974	43471.0
2009-04-27	LBS	Futures	895.0	895.0	862.8	864.4	196.0

> showing 50 of 86 rows — these rows as CSV

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