PREVIEW / etf_daily / 2023-08-31

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-31.parquet
  size:    107 KB
  rows:    2,982

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-08-31	SPY	ETF	451.65	452.83	450.16	450.35	66084600.0
2023-08-31	QQQ	ETF	376.94	379.719	376.87	377.99	35730701.0
2023-08-31	IWM	ETF	189.2	190.26	188.53	188.61	17953400.0
2023-08-31	DIA	ETF	350.92	351.28	347.74	347.81	2901400.0
2023-08-31	GLD	ETF	180.37	180.49	179.94	180.02	4795600.0
2023-08-31	TLT	ETF	96.54	97.05	96.43	96.64	26959700.0
2023-08-31	AAA	ETF	24.759	24.759	24.73	24.73	800.0
2023-08-31	AAAU	ETF	19.26	19.27	19.22	19.23	643300.0
2023-08-31	AADR	ETF	52.37	52.37	52.19	52.19	400.0
2023-08-31	AAPB	ETF	27.2	27.4899	27.13	27.23	36385.0
2023-08-31	AAPD	ETF	20.82	20.84	20.6801	20.82	85638.0
2023-08-31	AAPU	ETF	27.44	27.69	27.34	27.44	265412.0
2023-08-31	AAXJ	ETF	65.87	65.99	65.46	65.58	998600.0
2023-08-31	ABEQ	ETF	28.293	28.293	28.208	28.208	1300.0
2023-08-31	ACES	ETF	41.74	42.2	41.56	41.69	110700.0
2023-08-31	ACIO	ETF	31.55	31.673	31.51	31.51	65800.0
2023-08-31	ACSI	ETF	46.62	46.62	46.451	46.451	900.0
2023-08-31	ACT	ETF	28.77	28.865	28.48	28.66	455210.0
2023-08-31	ACTV	ETF	32.14	32.23	31.87	32.009	49000.0
2023-08-31	ACVF	ETF	34.85	34.86	34.7	34.7	12100.0
2023-08-31	ACWF	ETF	35.86	35.86	35.7207	35.7207	857.0
2023-08-31	ACWI	ETF	96.8	96.99	96.44	96.5	3860900.0
2023-08-31	ACWV	ETF	98.0	98.09	97.5	97.53	203700.0
2023-08-31	ACWX	ETF	49.02	49.03	48.64	48.72	1381200.0
2023-08-31	ADFI	ETF	8.399	8.41	8.399	8.4	7100.0
2023-08-31	ADIV	ETF	13.607	13.607	13.607	13.607	100.0
2023-08-31	ADME	ETF	36.88	37.047	36.82	36.82	42000.0
2023-08-31	ADPV	ETF	25.43	25.43	25.4281	25.4281	20753.0
2023-08-31	AEMB	ETF	37.3	37.3	37.3	37.3	100.0
2023-08-31	AESR	ETF	12.983	12.99	12.94	12.96	27500.0
2023-08-31	AFIF	ETF	8.94	8.95	8.89	8.91	9300.0
2023-08-31	AFK	ETF	14.6	14.8	14.5	14.6	5200.0
2023-08-31	AFLG	ETF	25.718	25.718	25.718	25.718	100.0
2023-08-31	AFMC	ETF	25.2	25.2	25.149	25.149	800.0
2023-08-31	AFTY	ETF	14.94	14.99	14.94	14.973	1500.0
2023-08-31	AGG	ETF	96.78	96.96	96.72	96.8	7230100.0
2023-08-31	AGGH	ETF	21.88	22.16	21.88	22.11	9675.0
2023-08-31	AGGY	ETF	42.63	42.705	42.6	42.645	73600.0
2023-08-31	AGNG	ETF	27.38	27.38	27.213	27.25	77500.0
2023-08-31	AGOV	ETF	73.57	73.57	73.57	73.57	112.0
2023-08-31	AGOX	ETF	23.88	23.88	23.73	23.75	17500.0
2023-08-31	AGQ	ETF	30.68	30.87	30.14	30.3	483300.0
2023-08-31	AGRH	ETF	25.72	25.72	25.72	25.72	108.0
2023-08-31	AGZ	ETF	106.87	106.98	106.83	106.98	13900.0
2023-08-31	AGZD	ETF	22.2	22.22	22.12	22.21	18100.0
2023-08-31	AHLT	ETF	25.12	25.14	25.0957	25.0957	995459.0
2023-08-31	AHOY	ETF	20.71	20.71	20.6334	20.6334	195.0
2023-08-31	AHYB	ETF	44.29	44.312	44.29	44.312	300.0
2023-08-31	AIA	ETF	58.28	58.28	57.81	58.04	25700.0
2023-08-31	AIEQ	ETF	31.5	31.62	31.47	31.519	5300.0

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

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