tx_from

-- ,b.usd

,sum(a.amount) as amount_sol_in

-- ,min(a.block_timestamp) as min_date_deposit

,sum(sum(a.amount)) over() as total

,case

when tx_from in (

'2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm'

,'AC5RDfQFmDS1deWZos921JfqscXdByf8BKHs5ACWjtW2'

,'5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9'

,'5VCwKtCXgCJ6kit5FybXjvriW3xELsFDhYrPSqtJNmcD'

) then 'CEX' end

as known_label

from solana.core.fact_transfers a

where 1=1

and block_timestamp > '2024-02-01'

and mint='So11111111111111111111111111111111111111111' --we're looking for SOL deposits

and amount>0

and tx_to in (

group by tx_from

,case

when tx_from in (

'2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm'

,'AC5RDfQFmDS1deWZos921JfqscXdByf8BKHs5ACWjtW2'

,'5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9'

,'5VCwKtCXgCJ6kit5FybXjvriW3xELsFDhYrPSqtJNmcD'

) then 'CEX' end