purifsocial-black
Updated 2024-11-23
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with settled as(
SELECT
count(distinct ORIGIN_FROM_ADDRESS)
FROM
berachain.testnet.fact_event_logs t
WHERE
contract_address = lower('0x95fa5e857E90237215C4522723B7069D42eb83EB')
and topics [0] = '0x1159164c56f277e6fc99c11731bd380e0347deb969b75523398734c252706ea3' --AuctionSettled event
)
--
select * from settled
QueryRunArchived: QueryRun has been archived