PREVIEW / etf_daily / 2012-07-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-13.parquet
  size:    38 KB
  rows:    920

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-07-13	SPY	ETF	133.86	135.89	133.84	135.75	129642600.0
2012-07-13	QQQ	ETF	62.56	63.52	62.56	63.38	32358947.0
2012-07-13	IWM	ETF	79.07	80.09	79.02	79.77	42114800.0
2012-07-13	DIA	ETF	125.92	127.71	125.86	127.62	3942000.0
2012-07-13	GLD	ETF	153.45	154.94	153.44	154.14	5080300.0
2012-07-13	TLT	ETF	129.23	129.24	128.6	129.17	4175300.0
2012-07-13	AAXJ	ETF	51.47	52.07	51.39	51.97	165000.0
2012-07-13	ACTV	ETF	14.6	15.12	14.6	15.04	235217.0
2012-07-13	ACWI	ETF	43.03	43.64	43.03	43.6	823700.0
2012-07-13	ACWV	ETF	55.01	55.05	54.9	55.02	2300.0
2012-07-13	ACWX	ETF	36.21	36.75	36.21	36.7	206646.0
2012-07-13	ADRE	ETF	36.79	37.1535	36.79	37.071	61550.0
2012-07-13	AFK	ETF	27.75	27.8043	27.6	27.8043	26305.0
2012-07-13	AGEM	ETF	20.75	20.88	20.71	20.85	3400.0
2012-07-13	AGG	ETF	112.07	112.09	111.94	112.08	435300.0
2012-07-13	AGQ	ETF	149.36	152.84	149.12	149.48	187600.0
2012-07-13	AGZ	ETF	113.99	113.99	113.6975	113.8	20290.0
2012-07-13	AIA	ETF	40.01	40.44	40.01	40.44	5580.0
2012-07-13	AIQ	ETF	4.5	4.65	4.5	4.585	2773.0
2012-07-13	AIVI	ETF	36.91	37.62	36.91	37.58	32300.0
2012-07-13	AMJ	ETF	39.11	39.6	39.11	39.5	453860.0
2012-07-13	AMLP	ETF	81.5	81.95	81.4	81.95	544420.0
2012-07-13	ANGL	ETF	25.45	25.49	25.45	25.49	700.0
2012-07-13	AOA	ETF	34.6	34.92	34.6	34.92	10800.0
2012-07-13	AOK	ETF	29.78	29.9296	29.78	29.92	74761.0
2012-07-13	AOM	ETF	30.62	30.76	30.62	30.74	16257.0
2012-07-13	AOR	ETF	32.39	32.5	32.35	32.49	9097.0
2012-07-13	ARB	ETF	34.18	34.61	34.16	34.57	140231.0
2012-07-13	ARGT	ETF	15.76	15.76	15.76	15.76	50.0
2012-07-13	ASEA	ETF	15.85	16.0	15.84	15.95	14400.0
2012-07-13	AWAY	ETF	20.92	21.43	20.64	21.07	241734.0
2012-07-13	BAB	ETF	30.17	30.17	30.05	30.15	91563.0
2012-07-13	BAL	ETF	47.54	48.09	47.3755	47.9357	21402.0
2012-07-13	BALT	ETF	3.67	3.7	3.57	3.7	16431.0
2012-07-13	BBH	ETF	47.8	48.05	47.8	48.05	8500.0
2012-07-13	BCM	ETF	43.04	43.15	43.0295	43.138	2356.0
2012-07-13	BIB	ETF	13.4625	13.5799	13.4364	13.4525	21328.0
2012-07-13	BICK	ETF	21.8	22.07	21.8	22.03	7358.0
2012-07-13	BIL	ETF	91.62	91.64	91.62	91.64	159750.0
2012-07-13	BIS	ETF	3080.0	3081.6	3048.0	3067.2	56.0
2012-07-13	BIV	ETF	89.54	89.63	89.4	89.63	225400.0
2012-07-13	BJK	ETF	30.75	30.91	30.75	30.91	3000.0
2012-07-13	BKF	ETF	35.08	35.3582	34.99	35.3	40680.0
2012-07-13	BKLN	ETF	24.49	24.53	24.42	24.46	287700.0
2012-07-13	BLV	ETF	97.46	97.5	97.14	97.5	104500.0
2012-07-13	BMVP	ETF	15.34	15.3742	15.34	15.37	24255.0
2012-07-13	BND	ETF	84.81	84.86	84.75	84.86	703600.0
2012-07-13	BNO	ETF	35.755	36.35	35.75	36.145	149200.0
2012-07-13	BOIL	ETF	903800.0	949000.0	901200.0	926000.0	7.4
2012-07-13	BOND	ETF	106.78	106.78	106.671	106.73	519796.0

> showing 50 of 920 rows — these rows as CSV

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