PREVIEW / etf_daily / 2023-04-24

all etf daily files

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

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-24	SPY	ETF	411.99	413.07	410.6	412.63	64332100.0
2023-04-24	QQQ	ETF	316.38	317.7391	313.74	315.95	44043063.0
2023-04-24	IWM	ETF	177.38	178.45	176.5	177.44	17781000.0
2023-04-24	DIA	ETF	337.91	338.91	337.21	338.75	2288800.0
2023-04-24	GLD	ETF	184.07	185.03	183.46	184.81	8303400.0
2023-04-24	TLT	ETF	104.96	105.49	104.84	105.41	17034300.0
2023-04-24	AAA	ETF	24.59	24.59	24.55	24.55	546.0
2023-04-24	AAAU	ETF	19.65	19.75	19.59	19.73	2763800.0
2023-04-24	AADR	ETF	48.33	48.33	48.12	48.12	200.0
2023-04-24	AAPB	ETF	22.615	22.64	22.3176	22.64	4719.0
2023-04-24	AAPD	ETF	23.73	23.8299	23.6	23.65	100277.0
2023-04-24	AAPU	ETF	23.18	23.35	23.02	23.33	42586.0
2023-04-24	AAXJ	ETF	66.55	66.67	66.2	66.38	523200.0
2023-04-24	ABEQ	ETF	28.555	28.61	28.54	28.59	7400.0
2023-04-24	ACES	ETF	43.63	44.21	43.36	44.13	309100.0
2023-04-24	ACIO	ETF	30.1	30.26	30.0	30.22	21900.0
2023-04-24	ACSI	ETF	44.23	44.23	43.943	44.2143	3129.0
2023-04-24	ACT	ETF	24.3	24.31	24.05	24.07	143058.0
2023-04-24	ACTV	ETF	28.96	28.9874	28.835	28.9874	9120.0
2023-04-24	ACTX	ETF	0.3	0.3	0.3	0.3	417.0
2023-04-24	ACVF	ETF	31.28	31.46	31.28	31.453	11200.0
2023-04-24	ACWF	ETF	34.0189	34.0189	33.87	33.9813	5638.0
2023-04-24	ACWI	ETF	92.1	92.31	91.86	92.21	2106400.0
2023-04-24	ACWV	ETF	99.04	99.14	98.9	99.13	282800.0
2023-04-24	ACWX	ETF	49.63	49.73	49.59	49.72	661010.0
2023-04-24	ADFI	ETF	8.52	8.53	8.51	8.525	16900.0
2023-04-24	ADIV	ETF	13.62	13.62	13.62	13.62	100.0
2023-04-24	ADME	ETF	34.72	34.97	34.72	34.93	39300.0
2023-04-24	ADPV	ETF	22.97	23.01	22.97	22.9778	4814.0
2023-04-24	AEMB	ETF	37.52	37.52	37.52	37.52	100.0
2023-04-24	AESR	ETF	12.14	12.17	12.1	12.17	60000.0
2023-04-24	AFIF	ETF	8.8362	8.85	8.8	8.8248	276227.0
2023-04-24	AFK	ETF	15.73	15.8416	15.7001	15.8156	9028.0
2023-04-24	AFLG	ETF	24.107	24.107	24.107	24.107	100.0
2023-04-24	AFMC	ETF	23.146	23.146	23.0	23.076	900.0
2023-04-24	AFSM	ETF	23.236	23.236	23.236	23.236	100.0
2023-04-24	AFTY	ETF	15.72	15.8	15.72	15.8	2500.0
2023-04-24	AGG	ETF	99.42	99.59	99.36	99.56	3256900.0
2023-04-24	AGGY	ETF	43.56	43.65	43.56	43.64	74800.0
2023-04-24	AGNG	ETF	28.31	28.31	28.26	28.27	1500.0
2023-04-24	AGOV	ETF	76.15	77.975	76.15	77.975	421.0
2023-04-24	AGOX	ETF	21.78	21.78	21.61	21.709	16400.0
2023-04-24	AGQ	ETF	33.34	34.09	33.11	33.81	438700.0
2023-04-24	AGZ	ETF	108.11	108.18	108.09	108.1759	14498.0
2023-04-24	AGZD	ETF	21.77	21.945	21.755	21.8	486400.0
2023-04-24	AHYB	ETF	44.0	44.078	44.0	44.078	6500.0
2023-04-24	AIA	ETF	58.7	58.8	58.43	58.56	26945.0
2023-04-24	AIEQ	ETF	27.99	28.013	27.67	27.86	10200.0
2023-04-24	AIQ	ETF	23.65	23.7652	23.406	23.535	118339.0
2023-04-24	AIRR	ETF	45.3	45.95	45.3	45.77	45400.0

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

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