select

date_trunc(

'day',

min(BLOCK_TIMESTAMP)

) as buy_date,

BUYER AS FLOW_NFT_BUYER,

NFT_ID

from

flow.core.fact_nft_sales

where

TX_SUCCEEDED = 'TRUE'

group by

2,

3

),

flow_flippers AS (

select

date_trunc('day', BLOCK_TIMESTAMP) as sell_date,

count(DISTINCT SELLER) AS FLOW_weekly_flippers

from

flow.core.fact_nft_sales A

inner join buy_FLOW_NFT B on A.NFT_ID = B.NFT_id

and SELLER = FLOW_NFT_BUYER

where

TX_SUCCEEDED = 'TRUE'

and datediff(day, sell_date, buy_date) <= 7

group by

1

),

buy_SOL_NFT AS (

select

date_trunc(

'day',

min(BLOCK_TIMESTAMP)

) as buy_date,