PREVIEW / etf_daily / 2015-12-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-21.parquet
  size:    49 KB
  rows:    1,228

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-12-21	SPY	ETF	201.41	201.88	200.09	201.67	99094300.0
2015-12-21	QQQ	ETF	110.87	111.07	110.05	111.05	26432807.0
2015-12-21	IWM	ETF	112.17	112.63	111.5	112.32	26479300.0
2015-12-21	DIA	ETF	172.28	172.56	170.91	172.25	6466700.0
2015-12-21	GLD	ETF	102.95	103.52	102.83	103.15	6378900.0
2015-12-21	TLT	ETF	123.43	123.78	122.92	123.2	7494900.0
2015-12-21	AADR	ETF	37.72	37.72	37.72	37.72	1000.0
2015-12-21	AAXJ	ETF	53.97	54.0	53.34	53.67	2354900.0
2015-12-21	ACTX	ETF	8.8501	8.8501	7.6701	8.2601	1087.0
2015-12-21	ACWF	ETF	23.05	23.0575	22.9799	23.01	5636.0
2015-12-21	ACWI	ETF	55.32	55.5	54.94	55.31	2851800.0
2015-12-21	ACWV	ETF	68.56	68.64	68.18	68.61	375400.0
2015-12-21	ACWX	ETF	39.5	39.57	39.12	39.34	3100141.0
2015-12-21	ADRE	ETF	29.17	29.44	29.126	29.2214	13588.0
2015-12-21	AFK	ETF	17.37	17.68	17.37	17.54	86052.0
2015-12-21	AFTY	ETF	14.87	14.98	14.8	14.951	85500.0
2015-12-21	AGG	ETF	108.49	108.54	108.24	108.28	3233500.0
2015-12-21	AGQ	ETF	28.77	29.11	28.64	28.9	112400.0
2015-12-21	AGZ	ETF	113.45	113.56	112.8336	113.31	37289.0
2015-12-21	AGZD	ETF	23.955	23.985	23.845	23.85	53400.0
2015-12-21	AIA	ETF	42.49	42.591	42.2845	42.49	28603.0
2015-12-21	AIQ	ETF	9.29	9.68	8.8	9.04	56696.0
2015-12-21	AIRR	ETF	16.35	16.475	16.28	16.29	67400.0
2015-12-21	AIVI	ETF	37.77	37.79	37.32	37.51	91900.0
2015-12-21	ALTY	ETF	13.763	13.763	13.763	13.763	100.0
2015-12-21	AMJ	ETF	25.3	26.38	25.12	26.37	7947312.0
2015-12-21	AMLP	ETF	51.9	54.45	51.5	54.45	5199100.0
2015-12-21	AMUB	ETF	16.22	16.22	16.19	16.19	300.0
2015-12-21	AMZA	ETF	92.2	98.1	91.68	97.8	5120.0
2015-12-21	ANGL	ETF	24.35	24.37	24.18	24.32	82600.0
2015-12-21	AOA	ETF	45.02	45.02	44.6	44.78	470300.0
2015-12-21	AOK	ETF	31.85	31.85	31.611	31.66	95947.0
2015-12-21	AOM	ETF	34.35	34.35	34.07	34.14	669271.0
2015-12-21	AOR	ETF	38.89	38.94	38.72	38.82	737235.0
2015-12-21	ARGT	ETF	17.84	17.84	17.54	17.56	17500.0
2015-12-21	ARKG	ETF	20.13	20.42	20.13	20.42	1300.0
2015-12-21	ARKK	ETF	20.93	20.93	20.87	20.87	500.0
2015-12-21	ARKQ	ETF	19.31	19.31	19.31	19.31	100.0
2015-12-21	ARKW	ETF	23.44	23.44	23.38	23.38	800.0
2015-12-21	ASEA	ETF	12.48	12.48	12.42	12.43	1900.0
2015-12-21	ASET	ETF	24.19	24.19	24.19	24.19	500.0
2015-12-21	ASHR	ETF	29.4	29.43	29.24	29.39	2498600.0
2015-12-21	ASHS	ETF	43.06	44.28	43.06	43.21	136900.0
2015-12-21	ASHX	ETF	26.4068	26.4068	26.3842	26.3842	200.0
2015-12-21	ATMP	ETF	16.66	17.11	16.27	17.11	409200.0
2015-12-21	BAB	ETF	29.12	29.15	29.012	29.06	218727.0
2015-12-21	BAL	ETF	42.47	42.47	41.96	41.9601	4516.0
2015-12-21	BBC	ETF	29.294	29.3888	29.05	29.15	3622.0
2015-12-21	BBH	ETF	124.04	124.24	123.06	124.08	35500.0
2015-12-21	BBP	ETF	30.13	30.416	30.13	30.395	5100.0

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

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