AzinTotal swap number
    Updated 2023-02-15
    --bridge in 0x3c659741
    --bridge in and swap 0x8ca3bf68
    -- swap only
    -- bridge out 0xf35af1f8
    (select count(*) as ethereum , 'ethereum' as blockchain
    from ethereum.core.fact_event_logs
    where
    EVENT_NAME='Swap'
    and
    ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')

    union all

    (select count(*) as arbitrum , 'arbitrum' as blockchain
    from arbitrum.core.fact_event_logs
    where
    EVENT_NAME='Swap'
    and
    ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')


    union all

    (select count(*) as avalanche , 'avalanche' as blockchain
    from avalanche.core.fact_event_logs
    where
    EVENT_NAME='Swap'
    and
    ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')

    union all

    (select count(*) as bsc , 'bsc' as blockchain
    from bsc.core.fact_event_logs
    where
    EVENT_NAME='Swap'
    Run a query to Download Data