Sbhn_NPtheoretical-green
Updated 2025-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
count(DISTINCT origin_from_address) as depositors,
sum(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0]) / pow(10,18)) AS deposited
from ink.core.fact_event_logs
where topic_0 = '0x90890809c654f11d6e72a28fa60149770a0d11ec6c92319d6ceb2bb0a4ea1a15'
and origin_to_address = '0xcab283e4bb527aa9b157bae7180fef19e2aaa71a'
select *
from ink.core.ez_token_transfers
where tx_hash = '0x2f352ad3298ccff807965a532b7c7cbec44339066e3b9db9286f0c8e049ad73e'
QueryRunArchived: QueryRun has been archived