flipside

    compare trend copy
    damidezcompare trend copy
    Updated 2025-03-04
    --Monadverse chapter 1
    SELECT 'Monadverse' AS NFT_type,
    DATE_TRUNC('day', e.Block_timestamp) AS minted_date,
    COUNT(DISTINCT e.tx_hash) AS total_nfts_minted,
    COUNT(DISTINCT e.origin_from_address) AS minter,
    FROM monad.testnet.fact_event_logs e
    WHERE e.contract_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e'
    AND e.origin_to_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e'
    AND e.topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
    AND e.tx_succeeded = 1
    GROUP BY minted_date

    UNION ALL
    --Chogstar
    SELECT 'Chogstar' AS NFT_type,
    DATE_TRUNC('day', block_timestamp) AS minted_date,
    COUNT(tx_hash) AS total_nfts_minted,
    COUNT(DISTINCT origin_from_address) AS minter
    FROM monad.testnet.fact_event_logs
    WHERE origin_to_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4'
    AND contract_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4'
    AND topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    AND tx_succeeded = 1
    AND block_timestamp >= '2025-02-19 03:52:15'
    GROUP BY minted_date

    UNION ALL

    --emmy
    SELECT 'EMMY ON MONAD!' AS NFT_type,
    DATE_TRUNC('day', block_timestamp) AS minted_date,
    COUNT(tx_hash) AS total_nfts_minted,
    COUNT(DISTINCT origin_from_address) AS minter
    FROM monad.testnet.fact_event_logs
    WHERE origin_to_address = '0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba'
    AND contract_address = '0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba'
    Last run: about 1 month ago
    NFT_TYPE
    MINTED_DATE
    TOTAL_NFTS_MINTED
    MINTER
    1
    		Chogstar2025-03-04 00:00:00.0002611924802
    2
    		EMMY ON MONAD!2025-03-04 00:00:00.000181180
    3
    		Monadverse2025-03-04 00:00:00.00022
    4
    		Chogstar2025-03-03 00:00:00.0006300452668
    5
    		Monadverse2025-03-03 00:00:00.00088
    6
    		EMMY ON MONAD!2025-03-03 00:00:00.000213212
    7
    		Monadverse2025-03-02 00:00:00.00022
    8
    		Chogstar2025-03-02 00:00:00.000152273114939
    9
    		EMMY ON MONAD!2025-03-02 00:00:00.000258256
    10
    		Monadverse2025-03-01 00:00:00.00055
    11
    		Chogstar2025-03-01 00:00:00.000148492107290
    12
    		EMMY ON MONAD!2025-03-01 00:00:00.000262262
    13
    		Monadverse2025-02-28 00:00:00.00044
    14
    		EMMY ON MONAD!2025-02-28 00:00:00.000714677
    15
    		Chogstar2025-02-28 00:00:00.00011635786812
    16
    		Monadverse2025-02-27 00:00:00.0001414
    17
    		EMMY ON MONAD!2025-02-27 00:00:00.000438435
    18
    		Chogstar2025-02-27 00:00:00.000159302107035
    19
    		Chogstar2025-02-26 00:00:00.000477289306131
    20
    		EMMY ON MONAD!2025-02-26 00:00:00.000351520350870
    42
    2KB
    96s