MLDZMNnfc9
    Updated 2022-10-13
    with tb1 as (select
    distinct BUYER_ADDRESS as sender,
    PROJECT_NAME as NFT
    from optimism.core.ez_nft_sales x left join optimism.core.dim_labels s on x.NFT_ADDRESS=s.ADDRESS
    where PLATFORM_NAME='quixotic'
    and EVENT_TYPE='sale'
    and NFT='optipunk'
    ),

    tb2 as (select
    distinct BUYER_ADDRESS as sender,
    PROJECT_NAME as NFT
    from optimism.core.ez_nft_sales x left join optimism.core.dim_labels s on x.NFT_ADDRESS=s.ADDRESS
    where PLATFORM_NAME='quixotic'
    and EVENT_TYPE='sale'
    and NFT='optimism'
    ),

    tb3 as (select
    distinct BUYER_ADDRESS as sender,
    PROJECT_NAME as NFT
    from optimism.core.ez_nft_sales x left join optimism.core.dim_labels s on x.NFT_ADDRESS=s.ADDRESS
    where PLATFORM_NAME='quixotic'
    and EVENT_TYPE='sale'
    and NFT='bored town'
    ),

    tb4 as (select
    distinct BUYER_ADDRESS as sender,
    PROJECT_NAME as NFT
    from optimism.core.ez_nft_sales x left join optimism.core.dim_labels s on x.NFT_ADDRESS=s.ADDRESS
    where PLATFORM_NAME='quixotic'
    and EVENT_TYPE='sale'
    and NFT='elements of ganland'
    ),

    Run a query to Download Data