adambalaUntitled Query
    Updated 2022-09-09
    with eth as
    (select
    PRICE as volume ,
    PRICE_USD AS USD,
    NFT_ADDRESS ,
    SELLER_ADDRESS as sellers ,
    BUYER_ADDRESS as buyers ,
    TX_HASH as sale_tx ,
    BLOCK_TIMESTAMP ::date as date ,
    PLATFORM_NAME as platform,
    TOKENID
    from
    ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and
    NFT_ADDRESS=('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
    )
    , eth_metadata as (
    select eth.*,
    TOKEN_METADATA:Background as Backgrounds ,
    TOKEN_METADATA:Clothes as Clothess,
    TOKEN_METADATA:Earring as Earrings,
    TOKEN_METADATA:Eyes as Eyess,
    TOKEN_METADATA:Fur as Furs,
    TOKEN_METADATA:Hat as Hats,
    TOKEN_METADATA:Mouth as Mouths
    from ethereum.core.dim_nft_metadata right join eth on NFT_address = CONTRACT_ADDRESS
    )

    select
    platform ,
    Backgrounds,
    Clothess,
    Earrings,
    Eyess,
    Furs,
    Hats,
    Run a query to Download Data