flipside

    contracts and users
    Monad Metrics Guildcontracts and users
    Updated 2025-02-26
    -- by ravel
    WITH contracts AS (
    SELECT address AS contract_address
    FROM monad.testnet.dim_contracts
    )

    -- user_addresses AS (
    SELECT DISTINCT from_address AS user_address
    FROM monad.testnet.fact_transactions
    WHERE from_address NOT IN (SELECT contract_address FROM contracts)
    and block_timestamp >= '2025-02-19 16:00'
    UNION
    SELECT DISTINCT to_address AS user_address
    FROM monad.testnet.fact_transactions
    WHERE to_address NOT IN (SELECT contract_address FROM contracts)
    and block_timestamp >= '2025-02-19 16:00'


    Last run: about 1 month ago
    USER_ADDRESS
    1
    		0xc5d0712544197cd93140f21f02bfcba822eb20bd
    2
    		0xa7924b74c4ab2497c741cfebdb4ded4f4c97747e
    3
    		0xc790cebc55ab70092fb427e6728ca7aa52145cce
    4
    		0xfde64ea340165e6cecb9deb73bacd127482e04fd
    5
    		0x9722b2db62bf2be6aac931d3d6c06ec4b59d747f
    6
    		0x94096a176109888b344eeab8eadd47248d2db79b
    7
    		0xccd11ed84b74c3ad17db9678b0894092fe6cd989
    8
    		0xbfa65dc08942c28b96bc197cc8bec6131cbde4a0
    9
    		0x787e1ece38b190cfd03d287d5eef910ff509a99f
    10
    		0x8b596d47d9c26f48fee1cd4e5d24db38405fb3ea
    11
    		0xadaeed569ebe5a4e611a71d08b7f3f3656a56138
    12
    		0x3d9c317705a2b34fdaf3c04e4a289dd778eb65dc
    13
    		0xb058845a7c8ced07f21fdbbcd2011ca597ae2b0f
    14
    		0xc476ce1875095b5f6790e48d368e129386e8a0f2
    15
    		0xe2f3e7c4acd9b3e59687a5095f5ba0ef28b90709
    16
    		0x9eb3441f9d2f2f557f977bac7b307824c8d5fba5
    17
    		0x993a53a1abc274a655a3c1c6fae1dd58d57861f0
    18
    		0xcf553bdbe9b9bcbcbd72a6dee950ad0736626245
    19
    		0xd522bf5bebb7a0df4763ce359c8d0658b434a587
    20
    		0xc80c39576eb5f4b757626a33dac43d7a091f6a65
    ...
    100000
    4MB
    6s