to_char(convert_timezone('UTC', 'Asia/Shanghai', block_timestamp), 'YYYY-MM-DD') as "日期",

count(DISTINCT FROM_ADDRESS) as "活跃数量"

from

monad.testnet.fact_transactions

where

TX_SUCCEEDED=true

and block_timestamp >= current_date() - 7

group by

1

order by

1 desc;