SELECT

tx_from,

sum(AMOUNT) as deposit_volume

FROM solana.core.fact_transfers

WHERE tx_to like '6tZT9AUcQn4iHMH79YZEXSy55kDLQ4VbA3PMtfLVNsFX'

AND mint like 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

group by 1

order by 2 desc

), tab2 as (

SELECT

tx_from,

sum(AMOUNT) as deposit_volume

FROM solana.core.fact_transfers

WHERE tx_to like '6tZT9AUcQn4iHMH79YZEXSy55kDLQ4VbA3PMtfLVNsFX'

AND mint like 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and not tx_id in (select tx_id from solana.defi.fact_swaps_jupiter_summary where block_timestamp > '2025-02-15')

group by 1

order by 2 desc

select *

from (

select

symbol,

avg(amount_usd) as amount_usd

from (

select

swap_from_mint,

sum(SWAP_TO_AMOUNT) as amount_usd