PREVIEW / etf_daily / 2012-02-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-24.parquet
  size:    38 KB
  rows:    911

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-02-24	SPY	ETF	136.93	137.2	136.63	136.93	105539100.0
2012-02-24	QQQ	ETF	63.92	64.07	63.8	63.96	41369705.0
2012-02-24	IWM	ETF	82.83	83.03	82.47	82.64	37607700.0
2012-02-24	DIA	ETF	129.77	129.9	129.25	129.62	3769100.0
2012-02-24	GLD	ETF	172.63	173.04	172.0	172.23	9293700.0
2012-02-24	TLT	ETF	117.23	117.58	116.95	117.5	5676900.0
2012-02-24	AAXJ	ETF	57.63	57.85	57.56	57.75	184900.0
2012-02-24	ACTV	ETF	15.5	16.48	15.5	16.0	797768.0
2012-02-24	ACWI	ETF	46.6	46.78	46.58	46.72	744400.0
2012-02-24	ACWX	ETF	41.19	41.35	41.15	41.27	71196.0
2012-02-24	ADRE	ETF	43.66	43.91	43.64	43.8	24728.0
2012-02-24	AFK	ETF	30.08	30.42	30.08	30.161	26064.0
2012-02-24	AGEM	ETF	24.13	24.19	24.13	24.19	278.0
2012-02-24	AGG	ETF	110.64	110.79	110.58	110.6	1364300.0
2012-02-24	AGQ	ETF	267.08	270.52	263.92	266.04	578825.0
2012-02-24	AGZ	ETF	112.8392	112.9	112.77	112.81	8484.0
2012-02-24	AIA	ETF	44.92	45.1125	44.92	45.03	14730.0
2012-02-24	AIQ	ETF	7.25	7.8	7.2	7.4	12747.0
2012-02-24	AIS	ETF	2.72	2.73	2.67	2.68	659555.0
2012-02-24	AIVI	ETF	42.47	42.74	42.44	42.6	47100.0
2012-02-24	AMJ	ETF	41.34	41.68	41.25	41.67	2272547.0
2012-02-24	AMLP	ETF	85.6	85.9	85.3	85.9	280260.0
2012-02-24	AOA	ETF	36.08	36.14	36.0	36.0	5100.0
2012-02-24	AOK	ETF	30.14	30.196	30.14	30.18	60682.0
2012-02-24	AOM	ETF	31.12	31.1999	31.11	31.15	8437.0
2012-02-24	AOR	ETF	33.1	33.15	33.05	33.1	40162.0
2012-02-24	ARB	ETF	35.6	35.6	34.61	34.89	210142.0
2012-02-24	ARGT	ETF	23.94	23.94	23.44	23.44	4950.0
2012-02-24	ASEA	ETF	15.92	15.92	15.83	15.83	13500.0
2012-02-24	AWAY	ETF	23.83	26.15	23.582	25.29	904040.0
2012-02-24	BAB	ETF	29.31	29.34	29.231	29.32	437789.0
2012-02-24	BAL	ETF	54.46	55.1799	54.14	55.06	19654.0
2012-02-24	BALT	ETF	4.45	4.51	4.43	4.49	192563.0
2012-02-24	BBH	ETF	42.74	42.74	42.28	42.5	21600.0
2012-02-24	BCM	ETF	46.9	47.173	46.9	47.12	5411.0
2012-02-24	BIB	ETF	11.2775	11.3249	11.2245	11.2675	33056.0
2012-02-24	BICK	ETF	27.84	28.0625	27.823	27.87	7046.0
2012-02-24	BIL	ETF	91.64	91.66	91.64	91.66	186550.0
2012-02-24	BIS	ETF	3953.6	3953.6	3953.6	3953.6	1.25
2012-02-24	BITS	ETF	21.76	21.8	20.96	21.2	672.0
2012-02-24	BIV	ETF	87.74	87.86	87.74	87.82	246200.0
2012-02-24	BJK	ETF	34.26	34.37	34.19	34.19	15800.0
2012-02-24	BKF	ETF	43.6	43.99	43.6	43.88	95277.0
2012-02-24	BKLN	ETF	24.45	24.46	24.42	24.43	316200.0
2012-02-24	BLV	ETF	91.39	91.52	91.14	91.44	77700.0
2012-02-24	BMVP	ETF	15.42	15.42	15.31	15.31	4563.0
2012-02-24	BND	ETF	83.83	83.87	83.78	83.84	1276200.0
2012-02-24	BNO	ETF	43.13	43.8	43.065	43.74	208200.0
2012-02-24	BOIL	ETF	1355000.0	1355000.0	1315000.0	1330000.0	4.6
2012-02-24	BRF	ETF	46.68	46.81	46.39	46.51	171407.0

> showing 50 of 911 rows — these rows as CSV

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