SELECT sum((tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18)) as total_amount_staked

FROM ethereum.core.fact_transactions

WHERE (tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18) IS NOT NULL

AND to_address = lower('0x9ee91F9f426fA633d227f7a9b000E28b9dfd8599')

AND block_timestamp::DATE >= '2022-07-01'

select * from staked_matic