PREVIEW / etf_daily / 2015-03-02

all etf daily files

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

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-02	SPY	ETF	210.78	212.06	210.72	211.99	87491400.0
2015-03-02	QQQ	ETF	108.61	109.42	108.59	109.38	22988645.0
2015-03-02	IWM	ETF	122.55	123.78	122.53	123.47	29683500.0
2015-03-02	DIA	ETF	181.37	182.68	181.37	182.68	3213100.0
2015-03-02	GLD	ETF	116.5	116.64	115.62	115.68	7993300.0
2015-03-02	TLT	ETF	129.0	129.07	126.77	126.87	11324000.0
2015-03-02	AAXJ	ETF	63.96	64.12	63.78	64.09	1361100.0
2015-03-02	ACWI	ETF	60.88	61.16	60.88	61.15	1381500.0
2015-03-02	ACWV	ETF	71.88	71.98	71.75	71.98	74200.0
2015-03-02	ACWX	ETF	45.2	45.35	45.18	45.35	214163.0
2015-03-02	ADRE	ETF	36.4	36.4	36.195	36.32	11627.0
2015-03-02	AFK	ETF	25.89	25.905	25.6201	25.7	149458.0
2015-03-02	AGG	ETF	110.99	110.99	110.45	110.45	7881900.0
2015-03-02	AGQ	ETF	41.6	41.68	40.45	40.57	137700.0
2015-03-02	AGZ	ETF	113.9	114.45	113.31	113.95	51119.0
2015-03-02	AGZD	ETF	24.51	24.625	24.51	24.595	12000.0
2015-03-02	AIA	ETF	49.59	49.75	49.55	49.75	22253.0
2015-03-02	AIQ	ETF	23.91	24.23	23.57	23.84	15707.0
2015-03-02	AIRR	ETF	18.38	18.61	18.38	18.57	19700.0
2015-03-02	AIVI	ETF	45.41	45.49	45.26	45.47	42500.0
2015-03-02	ALTL	ETF	37.91	37.91	37.91	37.91	338.0
2015-03-02	AMJ	ETF	44.63	44.725	44.04	44.13	598370.0
2015-03-02	AMLP	ETF	84.95	85.3	84.25	84.25	680080.0
2015-03-02	AMZA	ETF	226.0	226.0	220.5	220.5	230.0
2015-03-02	ANGL	ETF	27.26	27.53	27.26	27.29	1000.0
2015-03-02	AOA	ETF	48.03	48.03	47.79	47.86	66200.0
2015-03-02	AOK	ETF	33.1	33.1	32.87	32.87	52830.0
2015-03-02	AOM	ETF	35.83	35.83	35.6	35.6	95878.0
2015-03-02	AOR	ETF	41.31	41.31	41.02	41.02	82907.0
2015-03-02	ARGT	ETF	19.85	20.12	19.85	20.1	8300.0
2015-03-02	ARKG	ETF	23.45	23.49	23.29	23.39	4200.0
2015-03-02	ARKK	ETF	21.54	21.54	21.42	21.499	3300.0
2015-03-02	ARKQ	ETF	20.465	20.465	20.448	20.448	900.0
2015-03-02	ARKW	ETF	22.53	22.53	22.286	22.41	4100.0
2015-03-02	ASEA	ETF	15.7	15.7	15.61	15.63	7900.0
2015-03-02	ASHR	ETF	36.49	36.79	36.4	36.73	593600.0
2015-03-02	ASHS	ETF	39.99	40.46	39.99	40.46	10400.0
2015-03-02	ATMP	ETF	29.8	29.8	29.44	29.51	32500.0
2015-03-02	AVIV	ETF	35.91	36.96	35.91	36.38	121194.0
2015-03-02	AWAY	ETF	31.17	31.26	30.18	31.18	2119462.0
2015-03-02	BAB	ETF	30.3	30.3675	30.1198	30.18	391332.0
2015-03-02	BAL	ETF	43.88	44.271	43.73	44.04	28770.0
2015-03-02	BALT	ETF	1.78	1.82	1.73	1.73	375854.0
2015-03-02	BAR	ETF	2.8539	2.8542	2.841	2.841	36760.0
2015-03-02	BBC	ETF	31.92	31.92	31.22	31.54	21075.0
2015-03-02	BBH	ETF	128.37	129.07	127.98	128.93	164200.0
2015-03-02	BBP	ETF	30.62	30.62	29.96	30.23	9700.0
2015-03-02	BCHP	ETF	19.446	19.446	19.44	19.44	1049.0
2015-03-02	BCM	ETF	31.82	31.82	31.713	31.713	2798.0
2015-03-02	BFOR	ETF	8.19	8.245	8.19	8.245	77200.0

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

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