SELECT block_timestamp, tx_hash, to_address AS user, amount AS first_amount_received,

FROM base.core.ez_token_transfers

WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'

AND tx_hash = '0xe930bba69e4c165a44197088b25f890b37de23c182f992c0834fa8843407c9f0'

ORDER BY event_index ASC

),

token_in_out AS(

to_address AS user,

SUM(amount) AS amount,

FROM base.core.ez_token_transfers

WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'

GROUP BY 1

UNION ALL

from_address AS user,

SUM(-amount) AS amount,

FROM base.core.ez_token_transfers

WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'

GROUP BY 1

),

current_user_amount AS(

SELECT

user,

sum(amount) AS current_balance

FROM token_in_out

GROUP BY 1

),

stake AS(

SELECT

block_timestamp, tx_hash, decoded_log:from AS user, decoded_log:value/pow(10,18) AS amount, 'Stake' AS label

FROM base.core.ez_decoded_event_logs