dannerUntitled Query
    Updated 2022-07-29
    SELECT
    platform_name,
    CASE
    WHEN nft_address = '0x9d5407c08febe35f3a747da422dc2da45ca30b61' THEN 'Apes'
    WHEN nft_address = '0xf60762fe88da57b0c523f2b8f734dce9070ee4a4' THEN '8OKI'
    WHEN nft_address = '0x9c310a63ee5352d1cdbec32439ce22f0e89d5e14' THEN 'Kingpins'
    WHEN nft_address = '0xea3e8708e33b2072e7788aaa9159547749714e3a' THEN 'Knights'
    ELSE 'Eres Idiota'
    END as collection_name,
    sum(case when CURRENCY_SYMBOL not in ('WETH','ETH') then 1 end) as non_eth_tx,
    count(tx_hash) as transaction_count,
    sum(price) as eth_amount,
    sum(price_usd) as usd_amount,
    sum(tx_fee_usd) as total_gas,
    sum(creator_fee_usd) as fcf_revenue,
    max(price) as max_price_eth,
    max(price_usd) as max_price_usd
    FROM ethereum.core.ez_nft_sales
    WHERE nft_address in (
    '0x9d5407c08febe35f3a747da422dc2da45ca30b61','0xf60762fe88da57b0c523f2b8f734dce9070ee4a4','0x9c310a63ee5352d1cdbec32439ce22f0e89d5e14','0xea3e8708e33b2072e7788aaa9159547749714e3a')
    group by 1,2
    Run a query to Download Data