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