flipside

    Untitled Query
    MostafaUntitled Query
    Updated 2023-09-05
    select 'Swap from Shiba' as type, count(distinct TX_HASH) as swaps,count(distinct ORIGIN_FROM_ADDRESS) as swapper,
    sum(AMOUNT_IN_USD) as volum_in
    from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'SHIB'
    and EVENT_NAME='Swap'

    UNION
    select 'Swap to Shiba', count(distinct TX_HASH),count(distinct ORIGIN_FROM_ADDRESS) as swapper,
    sum(AMOUNT_OUT_USD) as volum_out
    from ethereum.core.ez_dex_swaps
    where SYMBOL_OUT = 'SHIB'
    and EVENT_NAME='Swap'

    Run a query to Download Data