FROM osmosis.core.dim_labels x

INNER JOIN osmosis.core.dim_prices y

ON y.symbol = x.PROJECT_NAME

GROUP BY 1, 2)

SELECT trader, 'Dive in Headfirst' AS join_type,

--CASE WHEN (TO_CURRENCY IS NULL OR TO_CURRENCY ILIKE '%gamm/pool%') THEN 'Dive in Headfirst'

--ELSE 'Wade in Carefully' END AS join_type,

COUNT(*) AS n_tx,

sum((from_amount*price_usd)/pow(10, FROM_DECIMAL)) AS Amount_USD

FROM osmosis.core.fact_swaps a INNER JOIN t1 b ON a.FROM_CURRENCY = b.address

WHERE TX_STATUS = 'SUCCEEDED' AND (TO_CURRENCY IS NULL OR TO_CURRENCY ILIKE '%gamm/pool%')

GROUP BY 1

ORDER BY 3 DESC

LIMIT 10