PREVIEW / etf_daily / 2020-02-14

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-14.parquet
  size:    74 KB
  rows:    1,939

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
2020-02-14	SPY	ETF	337.51	337.73	336.2	337.6	64582200.0
2020-02-14	QQQ	ETF	234.28	234.86	233.5501	234.64	23438530.0
2020-02-14	IWM	ETF	168.7	168.78	167.34	167.9	16006200.0
2020-02-14	DIA	ETF	294.97	295.13	293.4	294.54	1861700.0
2020-02-14	GLD	ETF	148.74	149.13	148.63	149.0	5345400.0
2020-02-14	TLT	ETF	144.76	145.08	144.45	144.55	7137400.0
2020-02-14	AAAU	ETF	15.78	15.81	15.74	15.79	52100.0
2020-02-14	AADR	ETF	56.72	56.81	56.28	56.47	6600.0
2020-02-14	AAXJ	ETF	73.4	73.45	72.87	73.11	367000.0
2020-02-14	ABEQ	ETF	24.939	24.962	24.939	24.962	400.0
2020-02-14	ACES	ETF	40.48	40.65	40.302	40.38	33800.0
2020-02-14	ACIO	ETF	25.3	25.32	25.24	25.314	42500.0
2020-02-14	ACSI	ETF	37.536	37.5399	37.3782	37.4479	1753.0
2020-02-14	ACTX	ETF	8.3102	8.3781	7.3751	7.9798	381.0
2020-02-14	ACWF	ETF	31.78	31.78	31.62	31.704	16712.0
2020-02-14	ACWI	ETF	81.51	81.52	81.15	81.44	1032800.0
2020-02-14	ACWV	ETF	99.25	99.38	99.09	99.38	136200.0
2020-02-14	ACWX	ETF	49.01	49.01	48.77	48.91	688496.0
2020-02-14	ADME	ETF	31.726	31.726	31.663	31.72	10000.0
2020-02-14	ADRE	ETF	43.93	43.93	43.6	43.63	6676.0
2020-02-14	AESR	ETF	10.512	10.59	10.512	10.59	26200.0
2020-02-14	AFIF	ETF	9.73	9.77	9.73	9.745	33129.0
2020-02-14	AFK	ETF	19.7147	19.81	19.7015	19.81	8703.0
2020-02-14	AFTY	ETF	16.345	16.345	16.32	16.334	1000.0
2020-02-14	AGG	ETF	114.35	114.38	114.27	114.29	4004900.0
2020-02-14	AGGY	ETF	53.27	53.31	53.224	53.27	406500.0
2020-02-14	AGNG	ETF	24.67	24.86	24.55	24.71	3100.0
2020-02-14	AGQ	ETF	31.06	31.06	30.78	30.82	276200.0
2020-02-14	AGZ	ETF	117.03	117.06	116.96	116.96	87406.0
2020-02-14	AGZD	ETF	24.045	24.07	23.99	24.0	8800.0
2020-02-14	AIA	ETF	66.92	66.92	66.47	66.66	17958.0
2020-02-14	AIEQ	ETF	30.09	30.18	30.05	30.07	36300.0
2020-02-14	AIQ	ETF	19.84	19.842	19.7105	19.735	9931.0
2020-02-14	AIRR	ETF	29.48	29.499	29.226	29.35	9300.0
2020-02-14	AIVI	ETF	41.74	41.74	41.6	41.69	4300.0
2020-02-14	ALTY	ETF	15.01	15.02	15.0	15.015	6900.0
2020-02-14	AMJ	ETF	20.68	20.7092	20.48	20.61	1232925.0
2020-02-14	AMLP	ETF	39.4	39.45	38.95	39.25	2806660.0
2020-02-14	AMOM	ETF	27.84	27.894	27.84	27.894	300.0
2020-02-14	AMUB	ETF	12.9246	12.9628	12.91	12.9628	2326.0
2020-02-14	AMZA	ETF	40.4	40.75	40.1	40.1	53180.0
2020-02-14	ANGL	ETF	30.5	30.53	30.44	30.53	313700.0
2020-02-14	AOA	ETF	59.2	59.29	59.07	59.22	46100.0
2020-02-14	AOK	ETF	36.94	36.94	36.85	36.9	57895.0
2020-02-14	AOM	ETF	40.88	40.9476	40.8601	40.94	86790.0
2020-02-14	AOR	ETF	48.76	48.83	48.7	48.8	103520.0
2020-02-14	ARGT	ETF	25.86	26.06	25.83	26.06	5400.0
2020-02-14	ARKF	ETF	27.03	27.11	26.95	27.06	77200.0
2020-02-14	ARKG	ETF	36.83	37.12	36.44	36.86	171600.0
2020-02-14	ARKK	ETF	58.9	59.14	58.57	58.69	338800.0

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

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