DATE | SIGNERS | |
|---|---|---|
1 | 2025-03-20 00:00:00.000 | 52412 |
2 | 2025-03-19 00:00:00.000 | 153172 |
3 | 2025-03-18 00:00:00.000 | 140609 |
4 | 2025-03-17 00:00:00.000 | 127838 |
5 | 2025-03-16 00:00:00.000 | 116764 |
6 | 2025-03-15 00:00:00.000 | 107730 |
7 | 2025-03-14 00:00:00.000 | 99867 |
8 | 2025-03-13 00:00:00.000 | 112068 |
9 | 2025-03-12 00:00:00.000 | 107188 |
10 | 2025-03-11 00:00:00.000 | 105347 |
stanverseDaily APT added
Updated 2024-11-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
-- Query with join
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
;
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() - 10
)
select
date(t.BLOCK_TIMESTAMP) as Date,
-- month(e.BLOCK_TIMESTAMP) as month,
count(DISTINCT(t.SENDER)) as signers
FROM aptos.core.fact_transactions t
where t.tx_hash in (
select txn from base
Last run: 21 days ago
10
349B
82s