PREVIEW / etf_daily / 2023-05-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-10.parquet
  size:    109 KB
  rows:    2,952

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-05-10	SPY	ETF	413.88	414.54	408.87	412.85	96142900.0
2023-05-10	QQQ	ETF	324.12	326.01	321.6	325.14	60446623.0
2023-05-10	IWM	ETF	175.96	176.02	172.72	174.41	27281900.0
2023-05-10	DIA	ETF	337.4	337.85	332.49	335.49	3365500.0
2023-05-10	GLD	ETF	188.98	189.64	187.82	188.75	9392100.0
2023-05-10	TLT	ETF	103.67	104.24	103.64	104.05	22886800.0
2023-05-10	AAA	ETF	24.54	24.54	24.54	24.54	154.0
2023-05-10	AAAU	ETF	20.17	20.23	20.05	20.14	549900.0
2023-05-10	AADR	ETF	47.14	47.14	46.87	47.02	1500.0
2023-05-10	AAPB	ETF	24.36	24.5	24.17	24.44	4000.0
2023-05-10	AAPD	ETF	22.58	22.71	22.45	22.52	143811.0
2023-05-10	AAPU	ETF	24.86	25.0402	24.62	24.96	50383.0
2023-05-10	AAXJ	ETF	66.44	66.62	66.11	66.45	309700.0
2023-05-10	ABEQ	ETF	28.69	28.69	28.53	28.676	4800.0
2023-05-10	ACES	ETF	43.0	43.0	41.88	42.26	108400.0
2023-05-10	ACIO	ETF	30.22	30.22	30.06	30.156	52800.0
2023-05-10	ACSI	ETF	43.8551	43.8551	43.8551	43.8551	53.0
2023-05-10	ACT	ETF	24.74	24.74	23.865	23.92	245000.0
2023-05-10	ACTV	ETF	28.91	28.91	28.46	28.71	5762.0
2023-05-10	ACVF	ETF	31.26	31.26	31.0	31.247	1800.0
2023-05-10	ACWF	ETF	33.8	34.0701	33.8	34.0365	1007.0
2023-05-10	ACWI	ETF	92.36	92.47	91.44	92.19	6397000.0
2023-05-10	ACWV	ETF	100.2	100.2	99.47	100.07	90800.0
2023-05-10	ACWX	ETF	49.77	49.795	49.35	49.67	1143134.0
2023-05-10	ADFI	ETF	8.53	8.54	8.51	8.525	21900.0
2023-05-10	ADIV	ETF	13.657	13.72	13.657	13.72	1100.0
2023-05-10	ADME	ETF	34.67	34.87	34.57	34.85	23400.0
2023-05-10	ADPV	ETF	23.17	23.21	23.17	23.18	1916.0
2023-05-10	AEMB	ETF	37.665	37.665	37.665	37.665	100.0
2023-05-10	AESR	ETF	12.07	12.07	11.98	12.04	32700.0
2023-05-10	AFIF	ETF	8.89	8.89	8.84	8.84	37636.0
2023-05-10	AFK	ETF	15.78	15.78	15.45	15.52	11407.0
2023-05-10	AFLG	ETF	23.811	23.811	23.811	23.811	100.0
2023-05-10	AFSM	ETF	22.709	22.709	22.709	22.709	100.0
2023-05-10	AFTY	ETF	16.05	16.094	16.05	16.094	700.0
2023-05-10	AGG	ETF	99.43	99.68	99.39	99.65	4803000.0
2023-05-10	AGGH	ETF	23.15	23.2	23.12	23.2	1814.0
2023-05-10	AGGY	ETF	43.68	43.79	43.68	43.78	105800.0
2023-05-10	AGNG	ETF	28.39	28.48	28.265	28.47	2100.0
2023-05-10	AGOV	ETF	77.4	77.4	77.4	77.4	70.0
2023-05-10	AGOX	ETF	21.67	21.717	21.46	21.616	16300.0
2023-05-10	AGQ	ETF	35.23	35.36	33.86	34.3	1118100.0
2023-05-10	AGZ	ETF	108.47	108.81	108.47	108.67	47737.0
2023-05-10	AGZD	ETF	21.7	21.755	21.69	21.71	48800.0
2023-05-10	AHYB	ETF	43.758	43.82	43.74	43.82	1100.0
2023-05-10	AIA	ETF	58.12	58.35	57.86	58.22	21894.0
2023-05-10	AIEQ	ETF	27.8	28.1	27.65	27.992	13400.0
2023-05-10	AIQ	ETF	23.96	24.07	23.73	23.98	83395.0
2023-05-10	AIRR	ETF	47.2	47.2	46.21	46.63	29100.0
2023-05-10	AIVI	ETF	40.39	40.39	40.12	40.27	8900.0

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

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