PREVIEW / futures_daily / 2011-09-21

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-21.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-21	ES	Futures	1194.65	1201.64	1152.97	1153.72	3254771.0
2011-09-21	NQ	Futures	2621.93	2645.9	2561.71	2563.14	353504.0
2011-09-21	YM	Futures	10893.9	10957.3	10569.2	10574.0	159905.0
2011-09-21	CL	Futures	163.12	165.91	159.62	162.01	298905.0
2011-09-21	GC	Futures	2438.4	2456.5	2404.6	2441.2	190869.0
2011-09-21	ZN	Futures	111.978643	112.367457	111.68368	112.193161	1133753.0
2011-09-21	A6	Futures	0.89328	0.89556	0.87287	0.88158	152111.0
2011-09-21	AD	Futures	1.00596	1.00706	0.98945	0.99545	123455.0
2011-09-21	B	Futures	94.6	96.48	93.46	94.69	201828.0
2011-09-21	B6	Futures	1.6413	1.6417	1.615	1.6246	149388.0
2011-09-21	BFX	Futures	2555.8	2555.8	2534.6	2542.8	152.0
2011-09-21	BR	Futures	0.2429	0.2429	0.23714	0.24085	1031.0
2011-09-21	BZ	Futures	98.32	99.9	96.97	98.09	1922.0
2011-09-21	C	Futures	1875.0	1890.0	1859.0	1885.0	5377.0
2011-09-21	CB	Futures	94.245	94.519	94.245	94.245	8.0
2011-09-21	CC	Futures	2141.0	2152.0	2087.0	2138.0	8728.0
2011-09-21	CT	Futures	134.78	134.78	131.4	131.42	26.0
2011-09-21	DC	Futures	29.27	29.96	29.27	29.72	190.0
2011-09-21	DX	Futures	76.034	77.02	75.823	76.435	44426.0
2011-09-21	E1	Futures	1.48325	1.48548	1.45976	1.47052	28050.0
2011-09-21	E6	Futures	1.63648	1.64832	1.61999	1.63326	352799.0
2011-09-21	E7	Futures	1.6223	1.6347	1.606	1.6193	5890.0
2011-09-21	ED	Futures	95.0318	95.0557	94.9746	94.9984	470510.0
2011-09-21	ER	Futures	97.42	97.475	97.406	97.46	169555.0
2011-09-21	EW	Futures	843.5	848.9	810.9	811.1	39015.0
2011-09-21	FBTP	Futures	61.45	61.45	61.09	61.23	8554.0
2011-09-21	FBTS	Futures	81.558	81.606	81.47	81.566	1509.0
2011-09-21	FCE	Futures	2118.5	2137.1	2061.0	2103.8	117910.0
2011-09-21	FDAX	Futures	6009.5	6067.5	5804.8	5910.6	174096.0
2011-09-21	FESX	Futures	1404.1	1420.1	1360.9	1388.2	1326039.0
2011-09-21	FEU3	Futures	98.004	98.019	98.004	98.019	1.0
2011-09-21	FGBL	Futures	111.29	111.6	110.98	111.49	797817.0
2011-09-21	FGBM	Futures	111.1	111.19	110.91	111.1	366558.0
2011-09-21	FGBS	Futures	109.213	109.258	109.163	109.218	461415.0
2011-09-21	FGBX	Futures	113.77	114.23	113.04	114.01	3142.0
2011-09-21	FTDX	Futures	635.7	638.5	621.0	628.8	175.0
2011-09-21	FTI	Futures	230.47	232.13	225.32	229.02	45580.0
2011-09-21	FTUK	Futures	3803.7	3838.2	3707.6	3765.0	122788.0
2011-09-21	FVSA	Futures	17349.44	17856.61	17116.99	17645.29	4078.0
2011-09-21	FXXP	Futures	158.6	159.2	156.2	156.5	544.0
2011-09-21	G	Futures	92.17	92.48	91.86	92.2	159807.0
2011-09-21	GF	Futures	311.435	313.643	309.284	311.322	2407.0
2011-09-21	GSCI	Futures	1015.37	1026.46	1000.4	1005.95	109.0
2011-09-21	HE	Futures	106.655	108.262	106.655	108.101	19456.0
2011-09-21	HG	Futures	4.9074	5.0073	4.8842	4.9808	47268.0
2011-09-21	HO	Futures	2.3897	2.4234	2.3525	2.3722	23292.0
2011-09-21	HRC	Futures	2869.6	2869.6	2869.6	2869.6	0.0
2011-09-21	J1	Futures	0.0164567	0.016527	0.0163901	0.0164202	95610.0
2011-09-21	J7	Futures	0.016357	0.016423	0.016293	0.016321	527.0
2011-09-21	JB	Futures	124.63	124.64	124.53	124.63	1451.0

> showing 50 of 97 rows — these rows as CSV

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