WITH stake AS (

SELECT

block_timestamp,

tx_hash,

from_address,

value,

tx_fee,

'Stake' AS label

FROM blast.core.fact_transactions

WHERE to_address = '0xe1784da2b8f42c31fb729e870a4a8064703555c2'

AND origin_function_signature = '0xc88d9ba6'

SELECT

from_address,

count(tx_hash) AS transactions,

SUM(value) AS stake_value,

SUM(tx_fee) AS fee

FROM stake

WHERE from_address = LOWER('{{wallet_address}}')

GROUP BY 1

ORDER BY 1 DESC