PREVIEW / etf_daily / 2015-03-19

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-19.parquet
  size:    47 KB
  rows:    1,152

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-19	SPY	ETF	209.96	210.47	209.03	209.5	117917300.0
2015-03-19	QQQ	ETF	108.03	108.38	107.87	108.08	31314035.0
2015-03-19	IWM	ETF	124.36	124.96	124.31	124.89	34008200.0
2015-03-19	DIA	ETF	180.18	180.39	179.31	179.66	6229200.0
2015-03-19	GLD	ETF	111.85	112.58	111.58	112.29	6537700.0
2015-03-19	TLT	ETF	131.2	131.62	130.27	130.82	9543800.0
2015-03-19	AAXJ	ETF	63.38	63.38	63.01	63.31	1987400.0
2015-03-19	ACWI	ETF	60.31	60.47	60.12	60.22	1201400.0
2015-03-19	ACWV	ETF	71.52	71.67	71.4	71.56	119400.0
2015-03-19	ACWX	ETF	44.56	44.6099	44.35	44.42	140492.0
2015-03-19	ADRE	ETF	34.96	35.1869	34.7419	34.86	8565.0
2015-03-19	AFK	ETF	24.33	24.46	24.18	24.27	25008.0
2015-03-19	AFTY	ETF	18.97	18.97	18.75	18.859	29600.0
2015-03-19	AGG	ETF	111.24	111.3	110.94	110.98	1929700.0
2015-03-19	AGQ	ETF	38.57	39.6	38.25	39.3	216900.0
2015-03-19	AGZ	ETF	114.0	114.3899	113.9201	114.09	39743.0
2015-03-19	AGZD	ETF	24.475	24.525	24.43	24.51	6600.0
2015-03-19	AIA	ETF	49.72	49.72	49.3701	49.6	29263.0
2015-03-19	AIQ	ETF	24.3	24.41	23.99	24.21	12866.0
2015-03-19	AIRR	ETF	18.36	18.41	18.29	18.35	473100.0
2015-03-19	AIVI	ETF	44.12	44.12	43.73	43.8	29300.0
2015-03-19	AMJ	ETF	42.16	42.3	41.84	42.19	920717.0
2015-03-19	AMLP	ETF	81.6	81.85	81.4	81.85	606780.0
2015-03-19	AMZA	ETF	210.3	210.3	207.7	208.3	420.0
2015-03-19	ANGL	ETF	27.26	27.27	27.23	27.23	6700.0
2015-03-19	AOA	ETF	47.58	47.7	47.42	47.51	22500.0
2015-03-19	AOK	ETF	33.14	33.14	32.83	32.937	82185.0
2015-03-19	AOM	ETF	35.86	35.86	35.52	35.639	78516.0
2015-03-19	AOR	ETF	41.1	41.1	40.78	40.89	66471.0
2015-03-19	ARGT	ETF	21.68	21.68	21.48	21.48	16700.0
2015-03-19	ARKG	ETF	23.5	23.99	23.5	23.975	22700.0
2015-03-19	ARKK	ETF	21.14	21.14	21.1	21.1	600.0
2015-03-19	ARKQ	ETF	20.49	20.49	20.276	20.276	3800.0
2015-03-19	ARKW	ETF	21.99	21.99	21.99	21.99	400.0
2015-03-19	ASEA	ETF	15.39	15.39	15.33	15.39	5600.0
2015-03-19	ASHR	ETF	39.77	39.79	39.48	39.7	872400.0
2015-03-19	ASHS	ETF	45.18	45.23	45.1	45.18	8500.0
2015-03-19	ATMP	ETF	28.92	28.92	28.76	28.86	130200.0
2015-03-19	AVIV	ETF	35.94	36.37	35.89	35.89	268538.0
2015-03-19	AWAY	ETF	30.8	31.24	30.56	30.96	827172.0
2015-03-19	BAB	ETF	30.24	30.24	30.12	30.1756	60025.0
2015-03-19	BAL	ETF	42.57	42.97	42.23	42.48	14827.0
2015-03-19	BALT	ETF	1.27	1.39	1.24	1.24	887958.0
2015-03-19	BAR	ETF	2.496	2.586	2.496	2.5807	18770.0
2015-03-19	BBC	ETF	34.64	35.8125	34.64	35.65	88014.0
2015-03-19	BBH	ETF	135.75	137.94	135.75	137.76	267400.0
2015-03-19	BBP	ETF	32.71	32.72	32.23	32.6	15200.0
2015-03-19	BCHP	ETF	19.2	19.2	19.2	19.2	300.0
2015-03-19	BCM	ETF	30.02	30.179	29.99	30.144	15429.0
2015-03-19	BFOR	ETF	8.275	8.2825	8.26	8.28	97200.0

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

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