PREVIEW / etf_daily / 2011-09-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-30.parquet
  size:    36 KB
  rows:    871

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-30	SPY	ETF	114.45	115.45	113.07	113.15	288392300.0
2011-09-30	QQQ	ETF	53.18	53.61	52.46	52.49	104957919.0
2011-09-30	IWM	ETF	65.15	66.18	64.24	64.3	72124900.0
2011-09-30	DIA	ETF	109.81	111.16	108.87	108.93	10338600.0
2011-09-30	GLD	ETF	157.3	160.0	156.33	158.06	16770300.0
2011-09-30	TLT	ETF	120.02	120.91	118.99	120.8	13546400.0
2011-09-30	AADR	ETF	26.02	26.02	25.78	25.78	5900.0
2011-09-30	AAXJ	ETF	47.86	48.09	46.64	46.64	296900.0
2011-09-30	ACTV	ETF	14.89	15.48	14.4139	14.75	82537.0
2011-09-30	ACWI	ETF	39.77	39.93	39.11	39.12	975900.0
2011-09-30	ACWX	ETF	35.47	35.77	35.05	35.05	97421.0
2011-09-30	ADRE	ETF	36.45	36.75	35.852	36.07	50596.0
2011-09-30	AFK	ETF	25.95	26.59	25.76	25.921	6618.0
2011-09-30	AGEM	ETF	20.21	20.21	19.65	19.67	55232.0
2011-09-30	AGG	ETF	110.0	110.22	109.86	110.11	1020700.0
2011-09-30	AGQ	ETF	217.66	221.26	207.36	207.36	745650.0
2011-09-30	AGZ	ETF	112.71	113.0	112.66	112.7	10504.0
2011-09-30	AIA	ETF	37.24	37.265	36.0536	36.06	17904.0
2011-09-30	AIQ	ETF	5.85	5.95	5.4915	5.7	86217.0
2011-09-30	AIS	ETF	2.22	2.36	2.1901	2.32	605775.0
2011-09-30	AIVI	ETF	38.55	38.93	38.14	38.14	40700.0
2011-09-30	AMJ	ETF	34.04	34.37	33.92	34.05	1201014.0
2011-09-30	AMLP	ETF	76.7	76.7	76.15	76.2	96280.0
2011-09-30	AOA	ETF	30.7	30.76	30.44	30.44	13600.0
2011-09-30	AOK	ETF	28.71	28.71	28.6	28.6	6167.0
2011-09-30	AOM	ETF	28.97	29.01	28.92	28.93	14994.0
2011-09-30	AOR	ETF	29.54	29.67	29.39	29.4074	8757.0
2011-09-30	ARB	ETF	33.52	34.29	33.06	33.08	130654.0
2011-09-30	ARGT	ETF	19.92	19.92	19.44	19.84	2350.0
2011-09-30	ASEA	ETF	13.86	13.99	13.61	13.61	16000.0
2011-09-30	AWAY	ETF	33.12	34.17	32.5	33.62	915584.0
2011-09-30	BAB	ETF	28.72	28.87	28.54	28.82	133867.0
2011-09-30	BAL	ETF	62.71	62.71	61.5005	61.51	35325.0
2011-09-30	BALT	ETF	4.72	4.8492	4.62	4.65	130108.0
2011-09-30	BBH	ETF	32.42	32.8033	32.42	32.45	20700.0
2011-09-30	BCM	ETF	41.76	41.839	41.12	41.17	7625.0
2011-09-30	BIB	ETF	7.0675	7.2625	7.0675	7.0762	44000.0
2011-09-30	BICK	ETF	22.51	22.61	21.94	22.01	14568.0
2011-09-30	BIL	ETF	91.7	91.7	91.68	91.7	611450.0
2011-09-30	BIS	ETF	7048.0	7048.0	6816.0	6977.6	15.05
2011-09-30	BITS	ETF	22.24	22.24	22.24	22.24	25.0
2011-09-30	BIV	ETF	87.7	87.76	87.4	87.63	266800.0
2011-09-30	BJK	ETF	28.62	28.67	27.78	27.78	209600.0
2011-09-30	BKF	ETF	34.65	34.93	33.83	33.87	193402.0
2011-09-30	BKLN	ETF	23.07	23.12	22.97	23.0	43200.0
2011-09-30	BLV	ETF	91.53	91.95	90.76	91.77	112000.0
2011-09-30	BMVP	ETF	12.34	12.34	12.24	12.28	13624.0
2011-09-30	BND	ETF	83.64	83.8	83.55	83.74	1283000.0
2011-09-30	BNO	ETF	34.415	35.08	33.82	33.82	475800.0
2011-09-30	BRF	ETF	39.99	40.08	39.0	39.2	190765.0

> showing 50 of 871 rows — these rows as CSV

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