PREVIEW / etf_daily / 2020-09-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-04.parquet
  size:    79 KB
  rows:    2,079

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-09-04	SPY	ETF	346.13	347.83	334.87	342.57	139156300.0
2020-09-04	QQQ	ETF	285.76	288.93	271.8	283.58	123958978.0
2020-09-04	IWM	ETF	155.71	155.89	149.29	152.8	30618800.0
2020-09-04	DIA	ETF	284.91	285.79	277.01	281.77	7145800.0
2020-09-04	GLD	ETF	180.95	182.1	180.05	181.64	11567900.0
2020-09-04	TLT	ETF	164.41	164.7	162.45	162.74	13780300.0
2020-09-04	AAAU	ETF	19.21	19.31	19.11	19.27	926600.0
2020-09-04	AADR	ETF	55.44	55.65	53.79	55.39	8700.0
2020-09-04	AAXJ	ETF	77.43	77.77	75.96	77.38	1675300.0
2020-09-04	ABEQ	ETF	23.679	24.13	23.679	24.121	11900.0
2020-09-04	ACES	ETF	50.42	51.0	47.32	50.06	130800.0
2020-09-04	ACIO	ETF	27.26	27.26	26.56	26.89	7100.0
2020-09-04	ACSI	ETF	38.049	38.049	38.049	38.049	241.0
2020-09-04	ACTX	ETF	2.242	3.54	2.242	2.36	2333.0
2020-09-04	ACWF	ETF	30.16	30.16	29.65	29.9376	2097.0
2020-09-04	ACWI	ETF	81.67	81.98	79.33	81.05	3416800.0
2020-09-04	ACWV	ETF	92.68	92.74	91.14	92.02	366500.0
2020-09-04	ACWX	ETF	46.71	46.83	45.75	46.55	1451928.0
2020-09-04	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-09-04	ADME	ETF	34.61	34.9	34.02	34.223	6600.0
2020-09-04	ADRE	ETF	47.17	47.17	45.79	46.99	8656.0
2020-09-04	AESR	ETF	10.888	11.088	10.87	11.088	4000.0
2020-09-04	AFIF	ETF	9.795	9.7991	9.795	9.795	876.0
2020-09-04	AFK	ETF	17.86	17.87	17.61	17.82	13104.0
2020-09-04	AFLG	ETF	20.77	20.77	20.29	20.496	400.0
2020-09-04	AFMC	ETF	17.73	17.999	17.73	17.999	100.0
2020-09-04	AFSM	ETF	17.61	17.983	17.61	17.983	100.0
2020-09-04	AFTY	ETF	19.52	19.58	19.4	19.49	6500.0
2020-09-04	AGG	ETF	118.41	118.52	118.08	118.1	5366800.0
2020-09-04	AGGY	ETF	54.29	54.29	53.96	54.02	122600.0
2020-09-04	AGNG	ETF	25.6	25.6	24.931	25.179	2400.0
2020-09-04	AGQ	ETF	56.44	57.83	54.79	57.4	2174400.0
2020-09-04	AGZ	ETF	121.3	121.3	120.95	120.95	47690.0
2020-09-04	AGZD	ETF	23.555	23.595	23.55	23.58	4000.0
2020-09-04	AIA	ETF	71.8	72.115	70.66	71.81	209317.0
2020-09-04	AIEQ	ETF	30.7	30.86	29.08	30.12	70400.0
2020-09-04	AIQ	ETF	23.54	23.75	22.665	23.28	76146.0
2020-09-04	AIRR	ETF	27.05	27.13	26.623	26.78	5100.0
2020-09-04	AIVI	ETF	36.88	36.99	36.42	36.93	10800.0
2020-09-04	ALTL	ETF	24.8235	25.14	24.8235	25.1109	3161.0
2020-09-04	ALTY	ETF	10.92	10.92	10.59	10.735	15400.0
2020-09-04	AMJ	ETF	12.16	12.31	11.83	12.19	1376651.0
2020-09-04	AMLP	ETF	22.55	22.73	21.83	22.43	2720900.0
2020-09-04	AMNA	ETF	23.7848	23.7848	23.7848	23.7848	0.0
2020-09-04	AMND	ETF	24.9415	24.9415	24.9415	24.9415	0.0
2020-09-04	AMOM	ETF	34.99	34.99	33.48	34.837	8300.0
2020-09-04	AMUB	ETF	7.52	7.64	7.47	7.64	15691.0
2020-09-04	AMZA	ETF	16.28	16.39	15.515	16.06	136300.0
2020-09-04	ANGL	ETF	30.65	30.65	30.08	30.39	934500.0
2020-09-04	AOA	ETF	59.02	59.02	57.89	58.78	95400.0

> showing 50 of 2,079 rows — these rows as CSV

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