PREVIEW / etf_daily / 2015-09-22

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-22.parquet
  size:    48 KB
  rows:    1,205

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-09-22	SPY	ETF	193.88	194.46	192.56	193.91	153890900.0
2015-09-22	QQQ	ETF	104.06	104.4225	103.13	104.1	47359654.0
2015-09-22	IWM	ETF	114.45	114.73	113.05	113.76	35786900.0
2015-09-22	DIA	ETF	162.62	163.36	161.98	163.0	8979600.0
2015-09-22	GLD	ETF	107.58	107.96	107.44	107.79	5483300.0
2015-09-22	TLT	ETF	121.44	122.39	121.14	121.78	9968200.0
2015-09-22	AAXJ	ETF	53.24	53.3	52.92	53.24	956700.0
2015-09-22	ACTX	ETF	4.72	4.72	4.13	4.13	555.0
2015-09-22	ACWI	ETF	54.46	54.59	54.06	54.43	2329800.0
2015-09-22	ACWV	ETF	66.95	67.07	66.6	67.02	270900.0
2015-09-22	ACWX	ETF	39.25	39.33	38.97	39.25	392741.0
2015-09-22	ADRE	ETF	28.27	28.32	28.045	28.14	15054.0
2015-09-22	AFK	ETF	20.11	20.2099	19.8	19.86	29866.0
2015-09-22	AFTY	ETF	15.08	15.19	15.01	15.01	109300.0
2015-09-22	AGG	ETF	109.19	109.39	109.12	109.25	2044800.0
2015-09-22	AGGY	ETF	49.73	49.82	49.64	49.75	2200.0
2015-09-22	AGQ	ETF	31.9	31.91	31.46	31.74	151700.0
2015-09-22	AGZ	ETF	113.73	113.84	113.31	113.77	18230.0
2015-09-22	AGZD	ETF	24.055	24.055	23.995	23.995	1400.0
2015-09-22	AIA	ETF	42.2	42.26	41.9505	42.15	862998.0
2015-09-22	AIQ	ETF	11.55	11.55	10.63	10.83	70178.0
2015-09-22	AIRR	ETF	16.0	16.01	15.84	15.88	28800.0
2015-09-22	AIVI	ETF	38.22	38.26	37.97	38.26	55200.0
2015-09-22	AMJ	ETF	33.32	33.6	32.93	33.05	1163595.0
2015-09-22	AMLP	ETF	69.0	69.45	68.0	68.5	706900.0
2015-09-22	AMZA	ETF	161.3	161.4	152.2	152.6	970.0
2015-09-22	ANGL	ETF	26.28	26.35	26.18	26.35	57900.0
2015-09-22	AOA	ETF	44.17	44.17	43.63	43.95	43900.0
2015-09-22	AOK	ETF	31.58	31.61	31.477	31.52	20980.0
2015-09-22	AOM	ETF	33.99	33.99	33.79	33.86	132693.0
2015-09-22	AOR	ETF	38.3	38.42	38.17	38.34	141473.0
2015-09-22	ARGT	ETF	16.9	16.9	16.67	16.67	4600.0
2015-09-22	ARKG	ETF	20.736	20.736	20.736	20.736	100.0
2015-09-22	ARKK	ETF	19.88	19.88	19.88	19.88	200.0
2015-09-22	ARKQ	ETF	18.12	18.12	18.12	18.12	100.0
2015-09-22	ARKW	ETF	21.875	21.875	21.875	21.875	400.0
2015-09-22	ASEA	ETF	12.47	12.47	12.34	12.34	9700.0
2015-09-22	ASHR	ETF	32.49	35.29	32.28	32.59	1822200.0
2015-09-22	ASHS	ETF	36.19	36.58	35.77	36.34	68700.0
2015-09-22	ATMP	ETF	22.77	22.86	22.47	22.6	58100.0
2015-09-22	AWAY	ETF	27.68	27.85	26.92	27.12	1292952.0
2015-09-22	BAB	ETF	29.03	29.03	28.8301	28.89	66491.0
2015-09-22	BAL	ETF	40.04	40.04	39.75	39.75	4122.0
2015-09-22	BBC	ETF	32.27	32.75	31.47	32.16	24030.0
2015-09-22	BBH	ETF	123.96	124.93	122.31	124.72	242300.0
2015-09-22	BBP	ETF	31.03	31.364	30.464	31.07	28400.0
2015-09-22	BCHP	ETF	17.336	17.4199	17.31	17.4199	1600.0
2015-09-22	BCM	ETF	26.733	26.7899	26.733	26.769	5011.0
2015-09-22	BFOR	ETF	7.64	7.64	7.565	7.605	113200.0
2015-09-22	BIB	ETF	72.19	73.586	69.6901	72.45	1310614.0

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

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