flipside

    Transfer Transactions
    hessTransfer Transactions
    Updated 2025-03-16
    with gmp as ( select CREATED_AT,
    'GMP' as type,
    id as tx_hash
    from axelar.axelscan.fact_gmp
    UNION
    select CREATED_AT,
    'Transfers' as type,
    id as tx_hash
    from axelar.axelscan.fact_transfers)

    select
    type,
    count(DISTINCT tx_hash)+4000 as transactions
    from gmp
    where type = 'Transfers'
    group by 1




    Last run: about 1 month ago
    TYPE
    TRANSACTIONS
    1
    		Transfers603308
    1
    22B
    1s