DISTINCT signer_id as "Stakers",

count(DISTINCT tx_hash) as "Stakes",

sum(amount_usd) as "Staked $",

count(DISTINCT block_timestamp::date) as "Active Days"

from near.core.ez_token_transfers

join near.core.fact_actions_events_function_call b using(tx_hash)

where to_address = 'v2.ref-finance.near'

and method_name = 'add_liquidity'

and transfer_type = 'nep141'

and args:pool_id = '3411'

and block_timestamp::date >= '2024-09-01'

group by 1

having "Staked $" >0

order by 3 desc