LABEL | USERS | AMOUNTS | |
|---|---|---|---|
1 | 🟢 KAITO GENESIS Holder | 29 | 1994992.94185705 |
2 | 🔴 Not Holder | 96280 | 30019191.4153791 |
freemartianKaito NFT Holders vs not holders
Updated 2 minutes 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 temp_nft_holders AS(
SELECT *, rank() over(partition BY user_address ORDER BY block_timestamp DESC) AS rank
FROM ethereum.core.fact_token_balances
WHERE contract_address = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
and block_timestamp <= '2025-02-17 04:00:00.000' --snapshot timestamp
qualify rank = 1
),
datas as (
select
to_address as user_address,
SUM(amount) as amounts
from base.core.ez_token_transfers
where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'
and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and origin_function_signature = '0x69659658'
-- and tx_hash = '0x86a6bacdce3799c129a3b596a506bb6aa73b1d885e80179f46624fe8fdbda201'
group by 1
),
nft_holders as (
SELECT
user_address,
balance
FROM temp_nft_holders
WHERE balance >=4
-- WHERE balance >0
ORDER BY 2 DESC
),
final as (
select
coalesce(d.user_address,h.user_address) as user,
coalesce(amounts,0) as claimed_amount,
coalesce(balance,0) as nft_balance,
(case when nft_balance > 0 THEN '🟢 KAITO GENESIS Holder'
Last run: 2 minutes agoAuto-refreshes every 1 hour
2
94B
82s