nft_data AS (

SELECT *

FROM ethereum.core.ez_nft_transfers

WHERE nft_address ILIKE '0x6C4e530A6F5cEC117Bbd1ed2937584a71c75cA22'

AND nft_to_address ILIKE '0x0000000000000000000000000000000000000000'

ORDER BY 1

),

token_data AS (

SELECT

block_timestamp,

TO_ADDRESS,

tx_json:receipt:logs[0]:decoded:inputs:value AS value,

tx_json:receipt:logs[2]:decoded:inputs:tokenId AS token_id

FROM ethereum.core.fact_transactions

WHERE tx_hash IN (

SELECT tx_hash

FROM ethereum.core.ez_nft_transfers

WHERE nft_address ILIKE '0x6C4e530A6F5cEC117Bbd1ed2937584a71c75cA22'

)

AND block_timestamp::DATE > '2020-06-01'::DATE - 90

AND tx_json:receipt:logs[0]:decoded:inputs:value IS NOT NULL

),

raw_unlock_ETH as

(select BLOCK_TIMESTAMP, EVENT_INPUTS:to as address, TX_HASH, EVENT_INPUTS:value/1e18 as ETH_amount

from ethereum.core.fact_event_logs

where ORIGIN_FUNCTION_SIGNATURE='0xbe5021ec' and CONTRACT_ADDRESS='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

and ORIGIN_TO_ADDRESS='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

),

unlock_ETH as (

select a.BLOCK_TIMESTAMP, a.ADDRESS, a.ETH_AMOUNT as ETH_Unlock, b.ETH_AMOUNT as ETH_Penalty,a.TX_HASH

from raw_unlock_ETH a

left join raw_unlock_ETH b

on a.TX_HASH=b.TX_HASH and b.ADDRESS='0xa45645ebb075a96d1c89511e28d3e9b94f3b7905'

where a.ADDRESS!='0xa45645ebb075a96d1c89511e28d3e9b94f3b7905'),