with ust_add as (
SELECT
address,
address_name
from crosschain.address_labels
where blockchain='solana' and address_name is not null and label_type='token'
and (address_name = 'ust (wormhole)')
)
select
date(block_timestamp) as date,
count(DISTINCT(tx_id)) as total_transactions
from solana.transactions
inner join ust_add a
on (lower(a.address) = lower(post_mint) or lower(a.address) = lower(pre_mint))
where lower(a.address) = lower(post_mint) or lower(a.address) = lower(pre_mint)
and block_timestamp >= '2021-06-01' and block_timestamp <= '2022-01-31'
and succeeded = 'TRUE'
group by date(block_timestamp)
order by date(block_timestamp) asc