flipside

    exceptional-tomato
    winnie-fsexceptional-tomato
    Updated 2025-01-16
    WITH combined_sales AS (
    SELECT
    'Ethereum' as chain,
    project_name,
    platform_name,
    SUM(price_usd) as total_volume_usd,
    COUNT(*) as number_of_sales,
    AVG(price_usd) as avg_price_usd
    FROM
    ethereum.nft.ez_nft_sales
    WHERE
    block_timestamp >= DATEADD(year, -1, CURRENT_DATE())
    AND price_usd > 0
    GROUP BY
    2,
    3
    UNION
    ALL
    SELECT
    'Polygon' as chain,
    project_name,
    platform_name,
    SUM(price_usd) as total_volume_usd,
    COUNT(*) as number_of_sales,
    AVG(price_usd) as avg_price_usd
    FROM
    polygon.nft.ez_nft_sales
    WHERE
    block_timestamp >= DATEADD(year, -1, CURRENT_DATE())
    AND price_usd > 0
    GROUP BY
    2,
    3
    UNION
    ALL
    SELECT
    Last run: 3 months ago
    Project Name
    Chains
    Total Volume USD
    Total Sales
    Average Sale Price USD
    Trading Platforms
    1
    		PudgyPenguinsEthereum853271946.981709947720.71blur, rarible, sudoswap, x2y2, opensea, magic eden, looksrare
    2
    		BoredApeYachtClubEthereum627040993.331292052763.72blur, opensea, x2y2, sudoswap, looksrare, magic eden, rarible
    3
    		AzukiEthereum426204328.212084519575.95x2y2, opensea, looksrare, element, blur, magic eden
    4
    		MutantApeYachtClubEthereum404672947.58457479561.1uniswap, magic eden, looksrare, x2y2, blur, sudoswap, rarible, opensea
    5
    		CRYPTOPUNKSEthereum381222970.712010146397.17nftx, larva labs
    6
    		LilPudgysPolygon, Arbitru, Ethereum313312021.66593055835.84
    magic eden, sudoswap, nftx, rarible, element, opensea, uniswap, blur, x2...
    7
    		MiladyPolygon, Ethereum250237104.021870913867.23opensea, nftx, looksrare, rarible, x2y2, blur, magic eden
    8
    		DeGodsEthereum, Polygon169857221.18274825858.95sudoswap, x2y2, looksrare, element, blur, magic eden, opensea
    9
    		Liberty CatsPolygon132876224.46133765184.06opensea, element
    10
    		DoodlesEthereum124112376.46134438140.05
    magic eden, element, x2y2, looksrare, rarible, blur, nftx, opensea, sudo...
    11
    		ElementalEthereum103907973.6392303062.22x2y2, opensea, nftx, magic eden, blur, looksrare, element, rarible
    12
    		TEST NFTEthereum96592766.38256543969.65blur, opensea, x2y2, element, sudoswap, magic eden, nftx, looksrare
    13
    		CaptainzEthereum92559644.21832012352.06x2y2, opensea, magic eden, looksrare, blur
    14
    		MoonbirdsEthereum68090834.64220753106.13sudoswap, element, magic eden, x2y2, rarible, looksrare, opensea, blur
    15
    		Art BlocksEthereum58947706.36174119237.75
    magic eden, element, looksrare, nftx, uniswap, x2y2, sudoswap, art block...
    16
    		MocaverseEthereum55211197.01536510546.95looksrare, rarible, opensea, element, blur, magic eden, x2y2
    17
    		Yakuza PandasEthereum, Arbitru, Polygon52993796.28136515037.68looksrare, magic eden, x2y2, blur, opensea
    18
    		CloneXEthereum52801556.24251173082.39opensea, blur, magic eden, x2y2, sudoswap, looksrare
    19
    		MATR1X KUKUPolygon, Ethereum47316785.14119412832.27opensea, blur, magic eden
    20
    		NobodyPolygon, Ethereum43450532.1237377888.95opensea, element, looksrare, x2y2, magic eden, blur
    20
    2KB
    2s