PREVIEW / etf_daily / 2013-04-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-11.parquet
  size:    40 KB
  rows:    981

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
2013-04-11	SPY	ETF	158.7	159.71	158.54	159.19	110142500.0
2013-04-11	QQQ	ETF	69.84	70.15	69.77	69.99	37238268.0
2013-04-11	IWM	ETF	93.83	94.57	93.75	94.02	32619000.0
2013-04-11	DIA	ETF	147.82	148.66	147.63	148.4	6975600.0
2013-04-11	GLD	ETF	150.76	151.71	150.63	151.05	8063200.0
2013-04-11	TLT	ETF	120.17	120.49	119.89	120.14	7501800.0
2013-04-11	AADR	ETF	33.44	33.44	33.44	33.44	100.0
2013-04-11	AAXJ	ETF	58.27	58.56	58.24	58.34	288300.0
2013-04-11	ACTV	ETF	4.25	4.48	4.24	4.46	180099.0
2013-04-11	ACWI	ETF	51.55	51.81	51.46	51.65	509300.0
2013-04-11	ACWV	ETF	62.55	62.83	62.55	62.65	64300.0
2013-04-11	ACWX	ETF	43.46	43.64	43.36	43.48	167127.0
2013-04-11	ADRE	ETF	38.76	38.76	38.561	38.64	33334.0
2013-04-11	AFK	ETF	30.84	30.84	30.056	30.06	64913.0
2013-04-11	AGEM	ETF	22.5575	22.6	22.4889	22.4889	862.0
2013-04-11	AGG	ETF	110.84	110.91	110.82	110.84	1037400.0
2013-04-11	AGQ	ETF	142.56	145.12	142.0	142.84	192050.0
2013-04-11	AGZ	ETF	113.44	113.6399	113.44	113.49	12125.0
2013-04-11	AIA	ETF	45.74	45.76	45.53	45.59	23971.0
2013-04-11	AIQ	ETF	9.59	9.6	9.438	9.44	41955.0
2013-04-11	AIVI	ETF	43.18	43.43	43.13	43.26	19600.0
2013-04-11	ALTL	ETF	29.57	29.57	29.57	29.57	590.0
2013-04-11	AMJ	ETF	45.99	46.0699	45.5	45.61	1662318.0
2013-04-11	AMLP	ETF	88.5	88.6	88.2	88.35	739300.0
2013-04-11	AOA	ETF	40.09	40.27	40.05	40.16	88000.0
2013-04-11	AOK	ETF	31.36	31.4	31.3	31.3	106780.0
2013-04-11	AOM	ETF	32.96	33.029	32.9298	32.9765	40123.0
2013-04-11	AOR	ETF	35.79	36.0	35.79	35.9157	64438.0
2013-04-11	ARB	ETF	46.8	46.81	46.72	46.75	150315.0
2013-04-11	ARGT	ETF	17.42	17.46	17.4	17.46	1350.0
2013-04-11	ASEA	ETF	17.77	17.85	17.76	17.81	7900.0
2013-04-11	ATMP	ETF	26.01	26.1	26.01	26.07	12400.0
2013-04-11	AVIV	ETF	25.38	25.498	24.7901	24.92	625116.0
2013-04-11	AWAY	ETF	32.04	33.41	32.03	32.91	1603484.0
2013-04-11	BAB	ETF	30.69	30.7755	30.6301	30.75	590674.0
2013-04-11	BAL	ETF	55.4	55.51	54.65	54.71	12380.0
2013-04-11	BALT	ETF	3.649	3.75	3.649	3.75	33123.0
2013-04-11	BBH	ETF	67.27	68.21	67.27	67.93	281500.0
2013-04-11	BCM	ETF	42.264	42.264	42.264	42.264	100.0
2013-04-11	BIB	ETF	20.95	21.645	20.95	21.495	206988.0
2013-04-11	BICK	ETF	23.65	23.6715	23.596	23.596	13733.0
2013-04-11	BIL	ETF	91.62	91.62	91.6	91.6	281900.0
2013-04-11	BIS	ETF	1784.8	1784.8	1729.96	1729.96	20.0
2013-04-11	BIV	ETF	88.05	88.09	87.96	88.04	158500.0
2013-04-11	BIZD	ETF	20.12	20.17	20.0	20.0	12200.0
2013-04-11	BJK	ETF	40.33	40.39	40.2	40.3	6400.0
2013-04-11	BKF	ETF	38.66	38.76	38.54	38.56	98544.0
2013-04-11	BKLN	ETF	25.14	25.15	25.12	25.15	4018700.0
2013-04-11	BLV	ETF	93.15	93.15	92.88	92.99	113600.0
2013-04-11	BMVP	ETF	18.74	18.79	18.72	18.76	12418.0

> showing 50 of 981 rows — these rows as CSV

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