PREVIEW / etf_daily / 2015-02-23

all etf daily files

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

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-02-23	SPY	ETF	210.94	211.21	210.48	211.21	74411100.0
2015-02-23	QQQ	ETF	108.35	108.55	108.11	108.52	17867968.0
2015-02-23	IWM	ETF	122.1	122.53	121.27	122.5	25778200.0
2015-02-23	DIA	ETF	180.71	180.92	180.32	180.92	2738600.0
2015-02-23	GLD	ETF	115.11	116.22	115.07	115.43	4812400.0
2015-02-23	TLT	ETF	127.19	128.17	127.16	127.99	7500500.0
2015-02-23	AADR	ETF	38.7	38.7	38.7	38.7	300.0
2015-02-23	AAXJ	ETF	63.3	63.5	63.09	63.21	487600.0
2015-02-23	ACWI	ETF	60.72	60.88	60.69	60.85	1000400.0
2015-02-23	ACWV	ETF	71.56	71.56	71.33	71.52	100000.0
2015-02-23	ACWX	ETF	45.05	45.06	44.92	44.99	124204.0
2015-02-23	ADRE	ETF	36.5	36.5	36.2125	36.31	6891.0
2015-02-23	AFK	ETF	25.85	26.13	25.67	25.9	53865.0
2015-02-23	AGG	ETF	110.69	110.81	110.66	110.75	1688200.0
2015-02-23	AGQ	ETF	40.86	41.84	40.12	40.44	198600.0
2015-02-23	AGZ	ETF	113.76	114.4199	113.6514	113.9905	37873.0
2015-02-23	AGZD	ETF	24.58	24.59	24.55	24.55	8000.0
2015-02-23	AIA	ETF	49.2	49.2	48.89	49.0	22515.0
2015-02-23	AIQ	ETF	25.08	25.139	24.58	24.59	9535.0
2015-02-23	AIRR	ETF	17.99	18.076	17.952	18.06	9900.0
2015-02-23	AIVI	ETF	45.45	45.45	45.13	45.26	36800.0
2015-02-23	AMJ	ETF	45.54	45.97	45.272	45.43	684185.0
2015-02-23	AMLP	ETF	85.7	86.0	85.0	85.3	1024660.0
2015-02-23	AMZA	ETF	222.8	223.1	221.9	223.0	510.0
2015-02-23	ANGL	ETF	27.36	27.56	27.2	27.38	28500.0
2015-02-23	AOA	ETF	47.86	47.86	47.62	47.76	78700.0
2015-02-23	AOK	ETF	32.76	32.89	32.76	32.86	35621.0
2015-02-23	AOM	ETF	35.6	35.6569	35.54	35.58	160967.0
2015-02-23	AOR	ETF	41.01	41.01	40.85	40.99	31210.0
2015-02-23	ARGT	ETF	19.92	20.06	19.9	19.95	148300.0
2015-02-23	ARKG	ETF	23.72	23.72	23.35	23.41	10100.0
2015-02-23	ARKK	ETF	21.55	21.577	21.48	21.48	1600.0
2015-02-23	ARKQ	ETF	20.21	20.21	20.21	20.21	100.0
2015-02-23	ARKW	ETF	22.36	22.36	22.24	22.26	1400.0
2015-02-23	ASEA	ETF	15.73	15.73	15.64	15.64	5600.0
2015-02-23	ASHR	ETF	36.09	36.09	35.85	36.0	646700.0
2015-02-23	ASHS	ETF	38.68	39.02	38.55	38.76	114300.0
2015-02-23	ATMP	ETF	30.39	30.52	30.33	30.49	33200.0
2015-02-23	AVIV	ETF	36.2	36.72	36.15	36.72	118222.0
2015-02-23	AWAY	ETF	31.02	31.66	30.8246	30.99	2777389.0
2015-02-23	BAB	ETF	29.7	30.02	29.7	29.92	167220.0
2015-02-23	BAL	ETF	43.59	43.869	43.45	43.69	12992.0
2015-02-23	BALT	ETF	1.7	1.7	1.61	1.61	266201.0
2015-02-23	BAR	ETF	2.751	2.82	2.751	2.7852	14120.0
2015-02-23	BBC	ETF	30.81	31.69	30.81	31.14	105477.0
2015-02-23	BBH	ETF	127.46	129.21	127.42	128.03	92300.0
2015-02-23	BBP	ETF	30.37	30.37	29.67	29.89	31200.0
2015-02-23	BCM	ETF	31.531	31.659	31.37	31.38	5577.0
2015-02-23	BFOR	ETF	8.19	8.19	8.1425	8.175	82400.0
2015-02-23	BIB	ETF	77.045	78.71	76.45	77.13	795220.0

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

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