PREVIEW / etf_daily / 2015-03-26

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-26.parquet
  size:    48 KB
  rows:    1,174

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-03-26	SPY	ETF	204.96	206.37	204.12	205.27	153067200.0
2015-03-26	QQQ	ETF	104.59	105.7	104.24	105.1	47846276.0
2015-03-26	IWM	ETF	122.09	122.91	121.54	122.32	26899200.0
2015-03-26	DIA	ETF	176.15	177.3	175.46	176.48	6604500.0
2015-03-26	GLD	ETF	115.73	115.84	115.34	115.48	5495200.0
2015-03-26	TLT	ETF	131.05	131.14	129.18	129.45	9536300.0
2015-03-26	AADR	ETF	38.41	38.9	38.37	38.9	3800.0
2015-03-26	AAXJ	ETF	63.05	63.12	62.73	62.98	552600.0
2015-03-26	ACWI	ETF	60.08	60.25	59.72	60.06	1060900.0
2015-03-26	ACWV	ETF	71.58	71.77	71.31	71.46	61900.0
2015-03-26	ACWX	ETF	44.97	45.0099	44.61	44.88	1646138.0
2015-03-26	ADRE	ETF	34.5101	34.5499	34.381	34.4229	2769.0
2015-03-26	AFK	ETF	24.74	24.75	24.53	24.6	13485.0
2015-03-26	AFTY	ETF	18.91	18.93	18.85	18.88	52100.0
2015-03-26	AGG	ETF	111.31	111.36	111.0	111.03	1377600.0
2015-03-26	AGQ	ETF	44.09	44.33	43.54	43.83	117600.0
2015-03-26	AGZ	ETF	114.2904	114.32	114.0	114.0633	30658.0
2015-03-26	AGZD	ETF	24.34	24.46	24.34	24.46	123000.0
2015-03-26	AIA	ETF	49.48	49.48	49.1753	49.3467	38733.0
2015-03-26	AIQ	ETF	21.46	21.75	21.1	21.51	17404.0
2015-03-26	AIRR	ETF	18.41	18.55	18.41	18.47	38100.0
2015-03-26	AIVI	ETF	44.82	44.82	44.4	44.52	126000.0
2015-03-26	ALTL	ETF	37.46	37.46	37.46	37.46	734.0
2015-03-26	AMJ	ETF	42.93	43.17	42.57	42.79	786208.0
2015-03-26	AMLP	ETF	82.95	83.25	82.3	82.55	903540.0
2015-03-26	AMZA	ETF	213.5	213.6	213.0	213.0	210.0
2015-03-26	ANGL	ETF	27.35	27.36	27.23	27.35	5200.0
2015-03-26	AOA	ETF	47.52	47.52	47.21	47.43	44800.0
2015-03-26	AOK	ETF	32.92	33.03	32.86	32.91	21793.0
2015-03-26	AOM	ETF	35.64	35.65	35.52	35.599	46757.0
2015-03-26	AOR	ETF	40.96	40.96	40.7	40.81	59678.0
2015-03-26	ARGT	ETF	21.64	21.64	21.02	21.03	12400.0
2015-03-26	ARKG	ETF	22.27	22.502	22.19	22.435	3500.0
2015-03-26	ARKK	ETF	20.79	20.79	20.79	20.79	200.0
2015-03-26	ARKQ	ETF	19.79	19.79	19.79	19.79	100.0
2015-03-26	ARKW	ETF	21.5	21.71	21.5	21.71	2300.0
2015-03-26	ASEA	ETF	15.63	15.63	15.56	15.6	25500.0
2015-03-26	ASHR	ETF	40.45	40.48	40.2	40.4	850900.0
2015-03-26	ASHS	ETF	46.74	46.9	46.56	46.72	26500.0
2015-03-26	ATMP	ETF	29.07	29.22	28.99	28.99	28400.0
2015-03-26	AVIV	ETF	36.17	36.56	36.17	36.29	216489.0
2015-03-26	AWAY	ETF	30.75	31.07	30.3	30.52	950005.0
2015-03-26	BAB	ETF	30.25	30.3506	30.02	30.09	100206.0
2015-03-26	BAL	ETF	42.7345	42.7345	42.7345	42.7345	429.0
2015-03-26	BALT	ETF	1.45	1.5	1.42	1.45	102785.0
2015-03-26	BAR	ETF	2.824	2.824	2.794	2.8	28280.0
2015-03-26	BBC	ETF	30.51	31.939	30.35	31.33	85502.0
2015-03-26	BBH	ETF	127.96	130.84	126.86	129.36	245400.0
2015-03-26	BBP	ETF	29.92	30.7	29.65	30.3	45600.0
2015-03-26	BCHP	ETF	19.129	19.16	19.06	19.16	8439.0

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

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