FROM flipside_prod_db.crosschain.address_labels

WHERE project_name ilike '%celsius%'

AND label_subtype = 'general_contract'),

St as ( SELECT block_timestamp::date as dates, m.platform as project,m.from_address,m.tx_id,

m.to_address,m.token_address,m.direction as direction,m.amount_usd

FROM flipside_prod_db.ethereum.dex_swaps as m, Celsius

WHERE to_address in (Celsius.unique_address) AND platform ilike '%sushiswap%' AND amount_usd > 0

ORDER BY dates,platform,m.to_address,m.token_address),

symb as (SELECT symbol,address

FROM ethereum.core.dim_contracts)

SELECT SUBSTRING(St.to_address, 3, len(St.to_address)-2) as celsius_address, St.project,

sum(CASE WHEN direction = 'IN' THEN amount_usd ELSE 0 END) as SWAP_IN,

sum(CASE WHEN direction = 'OUT' THEN amount_usd ELSE 0 END) as SWAP_OUT,

sum(amount_usd) as USD_volume,

count(DISTINCT(St.tx_id)) as tx

FROM sT join symB on sT.token_address = symB.address

GROUP BY celsius_address, project

ORDER BY USD_volume desc

LIMIT 5