Select
first_tx,
count(1) new_wallets
from
(
select
attribute_value,
min(block_timestamp::DATE)::STRING first_tx
from
sei_testnet.silver.msg_attributes
where
regexp_like(attribute_value, 'sei1[0-9a-z]{38,38}')
and block_timestamp is not null
group by
1
)
group by
1
order by
1