DATE_TRUNC(

'day',

CONVERT_TIMEZONE('America/Los_Angeles', block_timestamp)

) AS "Date",

COUNT(DISTINCT tx_id) AS "Total Transactions",

COUNT(DISTINCT buyer) AS "Total Buyers",

(

SELECT

COUNT(DISTINCT buyer)

FROM

flow.nft.ez_nft_sales

WHERE

NFT_COLLECTION IN (

'A.e4cf4bdc1751c65d.AllDay',

'A.e4cf4bdc1751c65d.PackNFT'

)

AND DATE_TRUNC(

'day',

CONVERT_TIMEZONE('America/Los_Angeles', block_timestamp)

) >= '{{Year}}-01-01 00:00:00'

AND DATE_TRUNC(

'day',

CONVERT_TIMEZONE('America/Los_Angeles', block_timestamp)

) <= '{{Year}}-12-31 18:00:00'

) AS "Distinct Buyers (Timeframe)",

ROUND(

(

(

"Total Buyers" - LAG("Total Buyers") OVER (

ORDER BY

"Date" ASC

)

) * 100.0