Sbhn_NPspatial-teal
    Updated 2025-01-27
    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