thea[NFT Marketplace Mega] Top NFT collection
    Updated 2023-04-13
    with nft as (
    select platform_name,
    nft_address,
    case
    when nft_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers'
    when nft_address = '0x05da517b1bf9999b7762eaefa8372341a1a47559' then 'Keepers'
    when nft_address = '0x7fda36c8daedcc55b73e964c2831d6161ef60a75' then 'Yaypegs'
    when nft_address = '0x942bc2d3e7a589fe5bd4a5c6ef9727dfd82f5c8a' then 'Art Blocks Explorations'
    when nft_address = '0x6f4388602c5dd6c593bf7c9cf3128aaa2a3e09ce' then 'Tickle'
    when nft_address = '0xe1d7a7c25d6bacd2af454a7e863e7b611248c3e5' then 'JUUNI Grimoire'
    when nft_address = '0x9251dec8df720c2adf3b6f46d968107cbbadf4d4' then '1337 skulls'
    when nft_address = '0x0a8d311b99ddaa9ebb45fd606eb0a1533004f26b' then 'ETH GOBBLERS'
    when nft_address = '0xf442459c8bb4b891b789e816775232b812eb2ccd' then 'Porkers'
    when nft_address = '0x7df64f69544c5bf71171dc5ab69b8602c2ff1e27' then 'Kitaro World'
    when nft_address = '0xbd5fb504d4482ef4366dfa0c0edfb85ed50a9bbb' then 'CornTown'
    when nft_address = '0xaaa7a35e442a77e37cde2f445b359aabf5ad0387' then 'StreetMachine'
    when nft_address = '0xa5d37c0364b9e6d96ee37e03964e7ad2b33a93f4' then 'CATGIRL ACADEMIA'
    when nft_address = '0x2ee6af0dff3a1ce3f7e3414c52c48fd50d73691e' then 'Bored Ape Yacht Club'
    when nft_address = '0x8d94b8ea78a51d783a413c73811511c900c8f365' then 'SudoWassie'
    when nft_address = '0xf10a71e53398bf4e3cf5e2a0cad3c529ad19b834' then 'Floaties'
    when nft_address = '0x1cef785aa885836cee4f53b6ace83d187d819639' then 'Wheyfus anonymous :3'
    when nft_address = '0x65784d6f23de30a17122e96c0f0986c378ed6947' then 'Bored Ape Yoga Club'
    when nft_address = '0xcb88735a1eae17ff2a2abaec1ba03d877f4bc055' then 'PHAYC'
    when nft_address = '0xb7d405bee01c70a9577316c1b9c2505f146e8842' then 'V3 Phunks (V3PHUNKS)'
    else project_name end as project_name,
    count(distinct tx_hash) as sales_count,
    sum(price_usd) as sales_volume
    from ethereum.core.ez_nft_sales
    where price_usd is not null
    and platform_name in ('opensea', 'sudoswap', 'rarible', 'looksrare', 'x2y2', 'nftx', 'blur')
    group by 1, 2, 3
    )

    select *
    from (
    select platform_name,
    Run a query to Download Data