SELECT
date_trunc('day', block_timestamp) as date,
symbol_out,
count(*) as no_of_txs,
sum(amount_out_usd) as sell_amt
from ethereum.core.ez_dex_swaps
where origin_from_address IN
(
SELECT
address
from flipside_prod_db.crosschain.address_labels
where project_name ilike '%celsius%'
)
and block_timestamp >= CURRENT_DATE - interval '90 days'
group by 1,2
order by 3 desc