piper2023-10-25 02:47 PM
Updated 2023-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
BLOCK_TIMESTAMP,
DECODED_LOG:consideration[0].token AS PROJECT_ADDRESS,
DECODED_LOG:consideration[0].identifier AS TOKENID,
DECODED_LOG:consideration[0].recipient AS NFT_TO_ADDRESS,
DECODED_LOG:recipient AS NFT_FROM_ADDRESS,
ORIGIN_FROM_ADDRESS,
DECODED_LOG:offer[0].amount/pow(10, 18) AS AMOUNT,
DECODED_LOG:offer[0].token AS TOKEN
FROM
polygon.core.ez_decoded_event_logs
WHERE
--TX_HASH = lower('0x4dfb4a11dd77e91f5df8d6f470596072074cb22ba0b1f9d71637ad400139b992') AND
DECODED_LOG:consideration[0].token = lower('0xf3bddcb3719cd02f574c5837d93ebfd2e90cf31c') -- REKT Wolf
AND
CONTRACT_ADDRESS = lower('0x00000000000000adc04c56bf30ac9d3c0aaf14dc')
AND BLOCK_TIMESTAMP > '2023'
Run a query to Download Data