cast(block_timestamp as date) as date,

platform_name as exchange,

count(distinct buyer_address) as buyers,

count(distinct seller_address) as sellers,

count(seller_address) as trades,

sum(platform_fee_usd) as fees,

sum(creator_fee_usd) as royalties,

count(distinct buyer_address)/count(distinct seller_address) as Buyer_v_Seller,

sum(case when currency_symbol IN ('WETH','ETH') then 1 end) as TOTAL_ETH_WETH_TRADES,

sum(case when currency_symbol IN ('WETH','ETH') then price end) as TOTAL_ETH_WETH_VALUE,

sum(case when currency_symbol IN ('WETH','ETH') and creator_fee_usd > 0.9 then price end) as TOTAL_TRADE_W_ROYALTIES,

sum(case when currency_symbol IN ('WETH') then 1 end) as WETH,

count(distinct case when currency_symbol = 'WETH' then seller_address end) as WETH_SELLERS,

count(distinct case when currency_symbol IN ('ETH', 'WETH') then seller_address end) as ALL_SELLERS,

sum(price_usd) as USD

from ethereum.core.ez_nft_sales where block_timestamp > '2021-07-01' and price_usd < 5000000 and platform_name in ('opensea','x2y2','looksrare')

--and creator_fee_usd > .011--and nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'

group by 1, 2 order by 1 desc, 2