granadohoTotal Transactions of UST (wormhole) from 06/21 - 01/22
    Updated 2022-01-29
    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
    Run a query to Download Data