PREVIEW / etf_daily / 2012-04-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-30.parquet
  size:    38 KB
  rows:    935

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-30	SPY	ETF	140.11	140.21	139.49	139.87	115092200.0
2012-04-30	QQQ	ETF	67.02	67.17	66.71	66.76	37787622.0
2012-04-30	IWM	ETF	82.35	82.36	81.43	81.47	38093600.0
2012-04-30	DIA	ETF	131.81	132.02	131.49	131.8	3670500.0
2012-04-30	GLD	ETF	160.49	161.88	160.31	161.88	8007300.0
2012-04-30	TLT	ETF	117.57	117.75	117.19	117.32	4198400.0
2012-04-30	AAXJ	ETF	56.22	56.33	55.95	56.2	327000.0
2012-04-30	ACTV	ETF	16.96	17.025	16.8	16.8	218341.0
2012-04-30	ACWI	ETF	46.78	46.78	46.5	46.66	363900.0
2012-04-30	ACWV	ETF	54.58	54.61	54.41	54.61	13000.0
2012-04-30	ACWX	ETF	40.24	40.24	39.98	40.15	84037.0
2012-04-30	ADRE	ETF	41.34	41.34	40.98	41.14	175996.0
2012-04-30	AFK	ETF	29.78	29.81	29.66	29.75	5347.0
2012-04-30	AGEM	ETF	22.8	22.8	22.73	22.73	223.0
2012-04-30	AGG	ETF	110.73	110.73	110.59	110.6	881900.0
2012-04-30	AGQ	ETF	196.0	200.24	193.64	199.72	319450.0
2012-04-30	AGZ	ETF	113.01	113.1	112.74	113.1	16024.0
2012-04-30	AIA	ETF	45.1	45.1	44.8408	44.91	13241.0
2012-04-30	AIQ	ETF	6.6	7.15	6.5	6.85	33354.0
2012-04-30	AIS	ETF	3.24	3.24	3.13	3.15	1497460.0
2012-04-30	AIVI	ETF	40.59	40.65	40.4	40.53	43000.0
2012-04-30	AMJ	ETF	39.66	40.08	39.66	40.01	671177.0
2012-04-30	AMLP	ETF	83.35	84.05	83.35	84.05	376760.0
2012-04-30	ANGL	ETF	25.5	25.59	25.43	25.55	25000.0
2012-04-30	AOA	ETF	36.3	36.3	36.13	36.2	326900.0
2012-04-30	AOK	ETF	30.22	30.227	30.1501	30.1793	8695.0
2012-04-30	AOM	ETF	31.28	31.28	31.2	31.24	14878.0
2012-04-30	AOR	ETF	33.33	33.33	33.195	33.23	265666.0
2012-04-30	ARB	ETF	38.51	38.76	38.04	38.05	240042.0
2012-04-30	ARGT	ETF	18.8	19.06	18.8	19.06	1100.0
2012-04-30	ASEA	ETF	16.27	16.29	16.19	16.23	3500.0
2012-04-30	AWAY	ETF	25.86	26.6	25.49	26.05	433015.0
2012-04-30	BAB	ETF	29.47	29.4956	29.4	29.44	118287.0
2012-04-30	BAL	ETF	56.16	56.23	54.71	55.59	72302.0
2012-04-30	BALT	ETF	4.72	4.7294	4.59	4.65	181896.0
2012-04-30	BBH	ETF	46.13	46.29	45.87	45.99	117800.0
2012-04-30	BCM	ETF	44.87	45.07	44.87	45.048	5098.0
2012-04-30	BIB	ETF	12.505	12.5415	12.2924	12.2924	7640.0
2012-04-30	BICK	ETF	25.4	25.4	25.23	25.3	9922.0
2012-04-30	BIL	ETF	91.64	91.66	91.64	91.66	85900.0
2012-04-30	BIS	ETF	3459.2	3528.0	3456.0	3500.8	45.4
2012-04-30	BIV	ETF	87.95	88.0	87.89	87.89	212000.0
2012-04-30	BJK	ETF	36.64	36.67	36.45	36.66	33200.0
2012-04-30	BKF	ETF	40.23	40.23	39.87	40.09	111109.0
2012-04-30	BKLN	ETF	24.56	24.59	24.5	24.59	164000.0
2012-04-30	BLNG	ETF	50.15	50.15	50.15	50.15	391.0
2012-04-30	BLV	ETF	91.64	91.71	91.41	91.49	29000.0
2012-04-30	BMVP	ETF	15.59	15.62	15.59	15.6	9656.0
2012-04-30	BND	ETF	83.92	83.94	83.88	83.92	912700.0
2012-04-30	BNO	ETF	42.11	42.135	41.91	42.1	34000.0

> showing 50 of 935 rows — these rows as CSV

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