AMOUNT | USERS | |
|---|---|---|
1 | 133816538257.9247 | 389252 |
Hessishlbt mint
Updated 12 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with claims as (select '0x'||SUBSTRING(topics[2], 27) as user_add,
CAST(ethereum.public.udf_hex_to_int( data) AS NUMERIC) / 1e6 AS amount,
tx_hash,
BLOCK_TIMESTAMP
from monad.testnet.fact_event_logs
where --tx_hash = '0xbadd53f0b3817d82fb5ddf01df8165bc2c1946944708e28d597e5c7fc0df4cf2' --and
ORIGIN_FUNCTION_SIGNATURE = '0x40c10f19'
and CONTRACT_ADDRESS = '0xbf7a88acbb8cf66b72af6c399569e37ee4d5195f'
and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000')
select sum(amount) as amount, count(distinct user_add) as users
from claims
Last run: about 12 hours ago
1
28B
68s