PREVIEW / etf_daily / 2021-03-05

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-05.parquet
  size:    87 KB
  rows:    2,278

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
2021-03-05	SPY	ETF	380.46	384.76	372.64	383.63	152039600.0
2021-03-05	QQQ	ETF	306.795	309.609	297.45	308.68	121523726.0
2021-03-05	IWM	ETF	216.89	218.15	207.21	217.71	53204300.0
2021-03-05	DIA	ETF	312.5	316.05	307.9	315.24	7016100.0
2021-03-05	GLD	ETF	159.66	159.82	158.55	159.14	12821600.0
2021-03-05	TLT	ETF	138.17	139.34	137.99	138.91	20598000.0
2021-03-05	AAA	ETF	25.1	25.1	25.08	25.09	3736.0
2021-03-05	AAAU	ETF	16.95	16.97	16.84	16.9	304100.0
2021-03-05	AADR	ETF	61.08	61.74	59.55	61.74	6200.0
2021-03-05	AAXJ	ETF	94.65	94.65	92.54	94.46	597100.0
2021-03-05	ABEQ	ETF	25.89	25.89	25.331	25.777	9100.0
2021-03-05	ACES	ETF	75.0	75.0	67.16	72.94	243800.0
2021-03-05	ACIO	ETF	26.86	27.39	26.86	27.38	16200.0
2021-03-05	ACSI	ETF	44.1999	44.707	43.3	44.707	1666.0
2021-03-05	ACTV	ETF	34.91	35.2798	34.42	35.2798	4357.0
2021-03-05	ACTX	ETF	4.85	4.85	3.5	3.76	2318.0
2021-03-05	ACVF	ETF	28.46	28.574	27.86	28.574	8000.0
2021-03-05	ACWF	ETF	34.725	35.12	34.1	35.08	9082.0
2021-03-05	ACWI	ETF	92.57	93.2	90.75	92.96	4522900.0
2021-03-05	ACWV	ETF	94.45	95.35	93.8	95.14	443200.0
2021-03-05	ACWX	ETF	54.73	54.84	53.87	54.77	2705204.0
2021-03-05	ADFI	ETF	9.63	9.69	9.63	9.67	6700.0
2021-03-05	ADME	ETF	35.04	35.37	34.705	35.37	49600.0
2021-03-05	ADRE	ETF	58.77	58.83	56.8223	58.83	16055.0
2021-03-05	AESR	ETF	11.85	12.19	11.77	12.16	102800.0
2021-03-05	AFIF	ETF	9.6772	9.73	9.6772	9.7	384674.0
2021-03-05	AFK	ETF	21.29	21.29	20.7	21.12	24428.0
2021-03-05	AFLG	ETF	22.77	22.958	22.4	22.958	4900.0
2021-03-05	AFMC	ETF	23.18	23.283	23.16	23.283	300.0
2021-03-05	AFSM	ETF	24.328	24.328	24.328	24.328	1000.0
2021-03-05	AFTY	ETF	23.6	23.6	23.25	23.405	16800.0
2021-03-05	AGG	ETF	114.17	114.32	114.05	114.28	8675700.0
2021-03-05	AGGY	ETF	51.5	51.64	51.5	51.615	105000.0
2021-03-05	AGNG	ETF	26.86	27.17	26.43	27.09	3600.0
2021-03-05	AGQ	ETF	44.6	44.6	42.59	43.89	1423900.0
2021-03-05	AGZ	ETF	118.05	118.14	118.0001	118.04	17857.0
2021-03-05	AGZD	ETF	23.655	23.79	23.575	23.63	69000.0
2021-03-05	AIA	ETF	94.87	95.15	92.931	95.06	220148.0
2021-03-05	AIEQ	ETF	37.13	37.4	35.22	37.3	72400.0
2021-03-05	AIQ	ETF	27.85	27.96	26.855	27.94	74763.0
2021-03-05	AIRR	ETF	38.87	39.585	37.899	39.54	69000.0
2021-03-05	AIVI	ETF	41.7	42.04	41.46	42.0	13600.0
2021-03-05	ALTL	ETF	38.17	39.0469	37.5411	39.0469	3871.0
2021-03-05	ALTY	ETF	12.49	12.49	12.11	12.335	20200.0
2021-03-05	AMJ	ETF	17.38	17.48	16.48	17.0	840653.0
2021-03-05	AMLP	ETF	31.86	32.04	30.47	31.68	4167100.0
2021-03-05	AMNA	ETF	29.9081	29.9081	29.9081	29.9081	0.0
2021-03-05	AMND	ETF	31.8845	31.8845	31.8845	31.8845	16.0
2021-03-05	AMOM	ETF	30.44	31.31	30.44	31.31	1500.0
2021-03-05	AMPS	ETF	9.92	10.01	9.72	9.93	1468176.0

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

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