PREVIEW / etf_daily / 2012-07-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-18.parquet
  size:    38 KB
  rows:    932

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-18	SPY	ETF	136.04	137.64	135.96	137.37	113349700.0
2012-07-18	QQQ	ETF	63.4	64.58	63.39	64.39	44489605.0
2012-07-18	IWM	ETF	79.6	80.71	79.55	80.22	46045000.0
2012-07-18	DIA	ETF	127.49	129.15	127.43	128.96	3099300.0
2012-07-18	GLD	ETF	152.67	153.6	152.4	153.05	6807600.0
2012-07-18	TLT	ETF	129.26	129.34	128.79	128.82	4011000.0
2012-07-18	AADR	ETF	28.19	28.19	28.19	28.19	1100.0
2012-07-18	AAXJ	ETF	51.55	52.22	51.55	52.1	144900.0
2012-07-18	ACTV	ETF	14.71	15.09	14.71	14.98	108315.0
2012-07-18	ACWI	ETF	43.64	44.16	43.59	44.09	912200.0
2012-07-18	ACWV	ETF	55.5	55.55	55.22	55.55	3300.0
2012-07-18	ACWX	ETF	36.67	37.096	36.64	37.05	183304.0
2012-07-18	ADRE	ETF	37.03	37.4801	37.03	37.4	16583.0
2012-07-18	AFK	ETF	28.13	28.41	28.019	28.3	44506.0
2012-07-18	AGEM	ETF	21.15	21.15	21.15	21.15	180.0
2012-07-18	AGG	ETF	112.24	112.36	112.24	112.35	470300.0
2012-07-18	AGQ	ETF	147.32	149.92	147.04	148.84	187675.0
2012-07-18	AGZ	ETF	113.94	114.0	113.79	113.94	9362.0
2012-07-18	AIA	ETF	40.55	40.9299	40.55	40.8577	3659.0
2012-07-18	AIQ	ETF	4.55	4.55	4.4005	4.45	2040.0
2012-07-18	AIVI	ETF	37.53	37.96	37.53	37.9	24300.0
2012-07-18	AMJ	ETF	39.88	39.95	39.77	39.79	1760692.0
2012-07-18	AMLP	ETF	82.65	82.75	82.4	82.5	451520.0
2012-07-18	ANGL	ETF	25.77	25.77	25.45	25.65	83000.0
2012-07-18	AOA	ETF	34.9	35.24	34.9	35.21	7300.0
2012-07-18	AOK	ETF	29.92	30.05	29.92	30.017	31405.0
2012-07-18	AOM	ETF	30.74	30.92	30.74	30.8803	10885.0
2012-07-18	AOR	ETF	32.53	32.75	32.53	32.73	20431.0
2012-07-18	ARB	ETF	34.43	35.33	34.32	34.84	106915.0
2012-07-18	ARGT	ETF	15.92	15.98	15.8	15.8	2400.0
2012-07-18	ASEA	ETF	16.08	16.22	16.05	16.22	18800.0
2012-07-18	AWAY	ETF	21.43	22.23	21.43	22.12	411986.0
2012-07-18	BAB	ETF	30.29	30.29	30.2101	30.22	189714.0
2012-07-18	BAL	ETF	47.4799	48.12	47.4799	47.52	13148.0
2012-07-18	BALT	ETF	3.53	3.55	3.5	3.53	11664.0
2012-07-18	BBH	ETF	48.84	49.48	48.84	49.25	48600.0
2012-07-18	BCM	ETF	43.5095	43.5095	43.5095	43.5095	127.0
2012-07-18	BIB	ETF	14.0312	14.2812	14.0312	14.1687	46648.0
2012-07-18	BICK	ETF	21.94	22.07	21.8713	21.99	7165.0
2012-07-18	BIL	ETF	91.64	91.64	91.62	91.62	108500.0
2012-07-18	BIS	ETF	2964.8	2964.8	2883.2	2913.28	150.5
2012-07-18	BIV	ETF	89.91	89.95	89.79	89.87	192000.0
2012-07-18	BJK	ETF	31.19	31.34	31.19	31.2	16300.0
2012-07-18	BKF	ETF	35.18	35.61	35.08	35.53	70240.0
2012-07-18	BKLN	ETF	24.5	24.52	24.47	24.5	259500.0
2012-07-18	BLV	ETF	98.12	98.12	97.68	97.97	28800.0
2012-07-18	BMVP	ETF	15.45	15.6467	15.45	15.5767	16219.0
2012-07-18	BND	ETF	84.99	85.08	84.98	85.02	630600.0
2012-07-18	BNO	ETF	37.09	37.43	37.09	37.42	49200.0
2012-07-18	BOIL	ETF	911200.0	979800.0	904600.0	969200.0	13.6

> showing 50 of 932 rows — these rows as CSV

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