WITH swaps AS (
SELECT
TO_CURRENCY AS taddress,
sum(TO_AMOUNT/POW(10, TO_DECIMAL)) AS amount
from osmosis.core.fact_swaps
WHERE block_timestamp::DATE BETWEEN '2023-01-01' AND '2023-01-30'
GROUP BY 1
HAVING amount > 400000
),
labels AS (
SELECT
ADDRESS AS taddress,
PROJECT_NAME
FROM osmosis.core.dim_tokens
)
SELECT
s.taddress,
l.PROJECT_NAME,
s.amount
FROM swaps s
LEFT JOIN labels l USING (taddress)
ORDER BY 3 DESC
LIMIT 10;