PREVIEW / etf_daily / 2013-06-19

all etf daily files

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

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-19	SPY	ETF	165.6	165.89	163.38	163.45	206149500.0
2013-06-19	QQQ	ETF	73.57	73.68	72.68	72.76	43145076.0
2013-06-19	IWM	ETF	99.51	99.7	98.16	98.29	43193500.0
2013-06-19	DIA	ETF	152.94	153.22	151.05	151.09	9143700.0
2013-06-19	GLD	ETF	132.58	133.15	130.38	130.59	13017800.0
2013-06-19	TLT	ETF	113.74	113.79	111.62	112.11	17138200.0
2013-06-19	AADR	ETF	34.09	34.09	34.01	34.01	1500.0
2013-06-19	AAXJ	ETF	56.08	56.12	54.94	54.99	517300.0
2013-06-19	ACTV	ETF	7.04	7.12	6.96	7.05	311767.0
2013-06-19	ACWI	ETF	52.22	52.39	51.43	51.47	1477100.0
2013-06-19	ACWV	ETF	61.45	61.75	60.65	60.65	72300.0
2013-06-19	ACWX	ETF	43.0475	43.12	42.22	42.24	334819.0
2013-06-19	ADRE	ETF	35.4	35.502	34.62	34.64	25888.0
2013-06-19	AFK	ETF	28.88	28.92	28.25	28.31	23308.0
2013-06-19	AGG	ETF	108.82	108.82	107.8	107.93	975800.0
2013-06-19	AGQ	ETF	84.04	85.2	80.84	81.48	388675.0
2013-06-19	AGZ	ETF	111.95	112.1499	111.35	111.35	47520.0
2013-06-19	AIA	ETF	43.4	43.64	42.78	42.78	125835.0
2013-06-19	AIQ	ETF	16.11	16.15	15.9401	16.15	15635.0
2013-06-19	AIVI	ETF	43.11	43.31	42.37	42.41	47300.0
2013-06-19	AMJ	ETF	46.4	46.49	45.55	45.88	841212.0
2013-06-19	AMLP	ETF	88.75	88.9	88.05	88.2	496520.0
2013-06-19	ANGL	ETF	27.13	27.13	26.98	27.02	3300.0
2013-06-19	AOA	ETF	40.98	40.98	40.4	40.43	35800.0
2013-06-19	AOK	ETF	31.22	31.34	30.97	31.0	19940.0
2013-06-19	AOM	ETF	33.02	33.11	32.71	32.83	76700.0
2013-06-19	AOR	ETF	36.27	36.34	35.84	35.84	57855.0
2013-06-19	ARB	ETF	46.86	46.9	46.77	46.78	151029.0
2013-06-19	ARGT	ETF	16.85	16.85	16.85	16.85	200.0
2013-06-19	ASEA	ETF	17.23	17.23	16.73	16.85	41300.0
2013-06-19	ATMP	ETF	25.86	25.87	25.61	25.61	15100.0
2013-06-19	AVIV	ETF	26.26	26.97	25.858	25.88	227039.0
2013-06-19	AWAY	ETF	30.17	30.64	29.57	29.98	878779.0
2013-06-19	BAB	ETF	28.99	29.01	28.6	28.69	764714.0
2013-06-19	BAL	ETF	55.39	56.08	55.19	55.19	26022.0
2013-06-19	BALT	ETF	3.69	3.7	3.61	3.61	48790.0
2013-06-19	BBH	ETF	69.54	69.54	67.83	67.84	70800.0
2013-06-19	BCM	ETF	40.7021	40.7021	40.7021	40.7021	122.0
2013-06-19	BFOR	ETF	6.38	6.38	6.28	6.28	295200.0
2013-06-19	BIB	ETF	23.75	23.75	22.5678	22.5678	91024.0
2013-06-19	BICK	ETF	21.99	21.99	21.5	21.5	3257.0
2013-06-19	BIL	ETF	91.62	91.62	91.6	91.6	116200.0
2013-06-19	BIS	ETF	1567.6	1567.6	1497.56	1547.6	170.5
2013-06-19	BIV	ETF	85.55	85.55	84.4	84.43	257400.0
2013-06-19	BIZD	ETF	19.93	19.93	19.74	19.79	3300.0
2013-06-19	BJK	ETF	42.65	42.7	42.0	42.0	11100.0
2013-06-19	BKF	ETF	35.62	35.62	34.7	34.72	110939.0
2013-06-19	BKLN	ETF	24.91	24.91	24.75	24.77	2218600.0
2013-06-19	BLV	ETF	87.79	88.0	86.36	86.43	58500.0
2013-06-19	BMVP	ETF	19.4747	19.51	19.3133	19.3183	34712.0

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

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