PREVIEW / futures_daily / 2011-09-01

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-01.parquet
  size:    9 KB
  rows:    97

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
2011-09-01	ES	Futures	1209.64	1220.07	1192.51	1193.0	2656315.0
2011-09-01	NQ	Futures	2554.8	2577.86	2522.92	2524.91	262316.0
2011-09-01	YM	Futures	10977.1	11066.0	10834.3	10839.1	114686.0
2011-09-01	CL	Futures	169.02	171.25	168.03	169.4	282342.0
2011-09-01	GC	Futures	2465.7	2475.6	2451.2	2469.6	138082.0
2011-09-01	ZN	Futures	110.657455	111.282789	110.378051	111.216264	243878.0
2011-09-01	A6	Futures	0.92805	0.93466	0.92535	0.93275	101417.0
2011-09-01	AD	Futures	1.02012	1.02481	1.01832	1.02281	75215.0
2011-09-01	B	Futures	97.89	98.25	96.84	97.34	92256.0
2011-09-01	B6	Futures	1.6905	1.6909	1.6778	1.6825	92771.0
2011-09-01	BFX	Futures	2712.6	2727.6	2709.8	2727.6	25.0
2011-09-01	BR	Futures	0.2787	0.2787	0.27576	0.27734	70.0
2011-09-01	BZ	Futures	100.95	101.72	100.83	100.83	705.0
2011-09-01	C	Futures	2094.0	2104.0	2075.0	2086.0	1180.0
2011-09-01	CC	Futures	2449.0	2452.0	2398.0	2411.0	6516.0
2011-09-01	CSC	Futures	4.434	4.434	4.434	4.434	15.0
2011-09-01	CT	Futures	138.6	138.86	137.66	137.66	83.0
2011-09-01	DC	Futures	30.31	30.38	30.25	30.33	119.0
2011-09-01	DX	Futures	73.519	74.143	73.484	73.838	25367.0
2011-09-01	E1	Futures	1.62226	1.65064	1.61703	1.64737	26007.0
2011-09-01	E6	Futures	1.70742	1.70765	1.68936	1.69483	290076.0
2011-09-01	E7	Futures	1.6947	1.6949	1.677	1.6824	4027.0
2011-09-01	ED	Futures	94.9382	94.943	94.9239	94.9358	165719.0
2011-09-01	ER	Futures	97.479	97.499	97.474	97.484	90210.0
2011-09-01	EW	Futures	867.9	875.9	850.4	852.1	29625.0
2011-09-01	FBTP	Futures	64.17	64.17	63.92	64.14	8628.0
2011-09-01	FCE	Futures	2285.3	2310.3	2246.7	2289.9	125298.0
2011-09-01	FDAX	Futures	6173.3	6194.7	6024.3	6116.1	202783.0
2011-09-01	FESX	Futures	1479.1	1492.6	1451.5	1474.0	1448947.0
2011-09-01	FEU3	Futures	98.019	98.029	98.019	98.024	27.0
2011-09-01	FGBL	Futures	107.7	108.73	107.67	108.54	1105867.0
2011-09-01	FGBM	Futures	109.45	110.07	109.42	109.95	637217.0
2011-09-01	FGBS	Futures	108.78	108.974	108.75	108.92	696586.0
2011-09-01	FGBX	Futures	105.19	106.52	105.14	106.3	7291.0
2011-09-01	FTDX	Futures	679.2	682.8	663.1	670.3	307.0
2011-09-01	FTI	Futures	238.62	241.56	236.46	240.05	38702.0
2011-09-01	FTUK	Futures	3791.8	3841.2	3766.4	3804.8	125991.0
2011-09-01	FVSA	Futures	13272.74	13874.29	13020.49	13427.98	1702.0
2011-09-01	FXXP	Futures	160.3	162.3	159.2	161.3	471.0
2011-09-01	G	Futures	89.55	90.07	89.42	90.01	146330.0
2011-09-01	GF	Futures	302.807	304.638	301.375	303.951	576.0
2011-09-01	GSCI	Futures	1050.3	1059.23	1049.44	1051.01	226.0
2011-09-01	HE	Futures	104.122	104.642	103.145	104.031	22289.0
2011-09-01	HG	Futures	5.5571	5.5598	5.4605	5.5055	27128.0
2011-09-01	HO	Futures	2.4875	2.4932	2.463	2.4654	19832.0
2011-09-01	HRC	Futures	2910.3	2910.3	2910.3	2910.3	0.0
2011-09-01	J1	Futures	0.0163952	0.0163964	0.0162695	0.0163638	104455.0
2011-09-01	J7	Futures	0.016274	0.016281	0.016165	0.016254	528.0
2011-09-01	JB	Futures	123.96	124.01	123.69	123.79	2847.0
2011-09-01	KC	Futures	676.66	685.38	665.93	682.78	11083.0

> showing 50 of 97 rows — these rows as CSV

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