PREVIEW / etf_daily / 2023-07-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-12.parquet
  size:    108 KB
  rows:    3,000

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-07-12	SPY	ETF	446.39	447.48	444.91	446.02	91924500.0
2023-07-12	QQQ	ETF	372.34	374.19	370.3	372.82	61703696.0
2023-07-12	IWM	ETF	192.76	193.05	191.37	191.87	40127300.0
2023-07-12	DIA	ETF	344.91	345.9	343.15	343.63	4140200.0
2023-07-12	GLD	ETF	181.18	181.95	181.1	181.88	7062000.0
2023-07-12	TLT	ETF	100.1	101.12	99.77	100.83	31928000.0
2023-07-12	AAA	ETF	24.626	24.626	24.61	24.61	1000.0
2023-07-12	AAAU	ETF	19.33	19.43	19.33	19.42	956600.0
2023-07-12	AADR	ETF	48.1	50.14	48.1	50.02	2200.0
2023-07-12	AAPB	ETF	28.325	28.399	27.81	28.19	4883.0
2023-07-12	AAPD	ETF	20.54	20.678	20.3424	20.54	85474.0
2023-07-12	AAPU	ETF	28.12	28.55	27.88	28.15	189728.0
2023-07-12	AAXJ	ETF	67.6	68.39	67.6	68.27	535100.0
2023-07-12	ABEQ	ETF	28.23	28.26	28.18	28.22	8900.0
2023-07-12	ACES	ETF	47.87	48.32	47.54	48.11	63400.0
2023-07-12	ACIO	ETF	31.23	31.23	31.105	31.105	27000.0
2023-07-12	ACSI	ETF	47.217	47.217	47.217	47.217	100.0
2023-07-12	ACT	ETF	26.46	26.645	26.39	26.5	175115.0
2023-07-12	ACTV	ETF	32.68	32.68	32.486	32.6	11200.0
2023-07-12	ACVF	ETF	34.06	34.229	34.018	34.056	7600.0
2023-07-12	ACWF	ETF	35.78	35.78	35.6901	35.6917	3787.0
2023-07-12	ACWI	ETF	96.77	97.04	96.62	96.85	3326100.0
2023-07-12	ACWV	ETF	98.22	98.3	97.97	98.15	142000.0
2023-07-12	ACWX	ETF	49.63	50.01	49.61	49.97	2133800.0
2023-07-12	ADFI	ETF	8.47	8.48	8.47	8.475	11100.0
2023-07-12	ADIV	ETF	13.67	13.78	13.67	13.78	500.0
2023-07-12	ADME	ETF	36.51	36.515	36.36	36.37	9100.0
2023-07-12	ADPV	ETF	25.465	25.48	25.45	25.4503	10080.0
2023-07-12	AEMB	ETF	37.65	37.69	37.65	37.65	3900.0
2023-07-12	AESR	ETF	12.87	12.9	12.8	12.87	49100.0
2023-07-12	AFIF	ETF	8.84	8.85	8.82	8.84	11400.0
2023-07-12	AFK	ETF	14.9	15.0	14.86	15.0	7900.0
2023-07-12	AFLG	ETF	25.63	25.687	25.63	25.631	900.0
2023-07-12	AFMC	ETF	25.41	25.46	25.363	25.363	800.0
2023-07-12	AFSM	ETF	25.1	25.14	25.081	25.081	1000.0
2023-07-12	AFTY	ETF	15.03	15.118	15.03	15.118	3200.0
2023-07-12	AGG	ETF	97.51	97.85	97.45	97.8	7189100.0
2023-07-12	AGGH	ETF	22.4208	22.53	22.413	22.47	110731.0
2023-07-12	AGGY	ETF	42.99	43.13	42.99	43.105	184000.0
2023-07-12	AGNG	ETF	27.49	27.55	27.49	27.53	1100.0
2023-07-12	AGOV	ETF	75.82	77.68	75.57	75.735	1870.0
2023-07-12	AGOX	ETF	23.74	24.2	23.61	23.7	88700.0
2023-07-12	AGQ	ETF	29.59	30.23	29.51	30.17	1119800.0
2023-07-12	AGZ	ETF	106.79	107.0	106.79	106.93	21900.0
2023-07-12	AGZD	ETF	22.125	22.145	22.065	22.12	66200.0
2023-07-12	AHYB	ETF	44.14	44.14	44.128	44.128	500.0
2023-07-12	AIA	ETF	60.99	61.67	60.99	61.63	39400.0
2023-07-12	AIEQ	ETF	32.25	32.42	32.13	32.14	16200.0
2023-07-12	AIQ	ETF	28.6	28.63	28.36	28.61	560100.0
2023-07-12	AIRR	ETF	54.54	54.68	53.79	53.99	239700.0

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

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