PERIOD | Number of minted domains | Number of minter addresses | # of minted domains | MINTERS | |
---|---|---|---|---|---|
1 | All time | 6,431 | 6,227 | 6431 | 6227 |
2 | Last 7 days | 3,371 | 3,347 | 3371 | 3347 |
3 | Last 24 hours | 278 | 276 | 278 | 276 |
4 | Last 6 hours | 21 | 21 | 21 | 21 |
5 | Last 1 hour | 1 | 1 | 1 | 1 |
Hessishzink - mints tot
Updated 22 hours 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
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with all_txs as (SELECT BLOCK_TIMESTAMP ,
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'
),
final as (select
count(distinct mints) as "# of minted domains", count(distinct minter) as minters, 'All time' as period
from all_txs
--union
--select
-- count(distinct mints) as "# of minted domains", count(distinct minter) as minters,'Last 30 days' as period
--from all_txs
--WHERE BLOCK_TIMESTAMP >= current_timestamp - INTERVAL '30 day'
--group by 3
union
select
count(distinct mints) as "# of minted domains", count(distinct minter) as minters,'Last 7 days' as period
from all_txs
WHERE BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '7 day'
group by 3
union
Last run: about 22 hours agoAuto-refreshes every 24 hours
5
309B
2s