permaryTransaction Activity Breakdown
    Updated 2025-03-07
    SELECT
    'Card Upgrades' AS activity, COUNT(*) AS total_events
    FROM monad.testnet.fact_event_logs
    WHERE topic_0 = LOWER('0xb896ef750ff1f78e491078417b01c8e59749b5eaa5d5531af12b01c7571a7f06')
    AND contract_address = LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a')

    UNION ALL

    SELECT
    'Card Burns' AS activity, COUNT(*) AS total_events
    FROM monad.testnet.fact_event_logs
    WHERE origin_function_signature = '0x7bad2380'
    AND contract_address = LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a')

    UNION ALL

    SELECT
    'Bids Accepted' AS activity, COUNT(*) AS total_events
    FROM monad.testnet.fact_event_logs
    WHERE topic_0 = '0xd787cf372c9f960b5be92b833473c375b88b8ed771eb0430c148dd0d5394ae49'
    AND contract_address = LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')

    UNION ALL

    SELECT
    'Total Listings' AS activity, COUNT(*)
    FROM monad.testnet.fact_event_logs
    WHERE topic_0 = '0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31'
    AND contract_address = LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e')


    UNION ALL

    SELECT
    'Total Cancelled Listings' AS activity, COUNT(*)
    FROM monad.testnet.fact_event_logs
    Last run: about 2 months ago
    ACTIVITY
    TOTAL_EVENTS
    1
    Card Upgrades14789
    2
    Card Burns4737
    3
    Bids Accepted36516
    4
    Total Listings514653
    5
    Total Cancelled Listings155661
    6
    Card Mints749102
    7
    Cards bought1249788
    8
    Other11661801
    8
    197B
    10s