with others_type as ( --sales

select

tx_hash

,block_timestamp

from bsc.nft.ez_nft_transfers

join bsc.core.fact_transactions transactions using (tx_hash)

where block_timestamp > '2023-09-10' --min block_timestamp for the nft address

and STATUS = 'SUCCESS'

and nft_address = '0x9d2e6134af5b63498d15546f2701837f001c6043'

and event_type = 'other' --mostly sale events

--and tx_hash = '0x8400505e11b5315bfd35fa9ceb3f182eb279003d8486e2f33a1d24bf2c2853d3'

),

collector_addresses as (

select

date_trunc('day',block_timestamp) date

--,to_address as collector_addresses

,sum(amount) fees_volume

,count(distinct tx_hash) as nft_sales

,sum(fees_volume) over (order by date asc) total_fees_volume

from bsc.core.ez_token_transfers

join others_type using (tx_hash)

where to_address in ('0x2a70cb6bf05360214591405a2322fbffa36c7732',

'0x225a1672544d4c0e9e0f2906fed3758a4ec631a3',

'0xe80f24dcba46c5138a08715b481bf7df60089d18')

group by 1

select

date

,fees_volume

,nft_sales

,total_fees_volume

from collector_addresses