block_timestamp,

nft_address,

project_Name,

'{{select}}' as filter,

case when filter = 'select_all' then nft_address

when filter = 'filter_one' AND nft_address = '{{nft_contract}}' then nft_address else null end as filter_type,

currency_symbol,

price,

price_usd,

platform_name,

event_type,

seller_address,

buyer_address,

tokenid,

tx_hash

FROM ethereum.core.ez_nft_sales

WHERE 1=1

-- AND nft_address = lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')

AND currency_symbol IN ('WETH', 'ETH')

AND project_name IS NOT NULL

AND filter_type IS NOT NULL -- important filter

ORDER BY block_timestamp DESC

LIMIT {{no_of_observation}}