PREVIEW / etf_daily / 2023-04-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-21.parquet
  size:    109 KB
  rows:    2,932

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-04-21	SPY	ETF	412.19	412.68	410.17	412.2	73457400.0
2023-04-21	QQQ	ETF	315.91	317.4	314.1	316.61	59002285.0
2023-04-21	IWM	ETF	177.81	177.96	175.86	177.56	25972800.0
2023-04-21	DIA	ETF	338.26	338.58	336.81	338.11	2470100.0
2023-04-21	GLD	ETF	184.98	185.68	183.22	184.25	10698700.0
2023-04-21	TLT	ETF	105.3	105.46	104.27	104.4	15244700.0
2023-04-21	AAA	ETF	24.565	24.565	24.565	24.565	26.0
2023-04-21	AAAU	ETF	19.74	19.82	19.55	19.66	3029500.0
2023-04-21	AADR	ETF	48.31	48.31	47.98	48.16	3400.0
2023-04-21	AAPB	ETF	22.53	22.6	22.49	22.52	6472.0
2023-04-21	AAPD	ETF	23.68	23.75	23.489	23.7	161996.0
2023-04-21	AAPU	ETF	23.25	23.4353	23.17	23.25	71692.0
2023-04-21	AAXJ	ETF	66.75	66.8	66.38	66.72	502800.0
2023-04-21	ABEQ	ETF	28.42	28.53	28.42	28.53	98600.0
2023-04-21	ACES	ETF	43.68	43.831	43.23	43.71	192400.0
2023-04-21	ACIO	ETF	30.36	30.36	30.18	30.215	278500.0
2023-04-21	ACSI	ETF	44.2334	44.2334	44.2334	44.2334	98.0
2023-04-21	ACT	ETF	24.18	24.39	24.15	24.3	201072.0
2023-04-21	ACTV	ETF	29.15	29.15	28.9	29.0303	3710.0
2023-04-21	ACTX	ETF	0.305	0.305	0.305	0.305	546.0
2023-04-21	ACVF	ETF	31.42	31.43	31.4	31.419	1000.0
2023-04-21	ACWF	ETF	33.89	33.975	33.832	33.9668	3348.0
2023-04-21	ACWI	ETF	92.05	92.26	91.68	92.17	3061900.0
2023-04-21	ACWV	ETF	98.8	99.04	98.67	98.94	50700.0
2023-04-21	ACWX	ETF	49.55	49.695	49.35	49.66	1193058.0
2023-04-21	ADFI	ETF	8.49	8.5	8.49	8.495	35700.0
2023-04-21	ADME	ETF	34.89	34.93	34.87	34.92	116300.0
2023-04-21	ADPV	ETF	22.98	23.12	22.97	23.1185	19055.0
2023-04-21	AEMB	ETF	37.49	37.49	37.49	37.49	100.0
2023-04-21	AESR	ETF	12.13	12.15	12.05	12.15	51600.0
2023-04-21	AFIF	ETF	8.82	8.84	8.8	8.8148	16597.0
2023-04-21	AFK	ETF	15.95	15.95	15.77	15.85	8367.0
2023-04-21	AFLG	ETF	24.056	24.056	24.056	24.056	100.0
2023-04-21	AFMC	ETF	23.01	23.087	23.01	23.087	100.0
2023-04-21	AFSM	ETF	23.18	23.255	23.18	23.255	100.0
2023-04-21	AFTY	ETF	15.965	15.982	15.96	15.982	300.0
2023-04-21	AGG	ETF	99.51	99.56	99.11	99.17	5367300.0
2023-04-21	AGGY	ETF	43.72	43.78	43.6	43.62	104800.0
2023-04-21	AGNG	ETF	28.116	28.279	28.116	28.233	1900.0
2023-04-21	AGOV	ETF	77.75	77.75	77.75	77.75	3.0
2023-04-21	AGOX	ETF	21.76	21.78	21.62	21.749	28400.0
2023-04-21	AGQ	ETF	34.1	34.52	33.22	33.52	893100.0
2023-04-21	AGZ	ETF	108.2	108.2	107.9401	107.98	14948.0
2023-04-21	AGZD	ETF	21.82	21.84	21.76	21.81	42000.0
2023-04-21	AHYB	ETF	43.851	43.982	43.845	43.943	3300.0
2023-04-21	AIA	ETF	59.28	59.28	58.8301	59.07	106633.0
2023-04-21	AIEQ	ETF	27.86	28.249	27.77	28.03	9400.0
2023-04-21	AIQ	ETF	23.64	23.7599	23.5	23.72	10934.0
2023-04-21	AIRR	ETF	45.91	45.91	45.254	45.35	71000.0
2023-04-21	AIVI	ETF	39.98	40.14	39.98	40.14	1300.0

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

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