select

FROM_ADDRESS,

min(to_char(convert_timezone('UTC', 'Asia/Shanghai', block_timestamp), 'YYYY-MM-DD')) as first_tx_day

from

monad.testnet.fact_transactions

where

TX_SUCCEEDED=true

group by

FROM_ADDRESS

select

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

count(DISTINCT f.FROM_ADDRESS) as "新增用户数"

from

first_tx_date f

join

monad.testnet.fact_transactions t

on

f.FROM_ADDRESS = t.FROM_ADDRESS

where

TX_SUCCEEDED=true

and to_char(convert_timezone('UTC', 'Asia/Shanghai', t.block_timestamp), 'YYYY-MM-DD') = f.first_tx_day

and f.first_tx_day >= current_date() - 7

group by

to_char(convert_timezone('UTC', 'Asia/Shanghai', t.block_timestamp), 'YYYY-MM-DD')

order by

"日期" desc;