afonsousn top destinations by txn count
    Updated 2023-01-12
    select
    from_address as destination,
    count(distinct tx_hash) as txn_count,
    count(distinct to_address) as senders_count,
    sum(amount) as total_amount
    from near.core.ez_usn_supply
    where status = 'Success'
    and year(block_timestamp) = 2022
    and event = 'ft_burn'
    group by 1
    having from_address is not null
    order by txn_count desc
    limit 10
    Run a query to Download Data