select
date_trunc('week', BLOCK_TIMESTAMP) as date,
PROGRAM_NAME,
count(distinct BLOCK_NUMBER) as number_block,
count(distinct TX_HASH) as number_stakes,
count(distinct ORIGIN_FROM_ADDRESS) as number_users,
sum(AMOUNT_USD) as USD_amount_staked,
from
crosschain.olas.ez_olas_staking
group by
PROGRAM_NAME,
date