PREVIEW / futures_daily / 2009-06-30

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-30.parquet
  size:    8 KB
  rows:    84

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-06-30	ES	Futures	884.12	888.68	871.41	878.37	2062874.0
2009-06-30	NQ	Futures	1667.85	1679.95	1650.67	1662.5	242467.0
2009-06-30	YM	Futures	7631.2	7673.6	7519.4	7573.5	134283.0
2009-06-30	CL	Futures	188.39	193.07	181.29	183.89	331550.0
2009-06-30	GC	Futures	1298.8	1308.9	1277.4	1284.0	102293.0
2009-06-30	ZN	Futures	91.790779	91.88928	91.224397	91.618402	880715.0
2009-06-30	A6	Futures	0.64539	0.65174	0.64234	0.64523	67108.0
2009-06-30	AD	Futures	0.85388	0.85852	0.84864	0.85042	61266.0
2009-06-30	B	Futures	68.4	70.47	65.69	66.54	60522.0
2009-06-30	B6	Futures	1.7249	1.7438	1.7102	1.7147	127499.0
2009-06-30	BFX	Futures	2333.1	2335.4	2298.9	2313.0	81.0
2009-06-30	BR	Futures	0.19823	0.19823	0.19481	0.19484	19.0
2009-06-30	C	Futures	1709.0	1741.0	1679.0	1708.0	2977.0
2009-06-30	CC	Futures	2287.0	2301.0	2217.0	2232.0	8298.0
2009-06-30	CT	Futures	49.0	50.39	47.69	49.21	245.0
2009-06-30	DC	Futures	20.83	20.9	20.47	20.49	215.0
2009-06-30	DX	Futures	81.939	82.538	81.571	82.318	6435.0
2009-06-30	E1	Futures	1.22292	1.2294	1.21656	1.22054	40773.0
2009-06-30	E6	Futures	1.67049	1.67963	1.6617	1.66669	233978.0
2009-06-30	E7	Futures	1.653	1.6625	1.6448	1.6496	2939.0
2009-06-30	ED	Futures	93.7961	93.8055	93.7772	93.7914	119516.0
2009-06-30	ER	Futures	96.914	96.919	96.89	96.904	144780.0
2009-06-30	EW	Futures	559.4	563.1	552.2	557.7	35346.0
2009-06-30	FCE	Futures	2080.3	2090.4	2035.9	2046.7	133840.0
2009-06-30	FDAX	Futures	5359.1	5384.9	5256.0	5287.8	130781.0
2009-06-30	FESX	Futures	1451.1	1457.7	1423.1	1430.8	1039708.0
2009-06-30	FEU3	Futures	97.485	97.485	97.48	97.48	430.0
2009-06-30	FGBL	Futures	92.14	92.15	91.79	92.03	659386.0
2009-06-30	FGBM	Futures	97.94	97.95	97.67	97.86	409530.0
2009-06-30	FGBS	Futures	103.955	103.988	103.858	103.926	505155.0
2009-06-30	FGBX	Futures	82.73	83.06	82.57	83.04	3691.0
2009-06-30	FTDX	Futures	557.7	567.5	555.0	559.5	732.0
2009-06-30	FTI	Futures	209.76	210.45	205.74	206.92	32677.0
2009-06-30	FTUK	Futures	2838.2	2838.5	2785.4	2799.7	123457.0
2009-06-30	G	Futures	76.07	76.25	75.55	75.75	104856.0
2009-06-30	GF	Futures	280.729	285.071	280.178	283.417	5409.0
2009-06-30	GSCI	Futures	961.96	963.62	928.78	938.59	476.0
2009-06-30	HE	Futures	85.316	86.741	84.767	85.791	4122.0
2009-06-30	HG	Futures	3.2688	3.3207	3.141	3.1902	20695.0
2009-06-30	HO	Futures	1.9026	1.9439	1.8314	1.8595	15354.0
2009-06-30	HRC	Futures	2382.2	2382.2	2382.2	2382.2	0.0
2009-06-30	J1	Futures	0.0131154	0.0132211	0.0130524	0.0130776	96228.0
2009-06-30	J7	Futures	0.012931	0.013027	0.012878	0.012897	48.0
2009-06-30	JB	Futures	116.21	116.48	116.05	116.4	2574.0
2009-06-30	KC	Futures	325.07	329.81	322.08	325.34	6066.0
2009-06-30	KE	Futures	2847.84	2885.01	2699.15	2781.89	14261.0
2009-06-30	L	Futures	97.092	97.111	97.082	97.111	38031.0
2009-06-30	LBS	Futures	891.2	901.3	869.8	871.6	353.0
2009-06-30	LE	Futures	150.149	151.207	149.18	150.237	29210.0
2009-06-30	MP	Futures	0.03932	0.03952	0.03923	0.0394	9306.0

> showing 50 of 84 rows — these rows as CSV

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