Sbhn_NPspatial-teal
Updated 2025-01-27
9
1
2
3
4
5
6
7
8
9
›
⌄
select
sum(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0]) / pow(10,18)) as staked,
avg(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0]) / pow(10,18)) as average_staked,
median(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0]) / pow(10,18)) as median_staked,
max(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0]) / pow(10,18)) as maximum_staked
from flow.core_evm.fact_event_logs
where contract_address = '0xfe8189a3016cb6a3668b8ccdac520ce572d4287a'
and topics[0] = '0x3df45cb339f96ae4bdb793efcb6e22100dd0dc4fd739a4ee2033fe67ea35af96'
QueryRunArchived: QueryRun has been archived