nft_collection,

buyer

from flow.core.fact_nft_sales

where tx_succeeded = 'TRUE'),

flow as (select date_trunc('day', block_timestamp) as day,

count(distinct(seller)) as flow_flipper_count

from flow.core.fact_nft_sales a

join flow_buyer b on a.seller = b.buyer and a.nft_collection = b.nft_collection

where datediff(day, a.block_timestamp, purchase_date) <= 7

group by 1),

optimism_buyer as (select block_timestamp::date as purchase_date,

nft_address,

buyer_address

from optimism.core.ez_nft_sales

where event_type = 'sale'

and price_usd > 0),

optimism as (select date_trunc('day', block_timestamp) as day,

count(distinct(seller_address)) as optimism_flipper_count

from optimism.core.ez_nft_sales a

join optimism_buyer b on a.seller_address = b.buyer_address and a.nft_address = b.nft_address

where datediff(day, a.block_timestamp, purchase_date) <= 7

group by 1),

algo_buyer as (select block_timestamp::date as purchase_date,

nft_asset_id,

purchaser

from flipside_prod_db.algorand.nft_sales),

algo as (select date_trunc('day', block_timestamp) as day,

count(distinct(a.nft_asset_id)) as algo_flipper_count

from flipside_prod_db.algorand.nft_sales a

join algo_buyer b on a.nft_asset_id = b.nft_asset_id