purifYeet testnet v2 - Rounds winners
Updated 2025-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from Yeet testnet v2 - Rounds details @ https://flipsidecrypto.xyz/studio/queries/975126ec-ac8e-4036-a9c2-18c56b374a6f
with data as (select concat('0x',substr(TOPICS[1], 27,64)) as address,
utils.udf_hex_to_int(substr(substr(data, 0,66),3,66)) as timestamp,
(utils.udf_hex_to_int(substr(data,67,64))::int)/1e18 as amount,
utils.udf_hex_to_int(substr(data,131,64))::int as yeet_round
from berachain.testnet.fact_event_logs
where ORIGIN_TO_ADDRESS=LOWER('0x14D65204c710997F595F4663f0451b66d3532f53')
and topics[0]='0xbe0f98aab962877c772f677dbabb9cff90511ac98b11ba9840a146eac347f192'
and ORIGIN_FUNCTION_SIGNATURE='0x056f3575'
)
select address, amount,sum(amount) over (order by yeet_round) as cumulative_wins, yeet_round from data
order by yeet_round desc
QueryRunArchived: QueryRun has been archived