purifsocial-black
    Updated 2024-11-23
    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