PREVIEW / etf_daily / 2013-12-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-20.parquet
  size:    43 KB
  rows:    1,060

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-12-20	SPY	ETF	180.69	181.99	180.57	181.56	197087000.0
2013-12-20	QQQ	ETF	85.75	86.68	85.73	86.5	40475437.0
2013-12-20	IWM	ETF	112.1	114.22	112.09	113.93	48770500.0
2013-12-20	DIA	ETF	161.62	162.53	161.61	162.01	7978200.0
2013-12-20	GLD	ETF	115.37	116.47	115.06	115.94	14693700.0
2013-12-20	TLT	ETF	103.72	104.29	103.3	104.25	12425700.0
2013-12-20	AADR	ETF	36.97	37.04	36.86	37.0	3900.0
2013-12-20	AAXJ	ETF	58.96	58.98	58.65	58.7	625400.0
2013-12-20	ACWI	ETF	56.12	56.41	56.09	56.31	1439900.0
2013-12-20	ACWV	ETF	62.51	62.7	62.41	62.61	31700.0
2013-12-20	ACWX	ETF	45.07	45.41	45.07	45.27	1551158.0
2013-12-20	ADRE	ETF	36.32	36.43	36.18	36.2	226718.0
2013-12-20	AFK	ETF	31.02	31.1499	30.9708	31.038	16274.0
2013-12-20	AGG	ETF	106.86	106.93	106.69	106.86	1378300.0
2013-12-20	AGQ	ETF	62.0	63.6	61.52	62.44	468250.0
2013-12-20	AGZ	ETF	110.731	110.9099	110.73	110.79	19847.0
2013-12-20	AGZD	ETF	24.95	24.95	24.95	24.95	400.0
2013-12-20	AIA	ETF	46.7901	47.029	46.7901	46.874	10389.0
2013-12-20	AIQ	ETF	24.69	25.09	24.4	25.03	71312.0
2013-12-20	AIVI	ETF	46.28	46.51	46.28	46.46	23100.0
2013-12-20	AMJ	ETF	44.08	44.68	43.71	44.51	655753.0
2013-12-20	AMLP	ETF	85.75	86.55	85.6	86.35	570060.0
2013-12-20	ANGL	ETF	26.95	27.1	26.95	27.04	1700.0
2013-12-20	AOA	ETF	43.87	44.11	43.87	44.07	45800.0
2013-12-20	AOK	ETF	31.83	31.92	31.83	31.89	24052.0
2013-12-20	AOM	ETF	34.13	34.21	34.0909	34.21	112344.0
2013-12-20	AOR	ETF	38.1738	38.25	38.1301	38.25	47188.0
2013-12-20	ARGT	ETF	19.94	19.94	19.61	19.68	4000.0
2013-12-20	ASEA	ETF	15.74	15.82	15.72	15.73	19900.0
2013-12-20	ASHR	ETF	24.13	24.17	23.98	24.15	850000.0
2013-12-20	ATMP	ETF	26.16	26.42	26.16	26.3	7000.0
2013-12-20	AVIV	ETF	23.51	23.78	23.22	23.73	290035.0
2013-12-20	AWAY	ETF	40.0	40.23	39.44	40.07	1572095.0
2013-12-20	BAB	ETF	27.48	27.56	27.44	27.542	263440.0
2013-12-20	BAL	ETF	52.53	52.5345	52.19	52.19	3637.0
2013-12-20	BALT	ETF	5.72	6.19	5.72	6.16	2117230.0
2013-12-20	BBH	ETF	86.01	87.57	85.71	87.33	69400.0
2013-12-20	BCM	ETF	39.48	39.65	39.39	39.62	321248.0
2013-12-20	BFOR	ETF	7.275	7.3725	7.275	7.3725	226400.0
2013-12-20	BIB	ETF	35.6125	36.775	35.35	36.75	272384.0
2013-12-20	BICK	ETF	24.19	24.19	24.14	24.1822	4269.0
2013-12-20	BIL	ETF	91.58	91.58	91.54	91.56	715800.0
2013-12-20	BIS	ETF	897.2	959.6	850.04	860.4	1403.5
2013-12-20	BIV	ETF	82.97	83.14	82.96	83.04	238900.0
2013-12-20	BIZD	ETF	20.9	21.27	20.9	21.25	10600.0
2013-12-20	BJK	ETF	52.1	52.1	51.82	51.96	17300.0
2013-12-20	BKF	ETF	36.9	37.08	36.76	36.79	196838.0
2013-12-20	BKLN	ETF	24.78	24.82	24.77	24.82	4989600.0
2013-12-20	BLV	ETF	82.77	83.19	82.41	83.19	111900.0
2013-12-20	BMVP	ETF	22.3	22.56	22.3	22.51	11614.0

> showing 50 of 1,060 rows — these rows as CSV

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