m3jiytterbic-pink copy
    Updated 8 days ago
    -- forked from ytterbic-pink @ https://flipsidecrypto.xyz/studio/queries/14f7b56a-12b5-4344-b30a-5b0515915895

    SELECT
    -- l.LABEL_TYPE,
    COUNT(*) AS new_contracts,
    COUNT(DISTINCT c.CREATED_TX_HASH) AS ca_creation_txn,
    COUNT(DISTINCT c.CREATOR_ADDRESS) AS ca_creators
    FROM ink.core.dim_contracts c
    LEFT JOIN ink.core.dim_labels l
    ON c.ADDRESS = l.ADDRESS
    WHERE c.CREATED_BLOCK_TIMESTAMP::DATE >= '2024-12-09'
    ;


    Last run: 8 days ago
    NEW_CONTRACTS
    CA_CREATION_TXN
    CA_CREATORS
    1
    17728417607264863
    1
    23B
    2s