Total 1 Million Nads tx | Total 1 Million Nads unique receivers | Total 1 Million Nads NFTs distributed | |
|---|---|---|---|
1 | 1370 | 628302 | 682802 |
Mrftiwestern-lime
Updated 18 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with alldata as
(SELECT
block_timestamp,
tx_hash,
'0x' || SUBSTR(topic_2, 27) AS receiver_address,
CAST(ethereum.public.udf_hex_to_int(topic_3) AS decimal) as token_id
FROM monad.testnet.fact_event_logs
WHERE CONTRACT_ADDRESS = '0x922da3512e2bebbe32bcce59adf7e6759fb8cea2'
and ORIGIN_FROM_ADDRESS = '0xa90970ccc3dd07dda3224fc4839230851f035788'
AND TX_SUCCEEDED = 'TRUE'
and topic_3 is not null
)
select
count (distinct tx_hash) AS "Total 1 Million Nads tx",
count (distinct receiver_address) as "Total 1 Million Nads unique receivers" ,
count (distinct token_id) as "Total 1 Million Nads NFTs distributed"
from alldata
Last run: about 18 hours agoAuto-refreshes every 12 hours
1
22B
143s