PREVIEW / etf_daily / 2012-05-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-22.parquet
  size:    39 KB
  rows:    946

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-05-22	SPY	ETF	132.31	133.23	131.34	132.2	197531200.0
2012-05-22	QQQ	ETF	62.66	62.95	61.989	62.44	62954723.0
2012-05-22	IWM	ETF	76.42	77.03	75.47	75.99	59678300.0
2012-05-22	DIA	ETF	124.9	125.48	124.19	124.83	9856100.0
2012-05-22	GLD	ETF	153.59	154.42	151.55	152.08	11302700.0
2012-05-22	TLT	ETF	122.75	122.88	122.06	122.56	12475500.0
2012-05-22	AAXJ	ETF	51.26	51.59	50.8	51.11	735800.0
2012-05-22	ACTV	ETF	13.2	13.35	13.0	13.15	259262.0
2012-05-22	ACWI	ETF	43.21	43.39	42.68	42.93	585100.0
2012-05-22	ACWV	ETF	53.46	53.46	52.63	52.63	2000.0
2012-05-22	ACWX	ETF	36.6	36.81	36.22	36.37	136404.0
2012-05-22	ADRE	ETF	36.85	37.2491	36.5	36.73	37972.0
2012-05-22	AFK	ETF	28.0	28.09	27.54	27.54	9375.0
2012-05-22	AGG	ETF	110.82	110.92	110.71	110.71	1007400.0
2012-05-22	AGQ	ETF	165.0	170.52	160.64	162.88	515125.0
2012-05-22	AGZ	ETF	113.17	113.22	112.99	113.14	13520.0
2012-05-22	AIA	ETF	41.01	41.189	40.6	40.75	16723.0
2012-05-22	AIQ	ETF	5.45	5.5	5.05	5.25	13460.0
2012-05-22	AIS	ETF	3.02	3.07	2.94	2.96	662325.0
2012-05-22	AIVI	ETF	38.09	38.2	37.6	37.71	55200.0
2012-05-22	AMJ	ETF	37.64	38.29	37.64	37.96	1350762.0
2012-05-22	AMLP	ETF	79.5	80.35	79.5	79.9	385760.0
2012-05-22	ANGL	ETF	24.91	24.98	24.91	24.95	11500.0
2012-05-22	AOA	ETF	34.33	34.49	34.26	34.26	19500.0
2012-05-22	AOK	ETF	29.67	29.69	29.59	29.6	41498.0
2012-05-22	AOM	ETF	30.44	30.494	30.28	30.34	301389.0
2012-05-22	AOR	ETF	32.02	32.141	31.93	31.93	17301.0
2012-05-22	ARB	ETF	35.46	35.87	35.265	35.46	160264.0
2012-05-22	ARGT	ETF	16.14	16.24	16.14	16.14	450.0
2012-05-22	ASEA	ETF	15.22	15.3	15.13	15.18	17500.0
2012-05-22	AWAY	ETF	24.59	24.915	24.26	24.58	326653.0
2012-05-22	BAB	ETF	29.73	29.7632	29.59	29.7	212324.0
2012-05-22	BAL	ETF	47.3608	47.57	45.68	45.98	44187.0
2012-05-22	BALT	ETF	3.9	4.12	3.83	3.88	82359.0
2012-05-22	BBH	ETF	46.03	46.31	45.77	45.84	33100.0
2012-05-22	BCM	ETF	42.02	42.07	41.739	41.739	1360.0
2012-05-22	BIB	ETF	12.1025	12.2875	11.8575	11.8575	53712.0
2012-05-22	BICK	ETF	22.14	22.185	21.75	21.82	16221.0
2012-05-22	BIL	ETF	91.64	91.66	91.62	91.62	649100.0
2012-05-22	BIS	ETF	3558.4	3560.0	3464.128	3560.0	17.2
2012-05-22	BIV	ETF	87.97	88.0	87.83	87.97	244600.0
2012-05-22	BJK	ETF	32.1	32.52	31.99	31.99	6600.0
2012-05-22	BKF	ETF	35.27	35.526	34.71	34.9	166021.0
2012-05-22	BKLN	ETF	24.38	24.39	24.33	24.35	197400.0
2012-05-22	BLNG	ETF	46.79	46.79	46.61	46.66	1726.0
2012-05-22	BLV	ETF	93.32	93.39	92.97	93.27	109700.0
2012-05-22	BMVP	ETF	14.6067	14.72	14.53	14.53	15579.0
2012-05-22	BND	ETF	84.03	84.03	83.87	83.96	1593200.0
2012-05-22	BNO	ETF	38.5	38.555	38.07	38.17	161600.0
2012-05-22	BOIL	ETF	966000.0	1005600.0	963200.0	979800.0	11.6

> showing 50 of 946 rows — these rows as CSV

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