PREVIEW / etf_daily / 2022-05-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-27.parquet
  size:    102 KB
  rows:    2,732

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
2022-05-27	SPY	ETF	407.91	415.38	407.7	415.26	84768700.0
2022-05-27	QQQ	ETF	302.54	309.25	302.42	309.1	66985596.0
2022-05-27	IWM	ETF	183.76	187.65	183.4	187.64	24952100.0
2022-05-27	DIA	ETF	327.05	332.13	326.82	332.07	2773100.0
2022-05-27	GLD	ETF	173.49	173.52	172.64	172.85	3847900.0
2022-05-27	TLT	ETF	119.36	119.74	118.74	119.08	11190400.0
2022-05-27	AAA	ETF	24.465	24.465	24.465	24.465	22.0
2022-05-27	AAAU	ETF	18.45	18.48	18.39	18.41	1406600.0
2022-05-27	AADR	ETF	56.99	57.22	56.99	57.13	1000.0
2022-05-27	AAXJ	ETF	70.25	70.57	69.97	70.57	2183500.0
2022-05-27	ABEQ	ETF	28.95	29.085	28.95	29.085	8200.0
2022-05-27	ACES	ETF	51.99	54.24	51.99	54.19	164100.0
2022-05-27	ACIO	ETF	29.64	30.19	29.64	30.17	102600.0
2022-05-27	ACSI	ETF	45.551	45.551	45.551	45.551	321.0
2022-05-27	ACT	ETF	24.37	24.79	24.33	24.43	155815.0
2022-05-27	ACTV	ETF	32.98	33.1202	32.77	33.1202	9354.0
2022-05-27	ACTX	ETF	0.721	0.75	0.7	0.75	12203.0
2022-05-27	ACVF	ETF	30.95	31.414	30.95	31.414	8900.0
2022-05-27	ACWF	ETF	34.49	34.8271	34.49	34.8271	4064.0
2022-05-27	ACWI	ETF	91.38	92.57	91.3	92.56	1606100.0
2022-05-27	ACWV	ETF	99.3	99.98	98.96	99.95	914300.0
2022-05-27	ACWX	ETF	49.37	49.64	49.29	49.63	3407921.0
2022-05-27	ADFI	ETF	8.79	8.795	8.79	8.795	7400.0
2022-05-27	ADIV	ETF	14.8	14.817	14.8	14.817	100.0
2022-05-27	ADME	ETF	37.0	37.915	37.0	37.89	25600.0
2022-05-27	ADRE	ETF	40.85	41.2	40.83	41.2	5034.0
2022-05-27	AESR	ETF	12.13	12.27	12.13	12.27	20900.0
2022-05-27	AFIF	ETF	9.02	9.03	9.01	9.01	23347.0
2022-05-27	AFK	ETF	19.05	19.23	19.0	19.05	4369.0
2022-05-27	AFLG	ETF	24.9	25.026	24.9	25.026	200.0
2022-05-27	AFMC	ETF	23.61	23.717	23.59	23.717	8200.0
2022-05-27	AFSM	ETF	24.34	24.443	24.34	24.443	100.0
2022-05-27	AFTY	ETF	16.77	16.82	16.76	16.82	3400.0
2022-05-27	AGG	ETF	104.09	104.31	104.02	104.13	5496300.0
2022-05-27	AGGY	ETF	46.1	46.16	46.01	46.06	144500.0
2022-05-27	AGNG	ETF	26.05	26.39	26.03	26.39	5300.0
2022-05-27	AGOV	ETF	80.87	80.87	80.87	80.87	294.0
2022-05-27	AGOX	ETF	22.18	22.44	22.13	22.41	47400.0
2022-05-27	AGQ	ETF	30.43	30.48	29.54	29.7	347100.0
2022-05-27	AGZ	ETF	111.28	111.37	111.19	111.23	26484.0
2022-05-27	AGZD	ETF	22.99	23.1	22.985	23.05	119000.0
2022-05-27	AHHX	ETF	9.32	9.328	9.27	9.328	2176.0
2022-05-27	AHYB	ETF	46.024	46.305	46.024	46.305	1000.0
2022-05-27	AIA	ETF	63.77	64.38	63.595	64.29	1507919.0
2022-05-27	AIEQ	ETF	34.08	34.65	34.08	34.61	3900.0
2022-05-27	AIQ	ETF	22.27	22.7	22.27	22.69	88187.0
2022-05-27	AIRR	ETF	39.93	40.68	39.93	40.68	9200.0
2022-05-27	AIVI	ETF	39.92	39.95	39.83	39.93	9300.0
2022-05-27	AIVL	ETF	96.32	97.78	96.32	97.78	9800.0
2022-05-27	ALTL	ETF	42.8	43.26	42.8	43.26	182414.0

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

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