Hessishisolated-coffee
    Updated 2025-02-27
    WITH nft_transfers AS (
    SELECT
    '0x'||SUBSTRING(TOPICS[2], 27) AS from_add,
    '0x'||SUBSTRING(TOPICS[3], 27) AS to_add,
    CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) AS sent_nfts
    FROM monad.testnet.fact_event_logs
    WHERE CONTRACT_ADDRESS = lower('0x51E6da0E284609cD96e3134B12E94b4C4F0cA241')
    AND TOPICS[0] = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
    )

    select holder as address ,
    SUM(incoming) - SUM(outgoing) AS balance
    FROM (
    SELECT to_add AS holder, SUM(sent_nfts) AS incoming, 0 AS outgoing
    FROM nft_transfers
    GROUP BY to_add

    UNION ALL

    SELECT from_add AS holder, 0 AS incoming, SUM(sent_nfts) AS outgoing
    FROM nft_transfers
    GROUP BY from_add
    ) t
    GROUP BY holder
    HAVING SUM(incoming) - SUM(outgoing) > 1
    order by 2 desc

    Last run: 18 days ago
    ADDRESS
    BALANCE
    1
    0xab9de3886cd4eff047db9890ccdc5e984150bc9e29
    2
    0xaf23dc0fee95454f7ebec4f2f047d480e7061ea719
    3
    0x1fafb6ccb7ce36c8eeb8207c5c6b0826cfeab82d13
    4
    0xf89f98425f78ece5e2d2cc719a4230a4de06851110
    5
    0x1af49fc1ea469eb1adeb7b92a42d0cdd150062a010
    6
    0x7c66f2575ca9d164b20a1915dde02b7df7d886ca10
    7
    0x6f4ccf06c7847fa4b8aa68fdafdde6c05fa920789
    8
    0xd69c4bbe50f7393443be7feca02f349dc1002bfd9
    9
    0xdcaa7d59a1fac11b3f8d2c719482d08c3e24600c9
    10
    0xfd710eeb8fe08942f14fae4d0c35d5e02686055a8
    11
    0x4c7f2b2da663722361405955bd2ba94ee3577e9f8
    12
    0x6ec34b4e58a2d9f5bc8ddd964b7b14dcaa35df7d8
    13
    0x86e17ea9debca8c8f7a5b4009f9c37fe8d97f3237
    14
    0xe20f4d419a86111c7b59886c4f1832cd29e8bec87
    15
    0x9f8d845325f7b5941803a0d8cc379848bfab012a7
    16
    0x9521012db7b9be8ae24d6c6561a73e56b6e92b8c7
    17
    0xe0affacc943ad8a45c19306fcf1053b4c103bd486
    18
    0xa810d04d0009e43cdcbd138dbfda5c8d1ca6ea4c6
    19
    0x32758628f7db2eaeac0bf9879e4cd16d875c1c3b6
    20
    0xc67206d602717302beffd3bbc82fc43ecea582936
    ...
    2090
    100KB
    27s