PREVIEW / etf_daily / 2015-04-08

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-08.parquet
  size:    48 KB
  rows:    1,180

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
2015-04-08	SPY	ETF	207.55	208.51	207.08	207.98	89351900.0
2015-04-08	QQQ	ETF	105.84	106.79	105.83	106.64	25866907.0
2015-04-08	IWM	ETF	124.38	125.66	124.38	125.47	19314400.0
2015-04-08	DIA	ETF	178.6	179.56	177.96	178.75	4738500.0
2015-04-08	GLD	ETF	115.98	116.03	114.9	115.47	5568500.0
2015-04-08	TLT	ETF	131.02	131.36	130.02	131.13	5378900.0
2015-04-08	AAXJ	ETF	67.21	67.43	66.92	67.2	1484600.0
2015-04-08	ACWI	ETF	61.35	61.53	61.12	61.35	4484800.0
2015-04-08	ACWV	ETF	72.84	73.09	72.66	72.93	199300.0
2015-04-08	ACWX	ETF	46.41	46.5199	46.08	46.28	218812.0
2015-04-08	ADRE	ETF	36.41	36.7316	36.41	36.6599	11623.0
2015-04-08	AFK	ETF	26.14	26.189	25.86	25.86	28591.0
2015-04-08	AFTY	ETF	21.23	21.23	20.63	20.78	95100.0
2015-04-08	AGG	ETF	111.56	111.59	111.36	111.53	903000.0
2015-04-08	AGQ	ETF	42.48	42.55	40.4	41.04	251700.0
2015-04-08	AGZ	ETF	114.24	114.53	114.0001	114.08	484856.0
2015-04-08	AGZD	ETF	24.45	24.54	24.45	24.54	5000.0
2015-04-08	AIA	ETF	52.14	52.43	51.87	52.31	145977.0
2015-04-08	AIQ	ETF	23.66	23.85	23.07	23.5	11060.0
2015-04-08	AIRR	ETF	19.07	19.12	19.011	19.12	2800.0
2015-04-08	AIVI	ETF	45.49	45.49	44.9	45.01	16000.0
2015-04-08	AMJ	ETF	43.48	43.6446	43.14	43.35	927368.0
2015-04-08	AMLP	ETF	83.65	83.8	83.15	83.45	688500.0
2015-04-08	AMZA	ETF	212.5	212.5	211.5	212.2	250.0
2015-04-08	ANGL	ETF	27.45	27.46	27.31	27.45	9300.0
2015-04-08	AOA	ETF	48.1	48.24	47.96	48.12	26100.0
2015-04-08	AOK	ETF	33.29	33.29	33.11	33.18	32795.0
2015-04-08	AOM	ETF	35.89	35.9611	35.81	35.9	34991.0
2015-04-08	AOR	ETF	41.3	41.34	41.1401	41.19	40054.0
2015-04-08	ARGT	ETF	22.04	22.04	21.78	21.88	13000.0
2015-04-08	ARKG	ETF	23.22	23.22	22.9	23.0	2200.0
2015-04-08	ARKK	ETF	21.26	21.26	21.216	21.216	900.0
2015-04-08	ARKQ	ETF	20.41	20.41	20.41	20.41	100.0
2015-04-08	ARKW	ETF	22.37	22.37	22.37	22.37	100.0
2015-04-08	ASEA	ETF	16.1	16.12	16.02	16.05	12600.0
2015-04-08	ASHR	ETF	44.37	44.46	43.66	44.18	3273200.0
2015-04-08	ASHS	ETF	52.62	52.62	51.25	51.54	92400.0
2015-04-08	ATMP	ETF	29.43	29.66	29.43	29.5	16300.0
2015-04-08	AWAY	ETF	30.37	31.91	30.37	31.9	1288412.0
2015-04-08	BAB	ETF	30.5	30.51	30.2526	30.44	59408.0
2015-04-08	BAL	ETF	45.43	45.84	45.42	45.52	19470.0
2015-04-08	BALT	ETF	1.68	1.7	1.34	1.35	5026568.0
2015-04-08	BAR	ETF	2.901	2.901	2.787	2.787	16270.0
2015-04-08	BBC	ETF	32.6	33.59	32.6	33.4	15358.0
2015-04-08	BBH	ETF	129.0	131.91	129.0	131.02	179700.0
2015-04-08	BBP	ETF	32.12	32.55	31.258	32.31	14300.0
2015-04-08	BCHP	ETF	19.55	19.55	19.54	19.54	235.0
2015-04-08	BCM	ETF	31.21	31.21	30.7305	30.7305	2023.0
2015-04-08	BFOR	ETF	8.355	8.4125	8.3425	8.39	68400.0
2015-04-08	BIB	ETF	79.005	83.68	78.8	82.995	1323786.0

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

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