FROM osmosis.core.dim_labels x

INNER JOIN osmosis.core.dim_prices y

ON y.symbol = x.PROJECT_NAME

GROUP BY 1, 2)

SELECT symbol,

'Wade in Carefully' AS join_type,

COUNT(*) AS n_tx,

COUNT(DISTINCT trader) AS n_user,

sum((from_amount)/pow(10, FROM_DECIMAL)) AS Amount,

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

--avg((from_amount)/pow(10, FROM_DECIMAL)) AS avg_Amount,

--avg((from_amount*price_usd)/pow(10, FROM_DECIMAL)) AS avg_Amount_USD

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

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

GROUP BY 1, 2

ORDER BY 3 DESC