with base AS

select

date(e.BLOCK_TIMESTAMP) as date,

e.tx_hash as txn

from aptos.core.fact_events e

where e.ACCOUNT_ADDRESS in ('0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9')

and e.EVENT_TYPE = '0x1::coin::DepositEvent'

AND date(e.BLOCK_TIMESTAMP)>=CURRENT_DATE()-20

select

date(t.BLOCK_TIMESTAMP) as Date,

count(DISTINCT(t.SENDER)) as signers

FROM aptos.core.fact_transactions t

where t.tx_hash in (select txn from base )

AND date(t.BLOCK_TIMESTAMP)>=CURRENT_DATE()-20

GROUP BY 1

ORDER by 1 DESC

;