PREVIEW / etf_daily / 2011-06-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-13.parquet
  size:    36 KB
  rows:    852

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-06-13	SPY	ETF	127.89	128.24	127.05	127.7	207599800.0
2011-06-13	QQQ	ETF	54.71	54.93	54.45	54.64	37745769.0
2011-06-13	IWM	ETF	78.23	78.64	77.35	77.78	60285400.0
2011-06-13	DIA	ETF	119.73	120.04	119.09	119.46	5363200.0
2011-06-13	GLD	ETF	148.66	149.04	147.19	147.77	12989300.0
2011-06-13	TLT	ETF	96.74	97.29	96.64	96.65	5540000.0
2011-06-13	AAXJ	ETF	61.25	61.25	60.59	60.81	209900.0
2011-06-13	ACTV	ETF	18.88	19.47	18.88	19.08	190228.0
2011-06-13	ACWI	ETF	47.36	47.48	46.97	47.25	148500.0
2011-06-13	ACWX	ETF	44.46	44.474	44.0	44.24	23334.0
2011-06-13	ADRE	ETF	45.32	45.47	44.93	45.09	44351.0
2011-06-13	AFK	ETF	32.43	32.5601	32.24	32.43	23848.0
2011-06-13	AGG	ETF	107.36	107.61	107.31	107.34	956000.0
2011-06-13	AGQ	ETF	348.22	352.0	328.8	332.04	1059850.0
2011-06-13	AGZ	ETF	110.91	110.92	110.77	110.866	6856.0
2011-06-13	AIA	ETF	46.674	46.7499	46.35	46.509	52169.0
2011-06-13	AIQ	ETF	18.95	19.0	18.35	18.6	16556.0
2011-06-13	AIS	ETF	2.11	2.13	1.91	1.92	2756848.0
2011-06-13	AIVI	ETF	47.06	47.17	46.67	46.84	20400.0
2011-06-13	AMJ	ETF	36.35	36.5	35.8	36.04	444788.0
2011-06-13	AMLP	ETF	79.5	79.7	78.55	78.95	115560.0
2011-06-13	AOA	ETF	34.79	34.9	34.67	34.73	11400.0
2011-06-13	AOK	ETF	29.1	29.16	29.1	29.1485	16187.0
2011-06-13	AOM	ETF	30.46	30.47	30.38	30.38	38790.0
2011-06-13	AOR	ETF	32.1	32.12	32.0	32.0272	12022.0
2011-06-13	ARB	ETF	38.86	39.0	37.81	38.09	125807.0
2011-06-13	ARGT	ETF	28.28	28.28	28.1	28.22	850.0
2011-06-13	ASEA	ETF	15.95	15.95	15.95	15.95	3000.0
2011-06-13	BAB	ETF	26.7	26.8	26.67	26.73	117586.0
2011-06-13	BAL	ETF	82.13	83.7799	81.28	82.215	21196.0
2011-06-13	BALT	ETF	6.08	6.14	5.7	5.77	172655.0
2011-06-13	BBH	ETF	33.69	34.0667	33.66	33.92	95700.0
2011-06-13	BCM	ETF	47.66	47.66	47.66	47.66	932.0
2011-06-13	BIB	ETF	8.9725	9.179	8.93	8.9887	62560.0
2011-06-13	BICK	ETF	31.24	31.4	31.1	31.11	11187.0
2011-06-13	BIL	ETF	91.72	91.72	91.7	91.7	94950.0
2011-06-13	BIS	ETF	6438.4	6439.68	6342.32	6439.68	50.5
2011-06-13	BITS	ETF	21.2	21.76	19.96	21.76	1928.0
2011-06-13	BIV	ETF	84.69	84.91	84.58	84.68	98600.0
2011-06-13	BJK	ETF	32.24	32.38	31.92	32.16	7700.0
2011-06-13	BKF	ETF	47.26	47.368	46.81	46.9	85588.0
2011-06-13	BKLN	ETF	24.94	24.94	24.88	24.88	69500.0
2011-06-13	BLNG	ETF	48.34	48.34	48.11	48.12	5704.0
2011-06-13	BLV	ETF	81.88	82.16	81.74	81.79	19100.0
2011-06-13	BMVP	ETF	14.96	15.017	14.805	14.887	13373.0
2011-06-13	BND	ETF	81.67	81.84	81.65	81.71	844200.0
2011-06-13	BNO	ETF	39.72	39.935	38.935	39.465	278400.0
2011-06-13	BRF	ETF	56.67	57.38	56.4	57.1	214884.0
2011-06-13	BSCE	ETF	21.17	21.21	21.14	21.19	37322.0
2011-06-13	BSV	ETF	81.15	81.21	81.12	81.19	324300.0

> showing 50 of 852 rows — these rows as CSV

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