PREVIEW / etf_daily / 2019-07-17

all etf daily files

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

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-17	SPY	ETF	299.75	299.93	297.74	297.74	36036300.0
2019-07-17	QQQ	ETF	193.2	193.49	192.18	192.2	16765069.0
2019-07-17	IWM	ETF	155.24	155.34	153.73	154.13	14155100.0
2019-07-17	DIA	ETF	273.34	273.45	272.18	272.28	1550800.0
2019-07-17	GLD	ETF	133.0	134.6	132.89	134.58	11288300.0
2019-07-17	TLT	ETF	131.06	132.02	131.05	131.99	9662200.0
2019-07-17	AAAU	ETF	14.08	14.24	14.08	14.23	49100.0
2019-07-17	AADR	ETF	51.27	51.34	51.1	51.23	5600.0
2019-07-17	AAXJ	ETF	69.64	69.8	69.42	69.5	703100.0
2019-07-17	ACES	ETF	30.51	30.559	30.401	30.42	7100.0
2019-07-17	ACIO	ETF	25.13	25.13	24.94	24.981	106300.0
2019-07-17	ACSI	ETF	34.586	34.586	34.3761	34.3761	1636.0
2019-07-17	ACTX	ETF	29.5003	29.5003	27.1402	27.1402	205.0
2019-07-17	ACWF	ETF	29.651	29.651	29.5513	29.5513	1731.0
2019-07-17	ACWI	ETF	74.65	74.72	74.3	74.3	1337900.0
2019-07-17	ACWV	ETF	93.39	93.47	93.19	93.19	959800.0
2019-07-17	ACWX	ETF	46.85	46.88	46.7	46.7	702229.0
2019-07-17	ADRE	ETF	40.57	40.65	40.57	40.58	3013.0
2019-07-17	AFIF	ETF	9.8904	9.94	9.8904	9.92	1965.0
2019-07-17	AFK	ETF	21.89	22.03	21.825	21.825	12276.0
2019-07-17	AFTY	ETF	17.2	17.31	17.2	17.297	1700.0
2019-07-17	AGG	ETF	110.93	111.14	110.91	111.12	2985600.0
2019-07-17	AGGY	ETF	51.14	51.285	51.14	51.28	92600.0
2019-07-17	AGNG	ETF	21.326	21.41	21.326	21.41	2400.0
2019-07-17	AGQ	ETF	26.1	26.84	26.03	26.8	636700.0
2019-07-17	AGZ	ETF	114.79	114.8679	114.731	114.857	13736.0
2019-07-17	AGZD	ETF	23.9	23.92	23.9	23.915	11000.0
2019-07-17	AIA	ETF	61.09	61.1	60.84	60.84	15172.0
2019-07-17	AIEQ	ETF	26.75	26.9	26.75	26.79	14900.0
2019-07-17	AIQ	ETF	16.72	16.839	16.72	16.79	9806.0
2019-07-17	AIRR	ETF	26.22	26.22	26.007	26.01	3200.0
2019-07-17	AIVI	ETF	40.87	40.92	40.82	40.82	2400.0
2019-07-17	ALTY	ETF	15.03	15.06	15.0	15.015	5400.0
2019-07-17	AMJ	ETF	25.72	25.79	25.5452	25.71	657775.0
2019-07-17	AMLP	ETF	50.5	50.65	50.2	50.35	1587560.0
2019-07-17	AMOM	ETF	26.57	26.57	26.442	26.442	200.0
2019-07-17	AMUB	ETF	16.096	16.096	16.096	16.096	0.0
2019-07-17	AMZA	ETF	57.7	57.8	57.0	57.4	55240.0
2019-07-17	ANGL	ETF	29.22	29.29	29.17	29.24	377900.0
2019-07-17	AOA	ETF	55.06	55.08	54.85	54.86	30400.0
2019-07-17	AOK	ETF	35.3	35.3	35.2	35.3	55927.0
2019-07-17	AOM	ETF	38.85	38.88	38.8	38.85	120191.0
2019-07-17	AOR	ETF	45.83	45.88	45.715	45.75	59140.0
2019-07-17	ARGT	ETF	32.91	33.23	32.85	32.98	67900.0
2019-07-17	ARKF	ETF	23.14	23.259	23.11	23.11	10300.0
2019-07-17	ARKG	ETF	33.51	33.71	32.93	33.55	147200.0
2019-07-17	ARKK	ETF	48.38	48.91	48.18	48.6	131700.0
2019-07-17	ARKQ	ETF	34.21	34.242	33.995	34.04	9700.0
2019-07-17	ARKW	ETF	54.11	54.521	54.11	54.13	40800.0
2019-07-17	ASEA	ETF	16.93	16.93	16.79	16.79	1900.0

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

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