MufasaWhat assets are most transacted on Arbitrum
    Updated 2022-08-16
    with assets as (
    SELECT
    address_name as address, count(distinct(tx_hash)) as no_of_txns
    FROM arbitrum.core.fact_token_transfers txns
    JOIN arbitrum.core.dim_labels dim_labels
    ON contract_address = address
    GROUP BY address_name
    ORDER BY no_of_txns DESC
    LIMIT 20
    )
    select * from assets

    Run a query to Download Data