Updated 2023-03-30
    ----------total top project
    WITH
    ETH AS (
    SELECT
    ct.name,
    ct.symbol,
    ct.address,
    CASE
    WHEN ADDRESS = '0x495f947276749ce646f68ac8c248420045cb7b5e' THEN 'OpenSea Shared Storefront'
    WHEN ADDRESS = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' THEN 'Art Blocks'
    WHEN ADDRESS = '0x76be3b62873462d2142405439777e971754e8e77' THEN 'parallel'
    WHEN ADDRESS = '0xd07dc4262bcdbf85190c01c996b4c06a461d2430' THEN 'Rarible'
    WHEN ADDRESS = '0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2' THEN 'Optimism quest SBT'
    WHEN ADDRESS = '0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258' THEN 'Otherdeed'
    WHEN ADDRESS = '0xba6666b118f8303f990f3519df07e160227cce87' THEN 'Planet IX - Assets'
    WHEN ADDRESS = '0x6c97ef47d60b35f858ad04c4b4f649747e00a417' THEN 'Galxe Holiday 2022'
    WHEN ADDRESS = '0x6339e5e072086621540d0362c4e3cea0d643e114' THEN 'Opepen Edition'
    WHEN ADDRESS = '0x2953399124f0cbb46d2cbacd8a89cf0599974963' THEN 'OpenSea Collections'
    WHEN ADDRESS = '0x60e4d786628fea6478f785a6d7e704777c86a7c6' THEN 'MutantApeYachtClub'
    WHEN ADDRESS = '0x81b30ff521d1feb67ede32db726d95714eb00637' THEN 'Optimistic Explorer'
    WHEN ADDRESS = '0x74a002d13f5f8af7f9a971f006b9a46c9b31dabd' THEN 'RabbitHole L2 Explorer'
    WHEN ADDRESS = '0xa95579592078783b409803ddc75bb402c217a924' THEN 'Introducing the Optimism Collect'
    WHEN ADDRESS = '0x0110bb5739a6f82eafc748418e572fc67d854a0f' THEN 'Early Optimists'
    WHEN ADDRESS = '0xdb46d1dc155634fbc732f92e853b10b288ad5a1d' THEN 'Lens Protocol Profiles'
    WHEN ADDRESS = '0x200fb6e28edf0fbc9b5fabf7d39ae583981f5038' THEN 'Layer3'
    WHEN ADDRESS = '0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f' THEN 'Unstoppable Domains'
    WHEN ADDRESS = '0x24a11e702cd90f034ea44faf1e180c0c654ac5d9' THEN 'Trump Digital Trading Cards'
    WHEN ADDRESS = '0x719c595e9593f361290ea57c7c357bec847dd80b' THEN 'NFT1'
    WHEN ADDRESS = '0xc36442b4a4522e871399cd717abdd847ab11fe88' THEN 'Uniswap V3 Positions NFT-V1'
    WHEN ADDRESS = '0x9b9f542456ad12796ccb8eb6644f29e3314e68e1' THEN 'OptiChads'
    WHEN ADDRESS = '0xac3b9b3f5956b52c448158c0a07ddfa9d5c53a3b' THEN 'OP Delegatooors'
    WHEN ADDRESS = '0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26' THEN 'veNFT'
    WHEN address = '0x6339e5e072086621540d0362c4e3cea0d643e114' THEN 'Open Edition'
    WHEN address = '0x34eebee6942d8def3c125458d1a86e0a897fd6f9' THEN 'Checks'
    WHEN address = '0xbd8451d2d5fb88469a764b05c1e0b623c5106145' THEN 'MERGE'