select day, sum(staked) as staked from (

select date_trunc('day',block_timestamp) as day, (utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as staked

from berachain.testnet.fact_event_logs

where CONTRACT_ADDRESS=lower('0x2B4141f98B8cD2a03F58bD722D4E8916d2106504')

and ORIGIN_FUNCTION_SIGNATURE='0xb6b55f25'

and TOPICS[0]='0xdceb62ada4e4ec63db2fb9ed65e38a56764ba06e1346b9aebc081ead867fa5a3')

group by 1

),

unstaking as (

select day, sum(unstaked) as unstaked from (

select date_trunc('day',block_timestamp) as day, (utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as unstaked

from berachain.testnet.fact_event_logs

where CONTRACT_ADDRESS=lower('0x2B4141f98B8cD2a03F58bD722D4E8916d2106504')

and ORIGIN_FUNCTION_SIGNATURE='0x2e1a7d4d'

and TOPICS[0]='0x6d8fccb210175d9b6d8a076e606aebf0e5f57d186e5d48e8cc5d431a88e5ae6b')

group by 1

),

burned as (

select day, sum(burned) as burned from (

select date_trunc('day',block_timestamp) as day, (utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as burned

from berachain.testnet.fact_event_logs

where CONTRACT_ADDRESS=lower('0x2B4141f98B8cD2a03F58bD722D4E8916d2106504')

and ORIGIN_FUNCTION_SIGNATURE='0x1dd319cb'

and TOPICS[0]='0x9c6f79d7f1057ffac5eaa31065872a36975bcc08ad7bd9119d6f703795660f77')

group by 1

select * from burned