PREVIEW / etf_daily / 2019-07-08

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-08.parquet
  size:    69 KB
  rows:    1,822

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
2019-07-08	SPY	ETF	297.01	298.26	296.22	296.82	45841800.0
2019-07-08	QQQ	ETF	189.86	189.87	188.93	189.71	17598826.0
2019-07-08	IWM	ETF	156.21	156.48	154.89	155.19	9735700.0
2019-07-08	DIA	ETF	267.9	268.43	267.47	268.06	1423400.0
2019-07-08	GLD	ETF	132.18	132.34	131.28	131.29	8028900.0
2019-07-08	TLT	ETF	133.05	133.22	132.61	132.61	6490000.0
2019-07-08	AAAU	ETF	14.0	14.01	13.9	13.9	39300.0
2019-07-08	AADR	ETF	50.25	50.46	50.17	50.33	13200.0
2019-07-08	AAXJ	ETF	69.13	69.24	68.96	69.13	3111100.0
2019-07-08	ACES	ETF	30.22	30.274	30.13	30.165	8600.0
2019-07-08	ACSI	ETF	34.2274	34.31	34.19	34.195	59446.0
2019-07-08	ACTX	ETF	28.3203	32.4503	23.0102	32.4503	784.0
2019-07-08	ACWF	ETF	29.42	29.49	29.35	29.3865	29040.0
2019-07-08	ACWI	ETF	74.23	74.34	74.13	74.2	2741600.0
2019-07-08	ACWV	ETF	92.88	92.95	92.69	92.88	365100.0
2019-07-08	ACWX	ETF	46.77	46.83	46.725	46.74	1056233.0
2019-07-08	ADRE	ETF	40.17	40.17	39.9	39.915	3392.0
2019-07-08	AFIF	ETF	9.89	9.8969	9.88	9.88	6404.0
2019-07-08	AFK	ETF	21.89	21.98	21.77	21.85	6298.0
2019-07-08	AFTY	ETF	17.5	17.5	17.42	17.42	12000.0
2019-07-08	AGG	ETF	111.23	111.26	111.03	111.03	3041400.0
2019-07-08	AGGY	ETF	51.36	51.36	51.26	51.285	87500.0
2019-07-08	AGNG	ETF	21.48	21.596	21.275	21.38	100400.0
2019-07-08	AGQ	ETF	23.81	23.88	23.61	23.63	236200.0
2019-07-08	AGZ	ETF	114.88	114.9371	114.7708	114.83	15460.0
2019-07-08	AGZD	ETF	23.915	23.945	23.9	23.905	16200.0
2019-07-08	AIA	ETF	60.3	60.38	60.19	60.22	44953.0
2019-07-08	AIEQ	ETF	26.76	26.76	26.6	26.63	19000.0
2019-07-08	AIQ	ETF	16.58	16.58	16.4	16.49	10360.0
2019-07-08	AIRR	ETF	26.37	26.47	26.23	26.275	8800.0
2019-07-08	AIVI	ETF	41.12	41.13	41.11	41.11	1000.0
2019-07-08	ALTY	ETF	15.0	15.005	14.95	14.96	7900.0
2019-07-08	AMJ	ETF	25.61	25.61	25.3381	25.38	1486279.0
2019-07-08	AMLP	ETF	50.15	50.35	49.8	50.05	3085020.0
2019-07-08	AMOM	ETF	26.265	26.265	26.265	26.265	200.0
2019-07-08	AMUB	ETF	15.9929	15.9929	15.9929	15.9929	0.0
2019-07-08	AMZA	ETF	56.9	57.3	56.52	56.7	36420.0
2019-07-08	ANGL	ETF	29.24	29.26	29.09	29.12	1049800.0
2019-07-08	AOA	ETF	54.93	54.97	54.8	54.91	41500.0
2019-07-08	AOK	ETF	35.3	35.3	35.22	35.27	45795.0
2019-07-08	AOM	ETF	38.88	38.91	38.72	38.83	105292.0
2019-07-08	AOR	ETF	45.85	45.85	45.72	45.78	64207.0
2019-07-08	ARGT	ETF	32.82	33.0	32.66	32.91	48500.0
2019-07-08	ARKF	ETF	22.81	22.81	22.71	22.765	16400.0
2019-07-08	ARKG	ETF	34.31	34.31	33.64	33.92	261000.0
2019-07-08	ARKK	ETF	47.58	47.597	47.1	47.35	296300.0
2019-07-08	ARKQ	ETF	33.17	33.24	33.01	33.17	12800.0
2019-07-08	ARKW	ETF	52.47	52.484	52.122	52.35	35600.0
2019-07-08	ASEA	ETF	16.7	16.92	16.47	16.67	2600.0
2019-07-08	ASET	ETF	29.79	29.7994	29.76	29.79	1390.0

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

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