DATE | # of minted domains | Cumulative mints | Minters | |
|---|---|---|---|---|
1 | 2024-12-18 00:00:00.000 | 54 | 54 | 38 |
2 | 2024-12-19 00:00:00.000 | 142 | 196 | 99 |
3 | 2024-12-20 00:00:00.000 | 159 | 355 | 132 |
4 | 2024-12-21 00:00:00.000 | 54 | 409 | 52 |
5 | 2024-12-22 00:00:00.000 | 114 | 523 | 97 |
6 | 2024-12-23 00:00:00.000 | 479 | 1002 | 475 |
7 | 2024-12-24 00:00:00.000 | 668 | 1670 | 629 |
8 | 2024-12-25 00:00:00.000 | 446 | 2116 | 444 |
9 | 2024-12-26 00:00:00.000 | 840 | 2956 | 827 |
10 | 2024-12-27 00:00:00.000 | 419 | 3375 | 408 |
11 | 2024-12-28 00:00:00.000 | 1015 | 4390 | 1012 |
12 | 2024-12-29 00:00:00.000 | 676 | 5066 | 675 |
13 | 2024-12-30 00:00:00.000 | 456 | 5522 | 456 |
14 | 2024-12-31 00:00:00.000 | 347 | 5869 | 343 |
15 | 2025-01-01 00:00:00.000 | 224 | 6093 | 223 |
16 | 2025-01-02 00:00:00.000 | 312 | 6405 | 310 |
17 | 2025-01-03 00:00:00.000 | 226 | 6631 | 226 |
18 | 2025-01-04 00:00:00.000 | 249 | 6880 | 248 |
19 | 2025-01-05 00:00:00.000 | 284 | 7164 | 276 |
20 | 2025-01-06 00:00:00.000 | 207 | 7371 | 206 |
Hessishzink - mints
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT BLOCK_TIMESTAMP::date as date,
count(DISTINCT topics[3]) as "# of minted domains",
sum("# of minted domains") over (order by date) as "Cumulative mints",
count(DISTINCT topics[2]) as "Minters"
from ink.core.fact_event_logs
WHERE
CONTRACT_ADDRESS = lower('0xFb2Cd41a8aeC89EFBb19575C6c48d872cE97A0A5') and
TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and ORIGIN_FUNCTION_SIGNATURE = '0x3a99d4eb'
and TX_SUCCEEDED = 'TRUE'
group by all
order by 1
Last run: 7 days ago
...
121
5KB
22s