Deebs-DeFi-j9fRbzMARS Volume grouped by Action and Currency
    Updated 2023-04-20
    SELECT
    PROJECT_NAME AS Currency,
    ACTION,
    count(DISTINCT tx_id) as total_transactions,
    sum(amount/pow(10,6)) as total_volume
    FROM osmosis.mars.ez_redbank_actions
    join osmosis.core.dim_labels on currency=address
    WHERE tx_succeeded = 'TRUE'
    GROUP BY 1,2
    Run a query to Download Data