SELECT CASE WHEN FROM_CURRENCY ILIKE '%gamm%' AND TO_CURRENCY NOT ILIKE '%gamm%' THEN TO_CURRENCY

ELSE FROM_CURRENCY END AS currency,

SUM(CASE WHEN FROM_CURRENCY ILIKE '%gamm%' AND TO_CURRENCY NOT ILIKE '%gamm%' THEN TO_AMOUNT/TO_DECIMAL

ELSE FROM_AMOUNT/FROM_DECIMAL END) AS amount, POOL_IDS[0], DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "DATE"

FROM osmosis.core.fact_swaps

WHERE BLOCK_TIMESTAMP::DATE >= '2022-05-01'

GROUP BY 3, 1, 4

HAVING amount IS NOT NULL

),

SELECT LABEL, "DATE", amount

FROM osmosis.core.dim_labels sd

JOIN mount

ON mount.currency = sd.ADDRESS OR mount.currency = sd.PROJECT_NAME