PREVIEW / etf_daily / 2015-09-24

all etf daily files

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

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-24	SPY	ETF	192.15	193.45	190.56	192.9	159378800.0
2015-09-24	QQQ	ETF	103.17	104.19	102.27	103.8	38284331.0
2015-09-24	IWM	ETF	112.79	113.42	111.87	113.23	39810300.0
2015-09-24	DIA	ETF	161.12	162.24	159.93	161.87	8451800.0
2015-09-24	GLD	ETF	109.67	110.82	109.63	110.49	11024300.0
2015-09-24	TLT	ETF	123.17	123.68	122.49	122.6	9605800.0
2015-09-24	AAXJ	ETF	52.03	52.42	51.64	52.27	2721600.0
2015-09-24	ACTX	ETF	4.72	8.2601	4.13	7.0801	4813.0
2015-09-24	ACWI	ETF	53.65	54.12	53.34	53.99	1547600.0
2015-09-24	ACWV	ETF	66.39	66.95	66.34	66.95	76600.0
2015-09-24	ACWX	ETF	38.56	38.9299	38.3601	38.84	1335815.0
2015-09-24	ADRE	ETF	27.33	27.776	27.13	27.76	7259.0
2015-09-24	AFK	ETF	19.69	19.97	19.5901	19.97	119302.0
2015-09-24	AFTY	ETF	14.74	14.99	14.74	14.95	55600.0
2015-09-24	AGG	ETF	109.49	109.51	109.24	109.3	2700000.0
2015-09-24	AGQ	ETF	32.2	33.41	32.16	33.11	196600.0
2015-09-24	AGZ	ETF	113.92	113.99	113.542	113.66	48334.0
2015-09-24	AGZD	ETF	23.99	24.03	23.99	24.03	1200.0
2015-09-24	AIA	ETF	41.24	41.6	41.06	41.53	63851.0
2015-09-24	AIQ	ETF	9.3	10.92	9.0	10.77	324910.0
2015-09-24	AIRR	ETF	15.49	15.6	15.39	15.57	30500.0
2015-09-24	AIVI	ETF	37.76	38.01	37.59	37.94	65500.0
2015-09-24	ALTY	ETF	14.24	14.24	14.232	14.232	1100.0
2015-09-24	AMJ	ETF	31.5	31.68	30.715	31.49	3592713.0
2015-09-24	AMLP	ETF	65.65	66.0	63.25	65.15	2570900.0
2015-09-24	AMZA	ETF	142.7	144.1	136.61	143.5	4680.0
2015-09-24	ANGL	ETF	26.46	26.46	26.14	26.19	15400.0
2015-09-24	AOA	ETF	43.45	43.7	43.31	43.6	33500.0
2015-09-24	AOK	ETF	31.43	31.54	31.41	31.5313	39433.0
2015-09-24	AOM	ETF	33.81	33.8999	33.7	33.87	76466.0
2015-09-24	AOR	ETF	38.16	38.2	37.95	38.2	73150.0
2015-09-24	ARGT	ETF	16.37	16.37	16.02	16.23	12700.0
2015-09-24	ARKG	ETF	20.41	20.53	20.36	20.51	8000.0
2015-09-24	ARKK	ETF	19.82	19.82	19.61	19.61	400.0
2015-09-24	ARKQ	ETF	17.81	17.81	17.81	17.81	100.0
2015-09-24	ARKW	ETF	21.47	21.67	21.47	21.64	2000.0
2015-09-24	ASEA	ETF	11.88	12.09	11.86	12.08	51800.0
2015-09-24	ASHR	ETF	32.28	32.72	32.2	32.7	1528600.0
2015-09-24	ASHS	ETF	36.98	37.38	36.39	37.22	58500.0
2015-09-24	ATMP	ETF	21.51	21.69	21.03	21.62	62800.0
2015-09-24	AWAY	ETF	26.78	27.5	26.44	27.28	1123199.0
2015-09-24	BAB	ETF	29.03	29.05	28.9	28.9	40521.0
2015-09-24	BAL	ETF	39.8	40.3	39.8	39.89	11245.0
2015-09-24	BBC	ETF	31.68	31.723	30.83	31.68	5056.0
2015-09-24	BBH	ETF	122.81	123.1	119.38	121.1	162900.0
2015-09-24	BBP	ETF	30.6	30.74	30.15	30.7	6300.0
2015-09-24	BCM	ETF	26.718	26.82	26.63	26.782	9347.0
2015-09-24	BFOR	ETF	7.565	7.565	7.47	7.55	123600.0
2015-09-24	BIB	ETF	70.0	71.0	65.9101	68.77	1357373.0
2015-09-24	BICK	ETF	18.27	18.41	18.252	18.41	2699.0

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

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