HOUR | Total 1 Million Nads tx | Total 1 Million Nads unique receivers | Total 1 Million Nads NFTs distributed | |
|---|---|---|---|---|
1 | 2025-03-30 01:00:00.000 | 771 | 385355 | 385355 |
2 | 2025-03-30 17:00:00.000 | 2 | 2 | 2 |
3 | 2025-04-02 15:00:00.000 | 2 | 654 | 654 |
4 | 2025-04-01 19:00:00.000 | 1 | 5 | 5 |
5 | 2025-03-29 00:00:00.000 | 109 | 54321 | 54500 |
6 | 2025-03-29 01:00:00.000 | 485 | 242286 | 242286 |
Mrftiwestern-lime copy
Updated 20 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
›
⌄
-- forked from western-lime @ https://flipsidecrypto.xyz/studio/queries/b8f71946-3084-4274-8796-d2816464ed8f
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
date_trunc (hour, block_timestamp) as hour,
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
group by 1
Last run: about 20 hours agoAuto-refreshes every 12 hours
6
243B
135s