PROGRAM_NAME,

count(distinct(BLOCK_TIMESTAMP::date)) as Activity_gnosis_days,

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