PREVIEW / etf_daily / 2012-06-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-21.parquet
  size:    39 KB
  rows:    939

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-06-21	SPY	ETF	135.64	135.78	132.33	132.44	205272200.0
2012-06-21	QQQ	ETF	64.21	64.31	62.62	62.69	42492624.0
2012-06-21	IWM	ETF	78.37	78.53	76.49	76.62	62486400.0
2012-06-21	DIA	ETF	128.15	128.34	125.34	125.44	7702600.0
2012-06-21	GLD	ETF	153.73	154.23	151.8	152.02	14447500.0
2012-06-21	TLT	ETF	125.95	127.25	125.89	126.71	9776600.0
2012-06-21	AAXJ	ETF	52.28	52.28	50.87	50.93	1458400.0
2012-06-21	ACTV	ETF	16.17	16.17	15.71	15.91	659905.0
2012-06-21	ACWI	ETF	43.79	43.79	42.49	42.53	720900.0
2012-06-21	ACWV	ETF	55.17	55.17	53.89	53.89	4900.0
2012-06-21	ACWX	ETF	36.79	36.79	35.77	35.77	168204.0
2012-06-21	ADRE	ETF	37.79	37.79	36.56	36.56	25537.0
2012-06-21	AFK	ETF	27.51	27.51	26.81	26.83	263867.0
2012-06-21	AGEM	ETF	20.49	20.49	20.2	20.42	5358.0
2012-06-21	AGG	ETF	111.18	111.32	111.06	111.2	939900.0
2012-06-21	AGQ	ETF	154.6	155.68	146.36	146.96	677700.0
2012-06-21	AGZ	ETF	113.44	113.56	113.3521	113.3918	13481.0
2012-06-21	AIA	ETF	41.21	41.21	40.28	40.294	161783.0
2012-06-21	AIQ	ETF	4.4105	4.675	4.375	4.375	24405.0
2012-06-21	AIVI	ETF	38.38	38.44	37.54	37.54	101900.0
2012-06-21	AMJ	ETF	36.97	37.095	36.3	36.33	2676078.0
2012-06-21	AMLP	ETF	79.05	79.05	78.1	78.1	360320.0
2012-06-21	ANGL	ETF	25.45	25.45	25.45	25.45	800.0
2012-06-21	AOA	ETF	34.84	34.88	34.34	34.35	9200.0
2012-06-21	AOK	ETF	29.85	29.85	29.68	29.68	17316.0
2012-06-21	AOM	ETF	30.78	30.78	30.5	30.5	4475.0
2012-06-21	AOR	ETF	32.42	32.42	32.06	32.06	4536.0
2012-06-21	ARB	ETF	35.22	35.3323	33.9605	34.17	68095.0
2012-06-21	ARGT	ETF	15.42	15.42	15.42	15.42	150.0
2012-06-21	ASEA	ETF	15.33	15.33	14.86	14.89	2100.0
2012-06-21	AWAY	ETF	21.92	22.21	20.86	21.16	607368.0
2012-06-21	BAB	ETF	29.66	29.89	29.66	29.83	231132.0
2012-06-21	BAL	ETF	45.64	45.65	44.2	44.62	15650.0
2012-06-21	BALT	ETF	3.52	3.53	3.45	3.47	185480.0
2012-06-21	BBH	ETF	46.54	46.67	45.85	45.86	15300.0
2012-06-21	BCM	ETF	40.16	40.16	39.925	40.03	2183.0
2012-06-21	BIB	ETF	12.9313	12.9637	12.43	12.4375	104528.0
2012-06-21	BICK	ETF	22.63	22.63	21.93	21.93	32524.0
2012-06-21	BIL	ETF	91.62	91.66	91.62	91.66	918100.0
2012-06-21	BIS	ETF	3289.6	3356.48	3289.6	3356.48	44.3
2012-06-21	BIV	ETF	88.62	88.82	88.62	88.62	183400.0
2012-06-21	BJK	ETF	32.61	32.61	31.78	31.78	3300.0
2012-06-21	BKF	ETF	35.55	35.57	34.45	34.49	129299.0
2012-06-21	BKLN	ETF	24.23	24.23	24.13	24.14	200200.0
2012-06-21	BLV	ETF	95.09	95.87	95.09	95.55	114600.0
2012-06-21	BMVP	ETF	15.12	15.13	14.8	14.82	4398.0
2012-06-21	BND	ETF	84.27	84.39	84.23	84.3	972700.0
2012-06-21	BNO	ETF	32.72	32.78	31.57	31.725	193200.0
2012-06-21	BOIL	ETF	767400.0	831000.0	767400.0	800000.0	21.6
2012-06-21	BOND	ETF	105.57	105.82	105.53	105.74	427565.0

> showing 50 of 939 rows — these rows as CSV

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