PREVIEW / etf_daily / 2012-04-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-26.parquet
  size:    39 KB
  rows:    938

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-04-26	SPY	ETF	138.89	140.32	138.81	140.16	136291600.0
2012-04-26	QQQ	ETF	66.42	66.99	66.35	66.84	41799492.0
2012-04-26	IWM	ETF	80.95	81.87	80.82	81.74	43147600.0
2012-04-26	DIA	ETF	130.56	132.03	130.49	131.85	4577100.0
2012-04-26	GLD	ETF	160.46	161.38	160.1	161.03	10918700.0
2012-04-26	TLT	ETF	117.42	117.46	116.59	117.19	5133000.0
2012-04-26	AADR	ETF	30.3	30.36	30.3	30.36	1200.0
2012-04-26	AAXJ	ETF	55.9	56.3	55.64	56.24	219000.0
2012-04-26	ACTV	ETF	16.86	17.03	16.85	16.96	183677.0
2012-04-26	ACWI	ETF	46.28	46.78	46.25	46.66	713400.0
2012-04-26	ACWV	ETF	54.28	54.62	54.17	54.56	41200.0
2012-04-26	ACWX	ETF	39.8	40.21	39.75	40.17	222512.0
2012-04-26	ADRE	ETF	40.69	41.1999	40.69	41.13	35439.0
2012-04-26	AFK	ETF	29.52	29.89	29.52	29.89	6035.0
2012-04-26	AGEM	ETF	22.45	22.771	22.45	22.771	7194.0
2012-04-26	AGG	ETF	110.64	110.69	110.54	110.65	1021600.0
2012-04-26	AGQ	ETF	196.44	203.0	194.92	200.32	390975.0
2012-04-26	AGZ	ETF	112.9547	113.09	112.76	112.9	10941.0
2012-04-26	AIA	ETF	44.49	44.929	44.42	44.87	17957.0
2012-04-26	AIQ	ETF	6.7	6.95	6.7	6.8	4384.0
2012-04-26	AIS	ETF	3.34	3.34	2.98	3.08	2021602.0
2012-04-26	AIVI	ETF	40.3	40.7	40.22	40.6	43900.0
2012-04-26	AMJ	ETF	39.12	39.68	39.12	39.6	1972251.0
2012-04-26	AMLP	ETF	82.9	83.4	82.8	83.3	429840.0
2012-04-26	ANGL	ETF	25.55	25.55	25.44	25.46	7200.0
2012-04-26	AOA	ETF	35.99	36.31	35.99	36.25	10600.0
2012-04-26	AOK	ETF	30.12	30.22	30.12	30.2	37495.0
2012-04-26	AOM	ETF	31.13	31.26	31.13	31.22	14782.0
2012-04-26	AOR	ETF	33.13	33.33	33.13	33.27	17361.0
2012-04-26	ARB	ETF	38.53	38.92	38.4	38.63	223318.0
2012-04-26	ARGT	ETF	18.66	18.84	18.66	18.82	1150.0
2012-04-26	ASEA	ETF	16.13	16.21	16.11	16.19	15800.0
2012-04-26	AWAY	ETF	25.07	26.09	24.86	25.93	476836.0
2012-04-26	BAB	ETF	29.51	29.51	29.3512	29.48	188029.0
2012-04-26	BAL	ETF	57.13	57.43	56.53	57.12	58159.0
2012-04-26	BALT	ETF	4.6	4.73	4.6	4.68	104092.0
2012-04-26	BBH	ETF	45.56	45.79	45.53	45.66	111900.0
2012-04-26	BCM	ETF	44.77	44.77	44.77	44.77	309.0
2012-04-26	BIB	ETF	12.1788	12.295	12.1625	12.2762	28200.0
2012-04-26	BICK	ETF	25.15	25.426	25.15	25.36	9753.0
2012-04-26	BIL	ETF	91.66	91.66	91.64	91.66	68450.0
2012-04-26	BIS	ETF	3569.6	3569.6	3512.0	3532.8	5.0
2012-04-26	BIV	ETF	87.83	87.91	87.73	87.8	336000.0
2012-04-26	BJK	ETF	36.49	36.85	36.34	36.83	215200.0
2012-04-26	BKF	ETF	39.7	40.13	39.67	40.07	71158.0
2012-04-26	BKLN	ETF	24.5	24.56	24.48	24.56	332800.0
2012-04-26	BLV	ETF	91.47	91.47	91.07	91.34	29700.0
2012-04-26	BMVP	ETF	15.45	15.6167	15.3267	15.6118	5370.0
2012-04-26	BND	ETF	83.85	83.88	83.78	83.82	751400.0
2012-04-26	BNO	ETF	42.175	42.365	42.145	42.265	22400.0

> showing 50 of 938 rows — these rows as CSV

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