with daimond_hands as

with buyers as

select

nft_to_address

from ethereum.nft.ez_nft_transfers

where nft_address=lower('0x1B41d54B3F8de13d58102c50D7431Fd6Aa1a2c48')

and block_timestamp >='2024-06-09 00:00:00.000'

group by 1

),

sellers as

select

nft_from_address

from ethereum.nft.ez_nft_transfers

where nft_address=lower('0x1B41d54B3F8de13d58102c50D7431Fd6Aa1a2c48')

and block_timestamp >='2024-06-09 00:00:00.000'

group by 1

select * from buyers where nft_to_address not in (select * from sellers)

),

dates as

select date_day as date from ethereum.core.dim_dates

where date_day>='2021-12-13 00:00:00.000'

and date_day <= current_date

),

buy_sell_table as

select