jackguyaxlUSDC: Soon to be forgotten?
    Updated 2023-01-27
    SELECT
    --*
    date_trunc('day', block_timestamp) as day,
    CASE WHEN receiver LIKE 'juno%' THEN 'JUNO'
    WHEN receiver LIKE 'stars%' THEN 'STARS'
    WHEN receiver LIKE 'axelar%' THEN 'AXL'
    WHEN receiver LIKE 'evmos%' THEN 'EVMOS'
    WHEN receiver LIKE 'cosmos%' THEN 'ATOM'
    WHEN receiver LIKE 'stride%' THEN 'stride'
    WHEN receiver 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 SENDER LIKE 'osmo%'
    AND currency LIKE 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
    AND not receiver LIKE 'osmo%'
    --LIMIT 1000
    GROUP BY 1,2
    Run a query to Download Data