Updated 2023-01-03
    ---credit to jackguy
    SELECT
    --*
    date_trunc('month', block_timestamp) as month,
    CASE WHEN sender LIKE 'juno%' THEN 'JUNO'
    WHEN SENDER LIKE 'stars%' THEN 'STARS'
    WHEN SENDER LIKE 'axelar%' THEN 'AXL'
    WHEN SENDER LIKE 'evmos%' THEN 'EVMOS'
    WHEN SENDER LIKE 'cosmos%' THEN 'ATOM'
    WHEN SENDER LIKE 'stride%' THEN 'stride'
    WHEN SENDER LIKE 'terra%' THEN 'Terra'
    ELSE 'Other Chain' END,
    COUNT(DISTINCT tx_id) as transfers,
    sum(amount/power(10, decimal)) as volume

    FROM osmosis.core.fact_transfers
    WHERE RECEIVER LIKE 'osmo%'
    AND not SENDER LIKE 'osmo%'
    --LIMIT 1000
    GROUP BY 1,2
    Run a query to Download Data