SocioCryptoUntitled Query
    Updated 2022-10-09
    SELECT events.block_timestamp, events.tx_hash, events.origin_to_address AS marketplace,
    events.event_inputs:from AS seller, events.event_inputs:to AS buyer, events.event_inputs:tokenId AS token,
    events.contract_address AS collection, transactions.matic_value AS price, transactions.tx_fee AS fee, labels.project_name
    FROM polygon.core.fact_event_logs events
    LEFT JOIN polygon.core.fact_transactions transactions
    ON events.tx_hash = transactions.tx_hash
    LEFT JOIN polygon.core.dim_labels labels
    ON labels.address = events.contract_address
    WHERE events.event_inputs:tokenId IS NOT NULL AND events.event_name = 'Transfer' AND
    events.tx_status = 'SUCCESS'
    AND events.event_inputs:from <> '0x0000000000000000000000000000000000000000' AND
    events.event_inputs:to <> '0x0000000000000000000000000000000000000000'
    AND transactions.matic_value > 0
    AND events.contract_address = lower('0x2f5b31d2b4891f0ed183d56dd6ebd55249ca1d0c')
    AND events.event_inputs:tokenId = '1040'

    Run a query to Download Data