mawmawblushing-fuchsia
Updated 2024-12-24Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
LiquidityPools_Events as (
SELECT
BLOCK_NUMBER ,
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_INDEX,
CONTRACT_ADDRESS,
CONTRACT_NAME,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
FULL_DECODED_LOG,
DATA,
TOPICS[0] as topic0,
CASE TOPICS[0]::STRING
WHEN '0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c' THEN 'Burn'
WHEN '0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde' THEN 'Mint'
END AS Event_Name
FROM ethereum.core.ez_decoded_event_logs log
WHERE
CONTRACT_ADDRESS = '0xc6962004f452be9203591991d15f6b388e09e8d0'
AND TOPICS[0]::STRING IN (
'0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c', -- Burn
'0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde' -- Mint
)
AND TX_STATUS = 'SUCCESS'
AND EVENT_REMOVED = 'false'
),
NFTpositions_Events as (
SELECT
BLOCK_NUMBER ,
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_INDEX,
CONTRACT_ADDRESS,
QueryRunArchived: QueryRun has been archived