SocioCryptoCopy of Untitled Query
    Updated 2022-10-17
    SELECT date_trunc('day', events.block_timestamp) as date, 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 AS project_name
    FROM polygon.core.fact_event_logs events
    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('0x05df72d911e52ab122f7d9955728bc96a718782c')
    Run a query to Download Data