freemartianTotal Infractions
    Updated 2024-12-08
    SELECT
    count(tx_hash) AS transactions,
    count(DISTINCT sender) AS users,
    -- count(DISTINCT event_data:account_addr) AS users
    -- FROM aptos.core.fact_events
    FROM aptos.core.fact_transactions
    WHERE split_part(payload_function,'::',1) = '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba'
    -- WHERE event_type IN
    -- (
    -- '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::BorrowEvent'
    -- ,
    -- '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::RepayEvent'
    -- ,
    -- '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::SupplyEvent'
    -- ,
    -- '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::WithdrawEvent'
    -- )



    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived