PREVIEW / etf_daily / 2011-10-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-21.parquet
  size:    37 KB
  rows:    875

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-10-21	SPY	ETF	123.09	124.12	122.72	123.97	278999400.0
2011-10-21	QQQ	ETF	57.17	57.66	56.78	57.3	60455686.0
2011-10-21	IWM	ETF	70.57	71.16	70.02	71.13	60408600.0
2011-10-21	DIA	ETF	116.45	117.88	116.43	117.85	13012000.0
2011-10-21	GLD	ETF	159.99	160.45	158.94	159.52	13334500.0
2011-10-21	TLT	ETF	113.86	114.2	113.13	113.13	9906300.0
2011-10-21	AADR	ETF	27.66	27.66	27.66	27.66	4100.0
2011-10-21	AAXJ	ETF	50.68	51.31	50.6	51.25	480400.0
2011-10-21	ACTV	ETF	14.5	14.5	13.95	14.42	176480.0
2011-10-21	ACWI	ETF	42.74	43.07	42.64	43.04	379200.0
2011-10-21	ACWV	ETF	50.74	50.77	50.69	50.69	3000.0
2011-10-21	ACWX	ETF	37.98	38.31	37.954	38.25	67615.0
2011-10-21	ADRE	ETF	37.97	38.49	37.97	38.43	51477.0
2011-10-21	AFK	ETF	27.29	27.64	27.2	27.56	12068.0
2011-10-21	AGEM	ETF	21.2332	21.2332	21.2332	21.2332	600.0
2011-10-21	AGG	ETF	109.46	109.53	109.24	109.41	555300.0
2011-10-21	AGQ	ETF	225.0	226.8	220.4	225.56	333500.0
2011-10-21	AGZ	ETF	112.18	112.2108	111.8608	112.208	6608.0
2011-10-21	AIA	ETF	39.28	39.66	39.28	39.66	33154.0
2011-10-21	AIQ	ETF	5.55	5.85	5.45	5.7	28487.0
2011-10-21	AIS	ETF	2.25	2.25	2.18	2.22	487423.0
2011-10-21	AIVI	ETF	41.72	42.06	41.64	42.06	65000.0
2011-10-21	AMJ	ETF	36.65	36.68	36.4	36.54	961084.0
2011-10-21	AMLP	ETF	79.95	79.95	79.3	79.35	122520.0
2011-10-21	AOA	ETF	32.51	32.72	32.51	32.62	1600.0
2011-10-21	AOK	ETF	29.09	29.12	29.03	29.06	16082.0
2011-10-21	AOM	ETF	29.7	29.77	29.6927	29.752	13523.0
2011-10-21	AOR	ETF	30.81	30.9	30.791	30.9	5671.0
2011-10-21	ARB	ETF	37.3	37.69	36.83	37.67	107881.0
2011-10-21	ARGT	ETF	21.64	21.64	21.64	21.64	250.0
2011-10-21	ASEA	ETF	14.67	14.81	14.59	14.75	2900.0
2011-10-21	AWAY	ETF	36.67	36.74	36.0	36.34	26418.0
2011-10-21	BAB	ETF	27.7	27.78	27.54	27.76	280723.0
2011-10-21	BAL	ETF	60.64	61.01	59.841	60.0	32501.0
2011-10-21	BALT	ETF	5.68	5.98	5.68	5.84	209540.0
2011-10-21	BBH	ETF	34.6667	35.3167	34.6133	35.3167	98700.0
2011-10-21	BCM	ETF	43.3599	43.36	43.3599	43.36	200.0
2011-10-21	BIB	ETF	7.6413	7.6963	7.3513	7.6137	23096.0
2011-10-21	BICK	ETF	24.3	24.509	24.3	24.509	9147.0
2011-10-21	BIL	ETF	91.68	91.7	91.68	91.68	583750.0
2011-10-21	BITS	ETF	22.64	23.96	22.64	23.0	575.0
2011-10-21	BIV	ETF	86.74	87.02	86.7	86.93	217000.0
2011-10-21	BJK	ETF	30.24	30.42	29.76	30.19	18800.0
2011-10-21	BKF	ETF	36.74	37.24	36.73	37.18	233199.0
2011-10-21	BKLN	ETF	23.47	23.66	23.47	23.65	40300.0
2011-10-21	BLV	ETF	89.5	89.68	89.08	89.13	48800.0
2011-10-21	BMVP	ETF	13.42	13.56	13.42	13.48	8278.0
2011-10-21	BND	ETF	83.25	83.32	83.1	83.1	1885800.0
2011-10-21	BNO	ETF	38.25	38.325	37.54	37.725	298800.0
2011-10-21	BOSS	ETF	61.76	63.66	61.76	63.66	200.0

> showing 50 of 875 rows — these rows as CSV

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