PREVIEW / futures_daily / 2010-09-20

all futures daily files

  file:    by_date/futures_daily/2010/2010-09-20.parquet
  size:    9 KB
  rows:    89

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
2010-09-20	ES	Futures	1096.31	1117.63	1094.84	1113.95	1789965.0
2010-09-20	NQ	Futures	2211.66	2257.3	2207.97	2247.09	284093.0
2010-09-20	YM	Futures	9799.0	9960.0	9782.3	9929.3	113589.0
2010-09-20	CL	Futures	155.89	159.95	155.39	158.74	292953.0
2010-09-20	GC	Futures	1736.7	1746.9	1733.9	1740.9	81224.0
2010-09-20	ZN	Futures	102.548195	102.793371	102.432059	102.741755	859955.0
2010-09-20	A6	Futures	0.77886	0.78876	0.77777	0.78717	64434.0
2010-09-20	AD	Futures	0.95735	0.96369	0.95567	0.96132	55974.0
2010-09-20	B	Futures	67.44	68.92	66.94	68.4	142203.0
2010-09-20	B6	Futures	1.6238	1.6276	1.6119	1.6126	76305.0
2010-09-20	BFX	Futures	2943.1	2974.5	2931.8	2970.8	95.0
2010-09-20	BR	Futures	0.24555	0.2461	0.24409	0.24416	111.0
2010-09-20	BZ	Futures	71.13	73.13	71.09	72.6	218.0
2010-09-20	C	Futures	2063.0	2066.0	2032.0	2036.0	5380.0
2010-09-20	CB	Futures	95.396	95.535	95.396	95.479	25.0
2010-09-20	CC	Futures	2266.0	2293.0	2231.0	2249.0	5530.0
2010-09-20	CT	Futures	84.08	85.39	83.87	84.43	170.0
2010-09-20	DC	Futures	25.47	25.85	25.42	25.75	209.0
2010-09-20	DX	Futures	81.925	82.0	81.514	81.842	15470.0
2010-09-20	E1	Futures	1.30098	1.31017	1.29835	1.30623	26960.0
2010-09-20	E6	Futures	1.54305	1.55168	1.54068	1.54435	231078.0
2010-09-20	E7	Futures	1.5316	1.5399	1.529	1.5326	2407.0
2010-09-20	ED	Futures	94.665	94.6841	94.6555	94.6746	123991.0
2010-09-20	ER	Futures	97.286	97.311	97.281	97.296	105920.0
2010-09-20	EW	Futures	762.6	778.6	761.3	775.3	24561.0
2010-09-20	FBTP	Futures	66.59	66.7	66.32	66.41	3356.0
2010-09-20	FCE	Futures	2458.0	2501.6	2451.4	2485.2	124318.0
2010-09-20	FDAX	Futures	6720.3	6805.8	6698.2	6775.1	128101.0
2010-09-20	FESX	Futures	1722.5	1752.5	1716.9	1740.6	1039996.0
2010-09-20	FEU3	Futures	97.855	97.864	97.855	97.859	808.0
2010-09-20	FGBL	Futures	102.67	102.7	102.22	102.32	681796.0
2010-09-20	FGBM	Futures	105.94	105.97	105.69	105.77	313290.0
2010-09-20	FGBS	Futures	107.524	107.533	107.44	107.469	277372.0
2010-09-20	FGBX	Futures	104.74	105.07	103.84	104.33	3052.0
2010-09-20	FTDX	Futures	685.7	695.0	684.0	687.5	147.0
2010-09-20	FTI	Futures	269.53	274.18	269.33	272.5	30359.0
2010-09-20	FTUK	Futures	3816.4	3881.7	3811.2	3852.3	92078.0
2010-09-20	G	Futures	83.14	83.31	82.94	83.05	73415.0
2010-09-20	GF	Futures	279.778	279.778	276.761	278.521	2333.0
2010-09-20	GSCI	Futures	879.36	891.54	879.36	887.7	48.0
2010-09-20	HE	Futures	102.779	104.132	102.474	103.895	10778.0
2010-09-20	HG	Futures	4.6988	4.7455	4.6641	4.6774	17602.0
2010-09-20	HH	Futures	35.739	35.739	35.739	35.739	200.0
2010-09-20	HO	Futures	1.8003	1.8413	1.7923	1.8305	23308.0
2010-09-20	HRC	Futures	2707.8	2707.8	2707.8	2707.8	0.0
2010-09-20	J1	Futures	0.0146625	0.0147065	0.0146562	0.0146625	53612.0
2010-09-20	J7	Futures	0.014572	0.014604	0.014557	0.014562	55.0
2010-09-20	KC	Futures	471.18	473.04	448.74	451.22	18452.0
2010-09-20	KE	Futures	3206.23	3265.68	3149.91	3160.34	13424.0
2010-09-20	L	Futures	98.115	98.115	98.096	98.106	26732.0

> showing 50 of 89 rows — these rows as CSV

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