(SELECT buyer_address,tokenid as id , block_timestamp as purchase_time

from

ethereum.core.ez_nft_sales

where (nft_address ilike '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38' )),

seller as

(SELECT seller_address,tokenid , block_timestamp as sale_time

from

ethereum.core.ez_nft_sales

where (nft_address ilike '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38' ))

SELECT *, avg(avg_holder_time) over (order by day) as avg_holder_time_over_time

from

( SELECT date(purchase_time) as day , avg(time_diff_days) as avg_holder_time from

(SELECT *, timestampdiff(sql_tsi_minute,purchase_time,sale_time )/(60*24) as time_diff_days from buyer

inner join seller

on seller_address = buyer_address and tokenid = id and purchase_time < sale_time)

GROUP by 1 )

where day >= CURRENT_DATE - {{n}}