purifYeet testnet v2 - Yeetards
Updated 2025-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with data as (select tx_hash,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 pot_before,
(utils.udf_hex_to_int(substr(data,131,64))::int)/1e18 as pot_after,
utils.udf_hex_to_int(substr(data,323,64))::int as yeet_count,
utils.udf_hex_to_int(substr(data,387,64))::int as yeet_round,
from berachain.testnet.fact_event_logs
where ORIGIN_TO_ADDRESS=LOWER('0x14D65204c710997F595F4663f0451b66d3532f53')
and ORIGIN_FUNCTION_SIGNATURE='0x8bbefe4b'
and topics[0]='0x67e0e8435cacda8ca6cf3a8f63b166cdb95dc96e7d1c6e068009b117d47e1ac6'
order by block_timestamp)
select address, sum(pot_after-pot_before) as yeet_amount
from data
group by 1 having(sum(pot_after-pot_before)) >=1
order by 2 desc
QueryRunArchived: QueryRun has been archived