mattkstewChain Swaps 5
    Updated 2023-04-27
    with tab1 as (
    select
    date_trunc('week', block_timestamp) as Date_Week,
    sender,
    Amount, -- IN USDC
    source_chain,
    destination_chain,
    RECEIVER

    from axelar.core.ez_squid
    where destination_chain in ('umee',
    'kujira', 'agoric', 'axelarnet', 'crescent', 'terra2', 'juno', 'evmos',
    'stargaze', 'secret', 'osmosis', 'comdex', 'assetmantle')
    and block_timestamp > '2023-02-23'
    )


    select
    Date_Week,
    destination_chain,
    count(*) as Total_Swaps,
    sum(amount) as Total_Volume_Swapped
    from tab1
    group by 1,2

    Run a query to Download Data