Sandeshopensea deals returning users
    Updated 2023-08-30

    with
    nft_transactions as (
    select
    *
    from
    ethereum.core.ez_nft_transfers
    where
    block_timestamp::date > '2023-07-09 00:00:00.000'
    ),
    nft_swaps as (
    select distinct
    sender_nft.tx_hash
    from
    nft_transactions sender_nft
    inner join nft_transactions rec_nft on sender_nft.tx_hash = rec_nft.tx_hash
    and sender_nft.nft_from_address = rec_nft.nft_to_address
    where
    sender_nft.nft_from_address != '0x0000000000000000000000000000000000000000'
    and rec_nft.nft_from_address != '0x0000000000000000000000000000000000000000'
    and sender_nft.nft_to_address != '0x0000000000000000000000000000000000000000'
    and rec_nft.nft_to_address != '0x0000000000000000000000000000000000000000'
    ),
    deals as (
    select
    ft.*,tr.nft_address,tr.project_name,tr.tokenid
    from
    ethereum.core.fact_transactions ft
    inner join
    ethereum.core.ez_nft_transfers tr
    on ft.tx_hash=tr.tx_hash
    where
    1 = 1
    and ft.to_address = '0x00000000000000adc04c56bf30ac9d3c0aaf14dc'
    and ft.tx_hash in (
    select
    Run a query to Download Data