gigiokobaflying-cyan
    Updated 2025-02-23
    WITH nft_transfers AS (
    SELECT
    ft.block_timestamp,
    ft.tx_hash,
    ft.from_address,
    ft.to_address,
    ft.value as payment_amount,
    el.contract_address as nft_contract,
    dc.name as collection_name
    FROM monad.testnet.fact_transactions ft
    JOIN monad.testnet.fact_event_logs el
    ON ft.tx_hash = el.tx_hash
    LEFT JOIN monad.testnet.dim_contracts dc
    ON el.contract_address = dc.address
    WHERE el.topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer event signature
    AND ft.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    AND ft.tx_succeeded = true
    AND ft.value > 0 -- Only include transfers with payment
    )

    SELECT
    collection_name,
    nft_contract,
    COUNT(*) as number_of_sales,
    SUM(payment_amount) as total_volume,
    AVG(payment_amount) as avg_sale_price
    FROM nft_transfers
    GROUP BY 1, 2
    ORDER BY total_volume DESC;
    Last run: 22 days ago
    COLLECTION_NAME
    NFT_CONTRACT
    NUMBER_OF_SALES
    TOTAL_VOLUME
    AVG_SALE_PRICE
    1
    0x760afe86e5de5fa0ee542fc7b7b713e1c542570192345526957224.815120729.191703781
    2
    0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb374610112788755.4236555277.407332241
    3
    0xcf5a6076cfa32686c0df13abada2b40dec133f1d917210038609.10047391094.484201971
    4
    0x132cb626be0dd6eb3b53fbeb392838c7a7b936212510009688.1631398400387.526525594
    5
    0x76a61e9953de35ccbcb383f82f42fb1b1f2560797100016331428804.71428571
    6
    0x2503b64954478af06674184239aea4cc99de7c04119148313441.312697.78758704
    7
    0xf817257fed379853cde0fa4f97ab987181b1e5ea1300447330213.5221725656.36717974
    8
    0xdf702217524fbdfdf5458830ab522cb9fdd94cfb583561932101061.389888603
    9
    0x9c138479bc0423df993fc4f246fd1d7d598712de87435438957.29622.092793092
    10
    0xff72ac3b7da415f9a97e3bebf11e1d5891d211fa115675015226.46433.580570589
    11
    0xba12d525b8165943ddc529ed4127f648a3d1b47e233333341666667
    12
    0x3bb9afb94c82752e47706a10779ea525cf95dc273653263166005.242869868.666246703
    13
    0xc7a47a51e830a319ec0855b82ae3945a61392085119082672457.0909224.42535194
    14
    ETH0x836047a99e11f376522b447bffb6e3495dd0637c169212387507.48734376141.097304376
    15
    0xbdf43886b633600733932d6db54735b0ce15546856362259032400.821859475
    16
    0x73a58b73018c1a417534232529b57b99132b13d224602001664.20192232813.684634928
    17
    0x672692a49c3567cc4d2f0890555291935d6674d3220000001000000
    18
    0xc32e6fd62910b0b39c774079019b56ecb8504e4465051895908.43291.454024596
    19
    0x6aba96f37f1fa7c699b45d76822e7457f888f8f289901455301.83161.880070078
    20
    0xccec303083ad2d42346a7316cde6556e7b3e7cdb227841247320.2748554.745447457
    ...
    60206
    4MB
    9s