SocioCryptoStats - broken down by source_chain
    Updated 2023-11-07
    SELECT
    date_trunc('week', block_timestamp) as date,
    source_chain as chains,
    count(DISTINCT tx_hash) as n_txs,
    count(DISTINCT sender) as n_sender,
    sum(amount) as volume,
    AVG(amount) as avg_volume,
    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY amount) as median_volume
    FROM axelar.core.ez_squid
    WHERE token_symbol in ('axlUSDC','USDC', 'axlUSDT', 'USDT')
    GROUP BY 1 , 2
    ORDER BY 1 DESC
    Run a query to Download Data