m3jiprotestant-maroon
    Updated 6 days ago
    WITH contract_activity AS (
    SELECT
    DISTINCT CONTRACT_ADDRESS AS contract,
    -- event_name,
    contract_name,
    COUNT(*) AS tx_count,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_users,
    MIN(block_timestamp) AS first_seen,
    MAX(block_timestamp) AS last_seen
    FROM ink.core.ez_decoded_event_logs
    Where contract_name IS NOT NULL
    GROUP BY 1,2
    )
    SELECT
    ca.contract,
    -- ca.event_name,
    ca.contract_name,
    dl.label AS project_name,
    ca.tx_count,
    ca.unique_users,
    ca.first_seen,
    ca.last_seen
    FROM contract_activity ca
    LEFT JOIN ink.core.dim_labels dl ON ca.contract = dl.address
    ORDER BY ca.tx_count DESC
    LIMIT 20;
    Last run: 6 days ago
    CONTRACT
    CONTRACT_NAME
    PROJECT_NAME
    TX_COUNT
    UNIQUE_USERS
    FIRST_SEEN
    LAST_SEEN
    1
    0x4200000000000000000000000000000000000006Wrapped Etherwrapped ether28440301231172024-12-13 12:21:34.0002025-03-09 05:37:01.000
    2
    0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7Layer3 CUBElayer3 cube965903349612025-01-16 00:32:11.0002025-03-09 05:36:50.000
    3
    0x0200c29006150606b650577bbe7b6248f58470c1USD₮0usd₮0475585349092025-01-16 23:31:41.0002025-03-09 05:36:32.000
    4
    0x9234d821c10b72e09c594f882f1d5dacf2621006Eye of the Seeker229623257352025-01-27 17:41:40.0002025-03-09 05:30:35.000
    5
    0x776df03a2d5a1baec99181694f831d930205b811Uniswap V2229377230542025-01-31 14:13:28.0002025-03-09 05:35:22.000
    6
    0xfb2cd41a8aec89efbb19575c6c48d872ce97a0a5ZNS Connectzns connect204892397652024-12-10 12:21:51.0002025-03-09 05:35:00.000
    7
    0xcab283e4bb527aa9b157bae7180fef19e2aaa71aRebasing Ink Staked ETHrebasing ink staked eth189922336652024-12-18 04:24:37.0002025-03-09 05:36:53.000
    8
    0x11476323d8dfcbafac942588e2f38823d2dd308eInk Staked ETHink staked eth187999324212025-01-13 23:03:10.0002025-03-09 05:37:01.000
    9
    0x685e46328d8eea70a2d60e51a14e3443ab2882bcVolatileV2 AMM - iETH/WETH170961246282025-01-22 14:08:50.0002025-03-09 05:34:30.000
    10
    0x44c497597aa32f5f2b7edb91522f321f04f03cd7GMINKY1588063792025-02-18 20:06:29.0002025-03-09 05:34:56.000
    11
    0x991d5546c4b442b4c5fdc4c8b8b8d131deb24702Slipstream Position NFT v1.2slipstream position nft v1.2111477122532025-01-15 03:26:57.0002025-03-09 05:34:01.000
    12
    0x05407d2bcef84ebaedd54dba1c0a868e1686caa7Uniswap V2inkyswap95963204152025-01-16 15:47:49.0002025-03-09 05:21:58.000
    13
    0xeaac4a3d63649a2c82433b3e2ad972cc6ba51d13Uniswap V2inkyswap80945173202025-01-05 18:00:23.0002025-03-09 05:06:30.000
    14
    0xc0836e5b058bbe22ae2266e1ac488a1a0fd8dce8Uniswap V3 Positions NFT-V1uniswap v3 positions nft-v175352284162024-12-13 12:51:39.0002025-03-09 05:17:32.000
    15
    0xca5f2ccbd9c40b32657df57c716de44237f80f05Krakenkraken7222983492024-12-17 10:07:31.0002025-03-09 05:12:33.000
    16
    0xba7eb02284c42c0645ea5b49d571c56211bad8ffIonic Wrapped Etherionic wrapped ether6307180052024-12-19 12:29:38.0002025-03-09 03:49:33.000
    17
    0x07e32d00f3b624044ca5bfca320f72bf851bec7dUniswap V2inkyswap55100116022025-01-07 07:50:19.0002025-03-09 05:11:57.000
    18
    0x46c87b2b61c12fbe972c64131861cc44bf8e80b6Uniswap V251820118612025-01-27 13:36:36.0002025-03-09 05:13:20.000
    19
    0x578accaf5d5306edcdf1cd365b99b7669a8a858bUniswap V2inkyswap47274116942024-12-26 20:54:04.0002025-03-09 05:12:33.000
    20
    0x9c883960f514e8ca1772b923edef112e1fa9aedeUniswap V241165117472025-01-27 18:31:15.0002025-03-09 05:21:36.000
    20
    3KB
    2s