purifYeet testnet v2 - Stakers BERA claim
Updated 2025-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with claim_data as (select block_timestamp, concat('0x',substr(TOPICS[1], 27,64)) as address,
(utils.udf_hex_to_int(substr(data,0,66))::int)/1e18 as amount
from berachain.testnet.fact_event_logs
where ORIGIN_TO_ADDRESS=LOWER('0xd98c56EBbb46aA3a85Cc488c6b24E0d486624D9F')
and topics[0]='0xd8138f8a3f377c5259ca548e70e4c2de94f129f5a11036a15b69513cba2b426a'
and ORIGIN_FUNCTION_SIGNATURE='0x4e71d92d'
order by 1 desc
)
select address, amount, sum(amount) over (order by amount) from
(
select address, sum(amount) as amount from claim_data
group by 1
order by 2 desc
)
where amount >= 0.01
order by amount desc
QueryRunArchived: QueryRun has been archived