PREVIEW / etf_daily / 2023-09-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-15.parquet
  size:    108 KB
  rows:    3,023

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-09-15	SPY	ETF	447.14	447.48	442.92	443.37	111761400.0
2023-09-15	QQQ	ETF	375.91	376.32	369.86	370.81	69811206.0
2023-09-15	IWM	ETF	184.79	185.07	182.79	183.61	39679300.0
2023-09-15	DIA	ETF	348.26	348.85	345.6	346.14	3580800.0
2023-09-15	GLD	ETF	178.55	179.11	178.34	178.34	5619600.0
2023-09-15	TLT	ETF	93.46	93.48	92.96	92.96	25636800.0
2023-09-15	AAA	ETF	24.83	24.86	24.82	24.82	1900.0
2023-09-15	AAAU	ETF	19.07	19.13	19.02	19.05	1244600.0
2023-09-15	AADR	ETF	50.67	50.67	50.44	50.44	600.0
2023-09-15	AAPB	ETF	24.1	24.1	23.61	23.88	14346.0
2023-09-15	AAPD	ETF	22.19	22.49	22.17	22.37	163966.0
2023-09-15	AAPU	ETF	24.98	24.98	24.32	24.56	164624.0
2023-09-15	AAXJ	ETF	65.71	65.9	65.44	65.49	499900.0
2023-09-15	ABEQ	ETF	28.43	28.43	28.28	28.31	12700.0
2023-09-15	ACES	ETF	41.63	41.71	41.02	41.22	99700.0
2023-09-15	ACIO	ETF	31.47	31.54	31.26	31.29	43800.0
2023-09-15	ACSI	ETF	46.05	46.135	46.05	46.135	100.0
2023-09-15	ACT	ETF	27.65	27.81	27.25	27.59	293246.0
2023-09-15	ACTV	ETF	31.49	31.51	31.312	31.312	1800.0
2023-09-15	ACVF	ETF	34.6	34.65	34.305	34.305	3200.0
2023-09-15	ACWF	ETF	35.68	35.68	35.4226	35.4226	2335.0
2023-09-15	ACWI	ETF	96.47	96.51	95.72	95.82	4235400.0
2023-09-15	ACWV	ETF	98.25	98.59	97.94	98.03	108900.0
2023-09-15	ACWX	ETF	48.91	49.02	48.69	48.72	1712200.0
2023-09-15	ADFI	ETF	8.33	8.37	8.33	8.36	13000.0
2023-09-15	ADIV	ETF	13.615	13.615	13.615	13.615	100.0
2023-09-15	ADME	ETF	36.69	36.69	36.43	36.459	23600.0
2023-09-15	AEMB	ETF	36.79	36.79	36.72	36.72	900.0
2023-09-15	AESR	ETF	12.68	12.69	12.6	12.623	24700.0
2023-09-15	AFIF	ETF	8.92	8.92	8.87	8.87	173700.0
2023-09-15	AFK	ETF	14.59	14.65	14.55	14.6	2400.0
2023-09-15	AFMC	ETF	24.3	24.321	24.3	24.321	100.0
2023-09-15	AFSM	ETF	24.395	24.395	24.395	24.395	100.0
2023-09-15	AFTY	ETF	14.76	14.79	14.74	14.74	1000.0
2023-09-15	AGG	ETF	95.64	95.7	95.48	95.49	5667700.0
2023-09-15	AGGH	ETF	21.93	21.98	21.93	21.95	15236.0
2023-09-15	AGGY	ETF	42.26	42.27	42.19	42.2	64700.0
2023-09-15	AGNG	ETF	27.12	27.19	27.0	27.005	1900.0
2023-09-15	AGOV	ETF	73.92	73.92	73.92	73.92	26.0
2023-09-15	AGOX	ETF	23.59	23.59	23.23	23.29	12000.0
2023-09-15	AGQ	ETF	26.89	27.31	26.68	26.69	1318500.0
2023-09-15	AGZ	ETF	106.27	106.32	106.22	106.26	12300.0
2023-09-15	AGZD	ETF	22.32	22.36	22.23	22.29	84900.0
2023-09-15	AHYB	ETF	44.003	44.003	43.933	43.933	1100.0
2023-09-15	AIA	ETF	57.75	58.06	57.54	57.64	24000.0
2023-09-15	AIEQ	ETF	30.96	31.05	30.925	30.925	5000.0
2023-09-15	AIQ	ETF	28.28	28.35	27.92	27.98	248500.0
2023-09-15	AIRR	ETF	53.72	53.72	52.91	53.03	103800.0
2023-09-15	AIVI	ETF	39.23	39.23	39.14	39.14	300.0
2023-09-15	AIVL	ETF	93.22	93.46	92.93	92.93	1700.0

> showing 50 of 3,023 rows — these rows as CSV

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