kaibladeParas Marketplace Total Gross Sales Per Day
    Updated 2023-06-27
    -- forked from 10ee9d9f-489f-40d6-a2c4-2c474b659d03

    -- forked from a371f03d-ccdf-4e58-81cb-1c1aaff87b27

    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 '30 days'

    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
    ),
    Run a query to Download Data