date(BLOCK_TIMESTAMP) as dt1,

sum(price) as sale_vol,

count(tx_id) as sale_flow,

sum(sale_flow) over(order by dt1) as grow_top,

count (distinct BUYER) as buyer_flow,

count(distinct SELLER) as sellers,

buyer_flow+sellers as trader

from flow.core.fact_nft_sales

where MARKETPLACE='A.c1e4f4f4c4257510.TopShotMarketV3'

and BLOCK_TIMESTAMP>='2022-05-09'

and TX_SUCCEEDED='TRUE'

group by 1

order by 1),

t2 as (select

date(BLOCK_TIMESTAMP) as dt2,

count(distinct PURCHASER) as buyer_sol,

count(tx_id) as sale_sol,

sum(sale_sol) over(order by dt2) as grow_magic

from flipside_prod_db.solana.fact_nft_sales

where MARKETPLACE in ('magic eden v1','magic eden v2')

and BLOCK_TIMESTAMP>='2022-05-09'

and SUCCEEDED='TRUE'

group by 1),

t3 as (select

date(BLOCK_TIMESTAMP) as dt3,

count(distinct BUYER_ADDRESS) as buyer_eth,

count(distinct SELLER_ADDRESS) as seller_eth,

count(TX_HASH) as sale_eth,

sum(sale_eth) over(order by dt3) as grow_OS

from flipside_prod_db.ethereum_core.ez_nft_sales

where PLATFORM_NAME='opensea'

and BLOCK_TIMESTAMP>='2022-05-09'

and EVENT_TYPE='sale'