purifYeet testnet v2 - Rounds winners
    Updated 2025-01-08
    -- 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