stanverseUAW
Updated 2024-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
-- ACCOUNT_ADDRESS,
date(e.BLOCK_TIMESTAMP) as Date,
-- month(e.BLOCK_TIMESTAMP) as month,
count(DISTINCT(t.SENDER)) as signers
from aptos.core.fact_events e
left join aptos.core.fact_transactions t on t.tx_hash = e.tx_hash
where e.ACCOUNT_ADDRESS in ('0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9')
and e.EVENT_TYPE = '0x1::coin::DepositEvent'
-- and date(e.block_timestamp) < '2024-03-06'
-- '0x1::coin::WithdrawEvent'
group by 1
order by 1 DESC
limit 10
;
QueryRunArchived: QueryRun has been archived