PREVIEW / etf_daily / 2013-06-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-03.parquet
  size:    41 KB
  rows:    1,004

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-06-03	SPY	ETF	163.83	164.46	162.66	164.35	168390700.0
2013-06-03	QQQ	ETF	73.31	73.4	72.43	73.38	47613032.0
2013-06-03	IWM	ETF	98.14	98.84	97.03	98.73	87088500.0
2013-06-03	DIA	ETF	151.54	152.36	151.1	152.31	10861300.0
2013-06-03	GLD	ETF	134.77	136.98	134.43	136.51	9173000.0
2013-06-03	TLT	ETF	113.78	115.49	113.7	114.78	15564500.0
2013-06-03	AAXJ	ETF	58.43	59.16	58.3	59.09	351900.0
2013-06-03	ACTV	ETF	6.7	6.87	6.63	6.85	494139.0
2013-06-03	ACWI	ETF	52.07	52.22	51.77	52.18	5054200.0
2013-06-03	ACWV	ETF	60.6	61.09	60.44	60.99	43200.0
2013-06-03	ACWX	ETF	43.06	43.32	42.83	43.28	210373.0
2013-06-03	ADRE	ETF	37.41	37.553	37.2	37.53	33573.0
2013-06-03	AFK	ETF	30.1	30.37	30.0101	30.37	16638.0
2013-06-03	AGEM	ETF	21.63	21.8	21.63	21.8	6297.0
2013-06-03	AGG	ETF	108.79	109.08	108.73	108.97	2110400.0
2013-06-03	AGQ	ETF	90.32	94.64	89.52	92.72	479875.0
2013-06-03	AGZ	ETF	112.28	112.68	112.25	112.59	14139.0
2013-06-03	AIA	ETF	45.67	46.11	45.6019	46.08	98304.0
2013-06-03	AIQ	ETF	16.54	16.54	15.7	16.0	43231.0
2013-06-03	AIVI	ETF	42.88	43.32	42.74	43.32	17500.0
2013-06-03	ALTL	ETF	28.64	28.64	28.64	28.64	151.0
2013-06-03	AMJ	ETF	45.07	45.417	44.97	45.22	786535.0
2013-06-03	AMLP	ETF	87.25	88.55	86.6	88.55	967500.0
2013-06-03	ANGL	ETF	27.54	27.54	27.18	27.3	2200.0
2013-06-03	AOA	ETF	40.66	40.72	40.44	40.72	28200.0
2013-06-03	AOK	ETF	31.22	31.24	31.1001	31.24	26468.0
2013-06-03	AOM	ETF	32.95	33.03	32.88	33.03	13711.0
2013-06-03	AOR	ETF	36.12	36.17	35.97	36.16	29245.0
2013-06-03	ARB	ETF	46.9	46.95	46.8	46.8	530197.0
2013-06-03	ARGT	ETF	17.73	17.76	17.73	17.76	400.0
2013-06-03	ASEA	ETF	17.52	17.84	17.47	17.81	200600.0
2013-06-03	ATMP	ETF	25.34	25.39	25.28	25.37	21100.0
2013-06-03	AVIV	ETF	25.91	26.27	25.801	26.26	300390.0
2013-06-03	AWAY	ETF	30.28	30.42	28.015	29.25	2105948.0
2013-06-03	BAB	ETF	29.86	30.16	29.86	30.03	289614.0
2013-06-03	BAL	ETF	50.45	52.14	50.011	52.04	16027.0
2013-06-03	BALT	ETF	3.66	3.66	3.61	3.64	104109.0
2013-06-03	BBH	ETF	72.14	72.14	68.6	70.53	343400.0
2013-06-03	BCM	ETF	40.7032	40.7032	40.7032	40.7032	446.0
2013-06-03	BIB	ETF	24.3775	24.3775	22.2775	23.793	710504.0
2013-06-03	BICK	ETF	23.34	23.46	23.22	23.45	3802.0
2013-06-03	BIL	ETF	91.6	91.62	91.6	91.62	453450.0
2013-06-03	BIS	ETF	1458.4	1570.76	1458.4	1500.0	620.0
2013-06-03	BIV	ETF	85.71	86.06	85.55	85.82	830200.0
2013-06-03	BIZD	ETF	20.14	20.14	19.63	19.76	14700.0
2013-06-03	BJK	ETF	42.27	42.5	42.23	42.5	9700.0
2013-06-03	BKF	ETF	37.72	38.05	37.5575	38.03	163877.0
2013-06-03	BKLN	ETF	25.06	25.08	25.03	25.07	5484900.0
2013-06-03	BLV	ETF	88.63	89.63	88.2	88.95	101700.0
2013-06-03	BMVP	ETF	19.12	19.1879	19.09	19.1879	711.0

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

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