status,

count(distinct tx_hash) as daily_transactions,

count(distinct from_address) as daily_users_transferers,

count(distinct to_address) as daily_users_receptors,

avg(tx_fee) as average_tx_fee

from polygon.core.fact_transactions where days>='2022-07-01'

group by 1,2 order by 1