date_trunc('day',block_timestamp) as day,

count(tx_hash),

count(case when nft_address in (lower('{{Address}}')) then tx_hash else null end) as Project_txns,

count(case when nft_address in (lower('{{Address}}')) then tx_hash else null end)/count(tx_hash)*100 as "% Market txn Share"

from

ethereum.core.ez_nft_sales

where currency_symbol in ('WETH','ETH')

and price_usd < 500000

and platform_name = 'opensea'

and block_timestamp >= '{{Min_Date}}'::timestamp

group by 1--, 2, 3

order by 1 desc