PREVIEW / etf_daily / 2011-03-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-22.parquet
  size:    35 KB
  rows:    833

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-03-22	SPY	ETF	129.72	129.89	129.17	129.29	129538600.0
2011-03-22	QQQ	ETF	55.57	55.61	55.28	55.395	36251281.0
2011-03-22	IWM	ETF	81.42	81.6	80.67	80.87	52372800.0
2011-03-22	DIA	ETF	120.15	120.24	119.77	119.92	6360500.0
2011-03-22	GLD	ETF	138.88	139.36	138.67	139.05	9553700.0
2011-03-22	TLT	ETF	92.81	93.29	92.74	93.22	6904700.0
2011-03-22	AADR	ETF	29.81	29.81	29.81	29.81	200.0
2011-03-22	AAXJ	ETF	60.56	60.56	60.12	60.15	275700.0
2011-03-22	ACWI	ETF	47.34	47.51	47.28	47.46	588400.0
2011-03-22	ACWX	ETF	44.44	44.49	44.18	44.32	485165.0
2011-03-22	ADRE	ETF	46.11	46.3005	46.06	46.28	36108.0
2011-03-22	AFK	ETF	32.18	32.5494	32.0	32.27	16596.0
2011-03-22	AGG	ETF	105.56	105.73	105.54	105.68	604800.0
2011-03-22	AGQ	ETF	411.6	423.0	410.5	421.12	394200.0
2011-03-22	AGZ	ETF	109.71	109.73	109.44	109.73	12962.0
2011-03-22	AIA	ETF	45.75	45.75	45.41	45.51	41570.0
2011-03-22	AIQ	ETF	20.0	20.5	20.0	20.4	37191.0
2011-03-22	AIS	ETF	1.66	1.6601	1.63	1.63	159914.0
2011-03-22	AIVI	ETF	45.81	45.85	45.56	45.74	7100.0
2011-03-22	AMJ	ETF	37.45	37.46	37.09	37.45	648092.0
2011-03-22	AMLP	ETF	81.15	81.25	80.85	81.25	83000.0
2011-03-22	AOA	ETF	35.29	35.3	35.17	35.22	7800.0
2011-03-22	AOK	ETF	29.14	29.14	29.07	29.07	8363.0
2011-03-22	AOM	ETF	30.41	30.41	30.341	30.38	11561.0
2011-03-22	AOR	ETF	32.19	32.22	32.15	32.151	5902.0
2011-03-22	ARB	ETF	37.03	37.55	36.92	37.28	173031.0
2011-03-22	ARGT	ETF	29.5	29.5	29.18	29.18	1000.0
2011-03-22	ASEA	ETF	15.36	15.36	15.36	15.36	300.0
2011-03-22	BAB	ETF	25.32	25.39	25.32	25.35	148097.0
2011-03-22	BAL	ETF	103.0	107.98	102.134	107.6	131193.0
2011-03-22	BALT	ETF	8.88	8.92	8.76	8.86	65290.0
2011-03-22	BBH	ETF	34.3967	34.4567	34.2567	34.4067	30600.0
2011-03-22	BIB	ETF	7.6275	7.6275	7.6275	7.6275	800.0
2011-03-22	BICK	ETF	31.55	31.6587	31.4845	31.5899	12288.0
2011-03-22	BIL	ETF	91.7	91.72	91.7	91.7	117100.0
2011-03-22	BIS	ETF	7836.8	7840.0	7836.8	7840.0	21.9
2011-03-22	BITS	ETF	25.2	26.0	24.62	24.88	4112.0
2011-03-22	BIV	ETF	82.81	82.97	82.76	82.92	157900.0
2011-03-22	BJK	ETF	31.12	31.12	30.84	30.86	11500.0
2011-03-22	BKF	ETF	47.66	47.89	47.6	47.84	180833.0
2011-03-22	BKLN	ETF	24.89	24.9	24.84	24.9	61900.0
2011-03-22	BLV	ETF	78.66	79.0	78.65	79.0	24000.0
2011-03-22	BMVP	ETF	15.14	15.166	15.057	15.087	7272.0
2011-03-22	BND	ETF	80.41	80.48	80.37	80.45	999300.0
2011-03-22	BNO	ETF	38.09	38.51	37.895	38.495	67800.0
2011-03-22	BRF	ETF	52.29	52.8	51.8701	52.64	132244.0
2011-03-22	BSCE	ETF	20.89	20.97	20.89	20.97	37125.0
2011-03-22	BSV	ETF	80.49	80.56	80.47	80.52	320300.0
2011-03-22	BTF	ETF	84.25	84.49999999999999	83.49999999999999	83.611	7259.8
2011-03-22	BWX	ETF	30.27	30.31	30.2082	30.255	300212.0

> showing 50 of 833 rows — these rows as CSV

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