from near.core.fact_actions_events_function_call

where method_name = 'ft_on_transfer'

and receiver_id = 'allstake.near'

and receipt_succeeded = true

and block_timestamp >= '2024-06-16')

,

staking as ( select block_timestamp::Date as date,

tx_hash,

from_address as user,

case when contract_address = 'meta-pool.near' then 'STNEAR'

when contract_address = 'linear-protocol.near' then 'LINEAR' else 'AURORA' end as token_name,

contract_address as token_address,

AMOUNT,

from near.core.ez_token_transfers

where CONTRACT_ADDRESS in ('linear-protocol.near',

'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near',

and tx_hash in (select tx_hash from stake)

and to_address = 'allstake.near'

and transfer_type = 'nep141'

and block_timestamp::Date >= '2024-06-16')

,

unstaking as ( select block_timestamp::Date as date,

tx_hash,

from_address as user,

case when contract_address = 'meta-pool.near' then 'STNEAR'

when contract_address = 'linear-protocol.near' then 'LINEAR' else 'AURORA' end as token_name,

contract_address as token_address,

AMOUNT,

from near.core.ez_token_transfers

where CONTRACT_ADDRESS in ('linear-protocol.near',

'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near',