TYPE | DATE | WALLETS | |
---|---|---|---|
1 | Signers | 2024-01-18 00:00:00.000 | 875488 |
2 | Signers | 2024-01-16 00:00:00.000 | 1138831 |
3 | Fee Payers | 2024-01-07 00:00:00.000 | 308520 |
4 | Signers | 2024-01-29 00:00:00.000 | 1128726 |
5 | Fee Payers | 2024-01-26 00:00:00.000 | 748485 |
6 | Fee Payers | 2024-01-18 00:00:00.000 | 389642 |
7 | Fee Payers | 2023-12-29 00:00:00.000 | 366142 |
8 | Fee Payers | 2024-01-12 00:00:00.000 | 319924 |
9 | Signers | 2024-01-11 00:00:00.000 | 917086 |
10 | Fee Payers | 2024-01-31 00:00:00.000 | 884691 |
11 | Fee Payers | 2023-12-27 00:00:00.000 | 440495 |
12 | Fee Payers | 2024-01-03 00:00:00.000 | 372168 |
13 | Signers | 2023-12-24 00:00:00.000 | 985911 |
14 | Fee Payers | 2024-02-08 00:00:00.000 | 466558 |
15 | Signers | 2023-12-29 00:00:00.000 | 820708 |
16 | Fee Payers | 2024-02-04 00:00:00.000 | 426454 |
17 | Signers | 2023-12-19 00:00:00.000 | 1071957 |
18 | Signers | 2024-01-23 00:00:00.000 | 932359 |
19 | Signers | 2023-12-16 00:00:00.000 | 1371881 |
20 | Fee Payers | 2024-01-20 00:00:00.000 | 382981 |
LTirrellSolana Signers and Fee Payers
Updated 2024-02-09
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
›
⌄
select
'Signers' as type,
date(block_timestamp) as date,
count(distinct s.value) as wallets
from
solana.core.fact_transactions,
lateral flatten(signers) as s
where
date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
-- and succeeded = TRUE
group by
date
UNION
select
'Fee Payers' as type,
date(block_timestamp) as date,
count(distinct signers[0]) as wallets
from
solana.core.fact_transactions
where
date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
-- and succeeded = TRUE
group by
date
Last run: about 1 year ago
...
122
6KB
339s