-- forked from All Stakers @ https://flipsidecrypto.xyz/edit/queries/45022f49-7989-48bf-a188-0fa40f0b498a

-- select * from optimism.core.ez_token_transfers

select

sum(amount) as Total_esPIKA_Staked,

count(distinct from_address) as total_Stakers,

date_trunc('hour', block_timestamp) as time

from optimism.core.ez_token_transfers

where to_address = '0x21a4a5c00ab2fd749ebec8282456d93351459f2a'

and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'

and origin_function_signature = '0xb6b55f25'

group by time