ADDRESSES | TYPE | |
|---|---|---|
1 | 41799 | .INK domain minters |
2 | 312137 | Other addresses |
Hessishzink - pup
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with all_txs as (SELECT BLOCK_TIMESTAMP ,
ORIGIN_FROM_ADDRESS,
topics[3] as mints,
topics[2] as minter,
from ink.core.fact_event_logs
WHERE
CONTRACT_ADDRESS = lower('0xFb2Cd41a8aeC89EFBb19575C6c48d872cE97A0A5') and
TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and ORIGIN_FUNCTION_SIGNATURE = '0x3a99d4eb'
and TX_SUCCEEDED = 'TRUE'
)
SELECT count(DISTINCT FROM_ADDRESS) as addresses,
case when FROM_ADDRESS in (SELECT DISTINCT
ORIGIN_FROM_ADDRESS from all_txs)
then '.INK domain minters' else 'Other addresses' end as type
from ink.core.fact_transactions
group by all
Last run: 9 days ago
2
58B
45s