PREVIEW / futures_daily / 2012-08-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-27.parquet
  size:    9 KB
  rows:    94

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
2012-08-27	ES	Futures	1427.94	1434.01	1424.9	1426.16	932096.0
2012-08-27	NQ	Futures	3195.37	3208.86	3186.76	3193.94	140197.0
2012-08-27	YM	Futures	12766.5	12792.7	12710.3	12716.1	74989.0
2012-08-27	CL	Futures	174.89	176.79	170.8	172.71	230844.0
2012-08-27	GC	Futures	2233.9	2242.1	2223.7	2237.2	76962.0
2012-08-27	ZN	Futures	116.38618	116.685793	116.318086	116.631318	731801.0
2012-08-27	A6	Futures	0.9356	0.93569	0.93039	0.93147	72638.0
2012-08-27	AD	Futures	1.01053	1.01333	1.00972	1.01173	47835.0
2012-08-27	B	Futures	103.13	104.69	101.31	101.85	69357.0
2012-08-27	B6	Futures	1.6529	1.6542	1.6502	1.651	45084.0
2012-08-27	BFX	Futures	2819.0	2840.4	2819.0	2840.4	6.0
2012-08-27	BR	Futures	0.23556	0.23556	0.23556	0.23556	49.0
2012-08-27	BZ	Futures	108.69	108.69	106.75	106.75	2170.0
2012-08-27	CC	Futures	1810.0	1884.0	1810.0	1865.0	9645.0
2012-08-27	CSC	Futures	4.099	4.105	4.099	4.105	9.0
2012-08-27	CT	Futures	99.06	99.43	98.63	99.23	13.0
2012-08-27	DC	Futures	30.34	30.71	30.3	30.6	64.0
2012-08-27	DX	Futures	79.217	79.328	79.11	79.291	9523.0
2012-08-27	E1	Futures	1.34513	1.3481	1.34319	1.34461	20486.0
2012-08-27	E6	Futures	1.47592	1.47911	1.47356	1.4751	114497.0
2012-08-27	E7	Futures	1.4672	1.4698	1.4643	1.4659	1780.0
2012-08-27	ED	Futures	95.1823	95.1847	95.18	95.1823	44578.0
2012-08-27	ER	Futures	97.866	97.871	97.852	97.866	37100.0
2012-08-27	EW	Futures	983.0	989.8	979.5	981.9	14495.0
2012-08-27	FBTP	Futures	67.16	67.24	66.99	67.06	4967.0
2012-08-27	FBTS	Futures	86.948	87.196	86.94	87.163	955.0
2012-08-27	FCE	Futures	2551.6	2577.7	2539.7	2575.4	50850.0
2012-08-27	FDAX	Futures	7608.1	7698.7	7583.5	7691.6	82929.0
2012-08-27	FESX	Futures	1643.4	1665.1	1635.3	1662.4	536520.0
2012-08-27	FGBL	Futures	118.85	118.93	118.57	118.77	215011.0
2012-08-27	FGBM	Futures	116.56	116.6	116.39	116.49	112929.0
2012-08-27	FGBS	Futures	110.487	110.502	110.442	110.457	126155.0
2012-08-27	FGBX	Futures	128.2	128.46	127.24	127.88	2894.0
2012-08-27	FOAT	Futures	103.29	103.42	103.2	103.23	3642.0
2012-08-27	FTDX	Futures	735.6	737.5	735.6	737.0	12.0
2012-08-27	FTI	Futures	280.47	283.45	279.83	283.03	17806.0
2012-08-27	FVSA	Futures	6814.58	6865.82	6622.44	6724.92	4568.0
2012-08-27	FXXP	Futures	192.0	193.3	191.5	193.2	1318.0
2012-08-27	GF	Futures	281.718	282.604	280.585	281.028	1281.0
2012-08-27	GSCI	Futures	1086.39	1086.39	1069.88	1075.04	159.0
2012-08-27	HE	Futures	89.784	90.804	89.63	90.526	11789.0
2012-08-27	HG	Futures	4.4785	4.5126	4.4567	4.4753	21598.0
2012-08-27	HH	Futures	35.833	35.833	35.833	35.833	1499.0
2012-08-27	HO	Futures	2.558	2.5843	2.5185	2.5277	28071.0
2012-08-27	HRC	Futures	2491.0	2491.0	2491.0	2491.0	0.0
2012-08-27	J1	Futures	0.0159343	0.0159393	0.0158955	0.015913	42110.0
2012-08-27	J7	Futures	0.015872	0.015874	0.015833	0.015851	141.0
2012-08-27	JB	Futures	126.28	126.3	126.14	126.17	1372.0
2012-08-27	KC	Futures	358.9	365.88	358.9	365.11	9595.0
2012-08-27	KE	Futures	3043.62	3085.79	3027.59	3031.81	12087.0

> showing 50 of 94 rows — these rows as CSV

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