count(distinct a.tx_hash) as unstakes_count,

count(distinct tx_signer) as unstakers_count

from near.core.fact_receipts a,

lateral flatten(input => logs) c

join near.core.fact_transactions b

where c.value ilike any ('%unstaking%', '%withdrawing%')

and a.tx_hash = b.tx_hash

and b.block_timestamp::date = (

select max(block_timestamp)::date

from near.core.fact_actions_events_function_call b

where method_name ilike any ('%unstaking%', '%withdrawing%')