NavidCopy of Copy of Copy of Untitled Query
    Updated 2022-11-07
    with collection_mints as (
    select
    case
    when NFT_ADDRESS='0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers'
    when NFT_ADDRESS='0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' then 'CryptoPunks'
    when NFT_ADDRESS='0xe4d20bc4a845aa35b008f5f9f85e50b581df7263' then 'HUGO x Imaginary Ones'
    when NFT_ADDRESS='0xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' then 'Zora'
    when NFT_ADDRESS='0x60e4d786628fea6478f785a6d7e704777c86a7c6' then 'Mutant Ape Yacht Club'
    when NFT_ADDRESS='0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7' then 'Meebits'
    when NFT_ADDRESS='0xdcb8d9a2a65a006fafeec5695e288b711762d3e4' then 'HEXGO'
    when NFT_ADDRESS='0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' then 'Bored Ape Yacht Club'
    when NFT_ADDRESS='0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b' then 'CLONE X - X TAKASHI MURAKAMI'
    when NFT_ADDRESS='0xb9e5717e6d547ebaad8b8b34fcd990bd007168a7' then 'Jack Atomy'
    end as collection,
    MINT_PRICE_ETH,
    MINT_PRICE_USD,
    tx_hash
    from
    ethereum.core.ez_nft_mints
    where
    NFT_ADDRESS in (
    '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769',
    '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb',
    '0xe4d20bc4a845aa35b008f5f9f85e50b581df7263',
    '0xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7',
    '0x60e4d786628fea6478f785a6d7e704777c86a7c6',
    '0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7',
    '0xdcb8d9a2a65a006fafeec5695e288b711762d3e4',
    '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d',
    '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b',
    '0xb9e5717e6d547ebaad8b8b34fcd990bd007168a7'
    ) and
    block_timestamp > CURRENT_DATE-7
    )
    select
    collection,
    Run a query to Download Data