PREVIEW / etf_daily / 2015-10-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-23.parquet
  size:    49 KB
  rows:    1,234

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-10-23	SPY	ETF	207.25	207.95	206.3	207.51	144442300.0
2015-10-23	QQQ	ETF	112.66	113.24	112.07	112.78	53170910.0
2015-10-23	IWM	ETF	115.65	116.05	114.73	115.85	40172500.0
2015-10-23	DIA	ETF	176.0	176.64	175.37	176.37	7642900.0
2015-10-23	GLD	ETF	111.81	111.84	110.96	111.5	4868400.0
2015-10-23	TLT	ETF	123.1	123.46	122.85	123.2	7058200.0
2015-10-23	AADR	ETF	38.68	38.7	38.68	38.7	2200.0
2015-10-23	AAXJ	ETF	58.77	58.94	58.5	58.77	507500.0
2015-10-23	ACTX	ETF	8.8501	9.4401	7.9651	9.4401	575.0
2015-10-23	ACWI	ETF	58.54	58.62	58.19	58.52	1442700.0
2015-10-23	ACWV	ETF	71.26	71.26	70.78	71.08	474700.0
2015-10-23	ACWX	ETF	42.41	42.54	42.3	42.43	874773.0
2015-10-23	ADRE	ETF	30.86	30.93	30.7844	30.93	7081.0
2015-10-23	AFK	ETF	20.95	21.09	20.88	21.04	14471.0
2015-10-23	AFTY	ETF	16.38	16.58	16.38	16.55	19200.0
2015-10-23	AGG	ETF	109.79	109.79	109.69	109.75	2237400.0
2015-10-23	AGGY	ETF	50.08	50.19	50.07	50.07	6100.0
2015-10-23	AGQ	ETF	36.01	36.16	35.45	36.07	93600.0
2015-10-23	AGZ	ETF	114.0	114.1	113.3101	113.9	351069.0
2015-10-23	AGZD	ETF	24.035	24.115	23.97	24.045	58600.0
2015-10-23	AIA	ETF	46.96	47.12	46.77	47.02	68632.0
2015-10-23	AIQ	ETF	9.31	9.42	9.275	9.36	22450.0
2015-10-23	AIRR	ETF	16.64	16.64	16.62	16.64	2200.0
2015-10-23	AIVI	ETF	41.25	41.39	41.17	41.33	10900.0
2015-10-23	AMJ	ETF	32.62	32.82	32.08	32.27	3409700.0
2015-10-23	AMLP	ETF	66.85	67.5	65.55	65.9	949160.0
2015-10-23	AMZA	ETF	150.58	150.58	137.4	139.2	1100.0
2015-10-23	ANGL	ETF	26.2	26.22	26.16	26.2	10600.0
2015-10-23	AOA	ETF	46.34	46.45	46.22	46.38	40700.0
2015-10-23	AOK	ETF	32.39	32.39	32.24	32.31	30791.0
2015-10-23	AOM	ETF	34.86	34.9364	34.817	34.88	80107.0
2015-10-23	AOR	ETF	39.96	39.9813	39.829	39.95	213391.0
2015-10-23	ARGT	ETF	17.59	18.02	17.55	17.99	33900.0
2015-10-23	ARKG	ETF	19.33	19.476	19.3	19.476	900.0
2015-10-23	ARKK	ETF	19.81	19.81	19.81	19.81	100.0
2015-10-23	ARKQ	ETF	18.39	18.45	18.39	18.45	1200.0
2015-10-23	ARKW	ETF	22.455	22.6	22.455	22.6	4000.0
2015-10-23	ASEA	ETF	13.58	13.64	13.58	13.62	8500.0
2015-10-23	ASHR	ETF	36.9	37.05	36.59	36.9	2962700.0
2015-10-23	ASHS	ETF	44.8	44.8	44.1	44.38	134300.0
2015-10-23	ASHX	ETF	26.04	26.04	25.78	25.78	3340.0
2015-10-23	ATMP	ETF	22.48	22.48	21.96	22.2	37200.0
2015-10-23	AWAY	ETF	30.66	30.75	29.88	30.25	1073669.0
2015-10-23	BAB	ETF	29.26	29.26	29.15	29.16	67160.0
2015-10-23	BAL	ETF	41.91	41.91	41.5844	41.8486	2623.0
2015-10-23	BBC	ETF	26.35	27.3199	26.35	27.06	5983.0
2015-10-23	BBH	ETF	119.04	120.94	118.34	120.94	148000.0
2015-10-23	BBP	ETF	28.97	29.62	28.97	29.34	9500.0
2015-10-23	BCHP	ETF	18.6	18.66	18.59	18.64	644.0
2015-10-23	BCM	ETF	26.7557	26.7557	26.7557	26.7557	389.0

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

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