select

value:ADDRESS as address

from (

select

live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/b0d8b93a-3da2-488a-a2c5-f465c27dffb0/data/latest') as resp

), lateral flatten (input => resp:data)

),

sybils as (select distinct address,funder, amount, funding, max(nonce) as txs

from (

select address,t.from_address as funder, min_by(value,BLOCK_TIMESTAMP) as amount, min(block_timestamp) as funding

from addresses a

join berachain.testnet.fact_traces t on t.to_address=a.address

group by 1,2

) f

join berachain.testnet.fact_transactions t on t.FROM_ADDRESS=f.address

where amount = 0.001 and (date_trunc('day',funding) = '2024-08-02')

group by 1,2,3,4)

select address,funder, amount as funding_amount, funding as funding_time, txs as txs_amount, (utils.udf_hex_to_int(substr(data,67,64))::int)/1e18 as incentives_amount, l.BLOCK_TIMESTAMP as incentive_tx_time from sybils s

join berachain.testnet.fact_event_logs l on lower(l.ORIGIN_FROM_ADDRESS)=lower(s.address)

where topics[0]='0x8bf110a87db594cedb42356a9ca4b64a0d26fb09909292e842c614823e41d337'

and topics[1]='0x0000000000000000000000000e4aaf1351de4c0264c5c7056ef3777b41bd8e03'

and date_trunc('day',l.BLOCK_TIMESTAMP) = '2024-08-23'