DATE | TYPE | TRANSACTIONS | KET_VOLUME | MINTERS | |
|---|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | Existing Minters | 5 | 42 | 3 |
2 | 2025-03-26 00:00:00.000 | New Minter | 1 | 3 | 1 |
3 | 2025-03-23 00:00:00.000 | Existing Minters | 1 | 2 | 1 |
4 | 2025-03-23 00:00:00.000 | New Minter | 1 | 1 | 1 |
5 | 2025-03-22 00:00:00.000 | New Minter | 2 | 30 | 2 |
6 | 2025-03-22 00:00:00.000 | Existing Minters | 4 | 12 | 2 |
7 | 2025-03-21 00:00:00.000 | New Minter | 1 | 9 | 1 |
8 | 2025-03-21 00:00:00.000 | Existing Minters | 8 | 87 | 3 |
9 | 2025-03-20 00:00:00.000 | Existing Minters | 1 | 2 | 1 |
10 | 2025-03-19 00:00:00.000 | New Minter | 1 | 1 | 1 |
11 | 2025-03-18 00:00:00.000 | New Minter | 2 | 2 | 2 |
12 | 2025-03-18 00:00:00.000 | Existing Minters | 3 | 7 | 2 |
13 | 2025-03-17 00:00:00.000 | New Minter | 3 | 18 | 3 |
14 | 2025-03-17 00:00:00.000 | Existing Minters | 8 | 53 | 6 |
15 | 2025-03-16 00:00:00.000 | Existing Minters | 5 | 90 | 4 |
16 | 2025-03-16 00:00:00.000 | New Minter | 4 | 24 | 4 |
17 | 2025-03-15 00:00:00.000 | Existing Minters | 5 | 18 | 3 |
18 | 2025-03-15 00:00:00.000 | New Minter | 2 | 6 | 2 |
19 | 2025-03-14 00:00:00.000 | New Minter | 8 | 46 | 8 |
20 | 2025-03-14 00:00:00.000 | Existing Minters | 238 | 1549 | 73 |
Ali3NDaily New vs Existing Cooper Minters Over Time (Yellow Ket Orbs)
Updated 15 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
›
⌄
with maintable as (
select decoded_log:minter as minter,
block_timestamp,
tx_hash,
decoded_log:amount as volume,
row_number () over (partition by minter order by block_timestamp asc) as rn
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0xb41b3d801af59b90f69011e67c9a886743536978'
and event_name = 'CopperOrbsMinted'
and contract_address = '0xb41b3d801af59b90f69011e67c9a886743536978'
and origin_function_signature = '0xfd931893'
and tx_succeeded)
select block_timestamp::date as date,
case when rn = '1' then 'New Minter'
else 'Existing Minters' end as type,
count (distinct tx_hash) as Transactions,
sum (volume) as Ket_Volume,
count (distinct minter) as Minters
from maintable
group by 1,2
order by 1 desc
Last run: about 15 hours agoAuto-refreshes every 24 hours
26
1KB
127s