latsan2023-04-24 11:06 PM copy copy
    Updated 2023-04-29
    -- forked from 2023-04-24 11:06 PM copy @ https://flipsidecrypto.xyz/edit/queries/b90fe71e-daa1-4bd1-8da4-e9ec1bf19da7

    with cum_txn as (
    SELECT BLOCK_TIMESTAMP,
    tx_hash as hash,
    source_chain,
    sender,
    destination_chain,
    concat(source_chain,'-',destination_chain) as route,
    RECEIVER,
    token_address,
    token_symbol,
    amount
    FROM axelar.core.ez_squid
    WHERE trunc(BLOCK_TIMESTAMP,'day') > '2023-02-23'
    )
    SELECT --route,
    --token_symbol,
    count(DISTINCT hash) as hash,
    count(DISTINCT sender) as user,
    sum(amount) as amt
    FROM cum_txn
    --GROUP BY 1,2


    Run a query to Download Data