kaibladeParas Marketplace Top Ten Sellers
    Updated 2023-03-14

    WITH paras_marketplace_receipts AS
    (SELECT *, TRY_PARSE_JSON(logs[0]) as log
    FROM near.core.fact_receipts
    WHERE receiver_id = 'marketplace.paras.near'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '1 week'

    ORDER BY block_timestamp DESC
    ),

    paras_calls AS
    (SELECT call.*, tx.tx_signer,
    COALESCE
    (call.args:nft_contract_id,
    call.args:market_data.nft_contract_id,
    call.args:offer_data.nft_contract_id,
    log:params.nft_contract_id) AS "NFT Contract ID"

    FROM near.core.fact_actions_events_function_call call
    JOIN near.core.fact_transactions tx
    ON call.tx_hash = tx.tx_hash
    JOIN paras_marketplace_receipts rec
    ON call.tx_hash = rec.tx_hash
    WHERE call.tx_hash IN (SELECT tx_hash FROM paras_marketplace_receipts)
    ),

    create_nft AS
    (SELECT tx_hash, args:token_metadata.copies AS total_minted,
    args:token_metadata.title AS nft_name, split(nft_name,'#')[0] AS collection
    FROM near.core.fact_actions_events_function_call
    WHERE method_name = 'nft_create_series'
    ORDER BY block_timestamp DESC
    ),

    nft_data AS
    (SELECT tx_hash,