WITH staked AS (

SELECT

TRUNC(block_timestamp, 'day') AS date,

COUNT(DISTINCT from_address) AS stakers,

COUNT(DISTINCT tx_hash) AS staking_actions,

AVG(tx_fee) AS avg_staking_fee,

SUM(value) AS staked_flow

FROM flow.core_evm.fact_transactions

WHERE origin_function_signature = '0xac76d450'

AND to_address = '0xFE8189A3016cb6A3668b8ccdAC520CE572D4287a'

GROUP BY 1

),

unstaked AS (

SELECT

TRUNC(block_timestamp, 'day') AS date,

COUNT(DISTINCT from_address) AS unstakers,

COUNT(DISTINCT tx_hash) AS unstaking_actions,

AVG(tx_fee) AS avg_unstaking_fee,

SUM(CASE

WHEN tx_hash = '0xccf5ba219e98041ffbe554cdad5891af01014aefdb97bdc3f1ad8fa6e822b814' THEN 2

WHEN tx_hash = '0x8437e86462e5d50d12658bb7d3f24f0e15b842fa86a6ce034b3e8fb013194157' THEN 1

WHEN tx_hash = '0x27ae972b3ecdecfbc1b0a4b27e44d7f2787390ad5529f433a4f4951a5971ab7c' THEN 35

WHEN tx_hash = '0x0157a8fdc24ba2bb970f91cd841433458cd1e49b997afe42556e8c111bf7414a' THEN 5

WHEN tx_hash = '0x6c61989d277f8f48edea70587490d58c96350d5bbef0857b6e597056354e8e45' THEN 0.2

when tx_hash = '0x4733dfa12535738063f304a94ebdf8b9daf6e721296a4e8f1a8178e3a2e8aa11' then 450

when tx_hash = '0xc6b368d79817509bc3688a83af2177608dfb4d614bd651dc76ba87ab1c85037d' then 1399

when tx_hash = '0x933d578c8a8a76c4189ac42c91c35cbc7737c0fd85a129ad297d6976bf7c0d6a' then 1

when tx_hash = '0xd75de27fd75407ed25b18153f85742489dd565a1e8639c5a51133ed3225eda63' then 0.001

when tx_hash = '0x4cf905a9b5df4253a6ea1efe99461eaec76b8449310482bfef6d1276493a6d73' then 0.001

when tx_hash = '0x4f657840b29b61cfd8ea5d858d4c1480658975c8117edf04b2e7052b3e0f707a' then 0.1