Getstan2024-05-16 07:09 PM
Updated 2024-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
count(DISTINCT t.sender)
from aptos.core.fact_events a
left join aptos.core.fact_transactions t on t.tx_hash = a.tx_hash
where a.event_type in (
'0x1::coin::DepositEvent'
)
and (t.sender in (
'0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9'
)
or a.account_address in (
'0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9'
)
)
and a.success = 'TRUE'
-- limit 100
-- group by 1
-- order by 1
QueryRunArchived: QueryRun has been archived