PREVIEW / etf_daily / 2013-04-10

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-10.parquet
  size:    40 KB
  rows:    987

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-10	SPY	ETF	157.17	158.87	157.13	158.67	135711100.0
2013-04-10	QQQ	ETF	68.89	70.17	68.88	70.015	55271262.0
2013-04-10	IWM	ETF	92.51	94.1	92.45	93.89	50119600.0
2013-04-10	DIA	ETF	146.98	148.06	146.96	147.78	7947100.0
2013-04-10	GLD	ETF	152.67	152.71	150.58	150.75	18507400.0
2013-04-10	TLT	ETF	120.59	120.66	119.9	119.91	10765200.0
2013-04-10	AAXJ	ETF	57.98	58.48	57.98	58.31	350800.0
2013-04-10	ACTV	ETF	4.17	4.3	4.16	4.28	180972.0
2013-04-10	ACWI	ETF	50.99	51.45	50.99	51.4	383700.0
2013-04-10	ACWV	ETF	62.26	62.57	62.16	62.52	296700.0
2013-04-10	ACWX	ETF	42.96	43.32	42.96	43.28	172941.0
2013-04-10	ADRE	ETF	38.49	38.948	38.49	38.77	69258.0
2013-04-10	AFK	ETF	30.35	30.4599	30.08	30.17	22839.0
2013-04-10	AGEM	ETF	22.44	22.8	22.44	22.63	1536.0
2013-04-10	AGG	ETF	110.9	110.91	110.77	110.82	1281600.0
2013-04-10	AGQ	ETF	145.76	145.96	141.64	142.72	385075.0
2013-04-10	AGZ	ETF	113.7	113.7	113.53	113.53	9794.0
2013-04-10	AIA	ETF	45.61	45.74	45.5	45.59	13619.0
2013-04-10	AIQ	ETF	8.8	9.28	8.8	9.2	38663.0
2013-04-10	AIVI	ETF	42.81	43.11	42.81	43.02	19000.0
2013-04-10	AMJ	ETF	46.09	46.22	45.7	45.96	792449.0
2013-04-10	AMLP	ETF	88.8	88.95	88.5	88.6	621620.0
2013-04-10	ANGL	ETF	27.2	27.33	27.2	27.33	1300.0
2013-04-10	AOA	ETF	39.74	40.02	39.74	40.0	37700.0
2013-04-10	AOK	ETF	31.2348	31.34	31.2348	31.32	22471.0
2013-04-10	AOM	ETF	32.76	32.92	32.76	32.88	37285.0
2013-04-10	AOR	ETF	35.63	35.84	35.63	35.81	19842.0
2013-04-10	ARB	ETF	46.75	46.86	46.75	46.8	181377.0
2013-04-10	ARGT	ETF	17.48	17.48	17.44	17.44	400.0
2013-04-10	ASEA	ETF	17.71	17.75	17.56	17.75	14900.0
2013-04-10	ATMP	ETF	26.07	26.16	26.07	26.1	50300.0
2013-04-10	AVIV	ETF	24.89	25.68	24.89	25.45	424787.0
2013-04-10	AWAY	ETF	30.68	32.58	30.68	31.87	1259025.0
2013-04-10	BAB	ETF	30.72	30.72	30.5601	30.64	253853.0
2013-04-10	BAL	ETF	55.28	57.71	55.08	55.12	19795.0
2013-04-10	BALT	ETF	3.62	3.69	3.6	3.67	52150.0
2013-04-10	BBH	ETF	65.34	67.09	65.34	67.09	266800.0
2013-04-10	BCM	ETF	42.29	42.32	42.27	42.27	767.0
2013-04-10	BIB	ETF	19.99	20.86	19.99	20.8365	128972.0
2013-04-10	BICK	ETF	23.62	23.8499	23.615	23.75	3822.0
2013-04-10	BIL	ETF	91.62	91.62	91.6	91.62	74250.0
2013-04-10	BIS	ETF	1829.6	1829.6	1794.8	1794.8	40.0
2013-04-10	BIV	ETF	88.04	88.09	87.9	87.9	368700.0
2013-04-10	BIZD	ETF	19.83	20.16	19.83	20.14	15700.0
2013-04-10	BJK	ETF	39.89	40.14	39.87	40.12	8600.0
2013-04-10	BKF	ETF	38.78	39.09	38.76	38.86	95760.0
2013-04-10	BKLN	ETF	25.13	25.14	25.12	25.14	2009900.0
2013-04-10	BLV	ETF	93.29	93.29	92.86	92.96	174600.0
2013-04-10	BMVP	ETF	18.56	18.7348	18.56	18.7297	20426.0
2013-04-10	BND	ETF	83.76	83.76	83.63	83.65	864100.0

> showing 50 of 987 rows — these rows as CSV

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