PREVIEW / etf_daily / 2023-05-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-05.parquet
  size:    110 KB
  rows:    2,962

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
2023-05-05	SPY	ETF	408.91	413.72	408.64	412.63	87844000.0
2023-05-05	QQQ	ETF	318.47	323.76	316.2116	322.89	51806098.0
2023-05-05	IWM	ETF	173.29	175.1	173.1	174.45	35436200.0
2023-05-05	DIA	ETF	334.26	337.5	333.94	336.73	3542100.0
2023-05-05	GLD	ETF	186.56	187.58	185.77	187.46	12507000.0
2023-05-05	TLT	ETF	104.35	104.9	104.11	104.89	15090900.0
2023-05-05	AAA	ETF	24.58	24.58	24.545	24.545	110.0
2023-05-05	AAAU	ETF	19.92	20.02	19.82	20.01	2223100.0
2023-05-05	AADR	ETF	46.97	47.24	46.97	47.22	600.0
2023-05-05	AAPB	ETF	23.93	24.64	23.93	24.54	9787.0
2023-05-05	AAPD	ETF	22.86	22.8638	22.4001	22.5	713065.0
2023-05-05	AAPU	ETF	24.45	25.125	24.42	25.0	219494.0
2023-05-05	AAXJ	ETF	66.57	67.1	66.41	67.07	340200.0
2023-05-05	ABEQ	ETF	28.829	28.88	28.825	28.839	2700.0
2023-05-05	ACES	ETF	41.03	42.03	41.03	41.91	51300.0
2023-05-05	ACIO	ETF	29.8	30.182	29.8	30.12	40400.0
2023-05-05	ACSI	ETF	43.8498	43.8498	43.8498	43.8498	6.0
2023-05-05	ACT	ETF	22.56	24.1	22.1876	23.75	188278.0
2023-05-05	ACTV	ETF	28.89	29.14	28.7801	29.0837	4089.0
2023-05-05	ACVF	ETF	31.2	31.294	31.196	31.294	4800.0
2023-05-05	ACWF	ETF	33.89	33.9947	33.87	33.9947	3879.0
2023-05-05	ACWI	ETF	91.46	92.5	91.43	92.31	3620000.0
2023-05-05	ACWV	ETF	99.41	100.04	99.33	100.0	144500.0
2023-05-05	ACWX	ETF	49.46	50.01	49.4	49.93	2292863.0
2023-05-05	ADFI	ETF	8.51	8.53	8.51	8.515	28100.0
2023-05-05	ADIV	ETF	13.83	13.83	13.83	13.83	100.0
2023-05-05	ADME	ETF	34.43	34.83	34.43	34.75	11700.0
2023-05-05	ADPV	ETF	22.96	23.0543	22.96	23.0543	1222.0
2023-05-05	AEMB	ETF	37.665	37.665	37.665	37.665	100.0
2023-05-05	AESR	ETF	12.01	12.11	12.01	12.09	55500.0
2023-05-05	AFIF	ETF	8.82	8.84	8.8	8.8299	21716.0
2023-05-05	AFK	ETF	15.8	15.84	15.69	15.7683	2727.0
2023-05-05	AFLG	ETF	23.9	23.9	23.9	23.9	100.0
2023-05-05	AFMC	ETF	22.798	22.91	22.798	22.868	400.0
2023-05-05	AFSM	ETF	22.7	22.723	22.7	22.723	100.0
2023-05-05	AFTY	ETF	16.18	16.19	16.18	16.185	2000.0
2023-05-05	AGG	ETF	99.64	99.72	99.45	99.65	4003000.0
2023-05-05	AGGH	ETF	23.09	23.11	23.09	23.1031	1228.0
2023-05-05	AGGY	ETF	43.79	43.812	43.71	43.8	52700.0
2023-05-05	AGNG	ETF	28.03	28.3	28.03	28.289	3300.0
2023-05-05	AGOV	ETF	77.1	77.1	77.1	77.1	116.0
2023-05-05	AGOX	ETF	21.46	21.645	21.455	21.57	15500.0
2023-05-05	AGQ	ETF	34.58	35.18	33.73	35.16	1330400.0
2023-05-05	AGZ	ETF	108.58	108.59	108.44	108.57	19901.0
2023-05-05	AGZD	ETF	21.755	21.765	21.625	21.765	34600.0
2023-05-05	AHYB	ETF	43.84	43.84	43.791	43.791	400.0
2023-05-05	AIA	ETF	58.44	59.14	58.44	59.07	27884.0
2023-05-05	AIEQ	ETF	27.13	27.62	27.13	27.48	10000.0
2023-05-05	AIQ	ETF	23.55	23.875	23.55	23.82	48923.0
2023-05-05	AIRR	ETF	45.91	46.66	45.91	46.48	31300.0

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

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