SocioCryptoCopy of Untitled Query
Updated 2022-10-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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