select

tx_id,

block_timestamp,

pool_address,

provider_address as user,

pool_name,

platform,

token_a_amount_usd + token_b_amount_usd as amount_usd,

action_type as event_name

from solana.marinade.ez_liquidity_pool_actions

), categorized as (

select

platform,

case

when amount_usd < 100 then 'Small (<$100)'

when amount_usd between 100 and 1000 then 'Medium ($100-$1K)'

when amount_usd between 1000 and 10000 then 'Large ($1K-$10K)'

else 'Whale ($10K+)'

end as category,

count(distinct tx_id) as transactions

from main

where event_name = 'deposit'

group by platform, category

select platform, category, transactions

from categorized

order by platform, transactions desc