count(tx_hash) as txns,

count(tx_signer) as wllts

from near.core.fact_transactions

where block_timestamp::date >= current_date - 30

group by 1

order by 2;