Afonso_Diaz2023-04-27 01:26 PM
    Updated 2023-04-27
    with
    t as (
    select t.chain
    from ((values
    ('assetmantle'),
    ('juno'),
    ('kujira'),
    ('comdex'),
    ('umee'),
    ('axelarnet'),
    ('stargaze'),
    ('agoric'),
    ('terra2'),
    ('osmosis'),
    ('crescent'),
    ('evmos'),
    ('secret')
    ) as t(chain)
    )),

    t4 as (
    select
    sender as user,
    count(distinct tx_hash) transactions,
    sum(amount) as volume_usd
    from axelar.core.ez_squid
    where destination_chain in (select chain from t)
    and block_timestamp >= '2023-02-23'
    group by 1
    )

    select
    case
    when transactions = 1 then '1 Transaction'
    when transactions <= 5 then '2 - 5 Transactions'
    when transactions <= 10 then '6 - 10 Transactions'
    Run a query to Download Data