1.FLOW Usage During the NBA Playoffs

Sajjadiii1.FLOW Usage During the NBA Playoffs

Updated 2022-07-11

--*/ Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume.

--Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?

-- payout 31.646 FLOW

-- GP 94.94 FLOW

--/*

select block_timestamp::date as date ,

PRICE as sale_volume ,

TEAM

from flow.core.fact_nft_sales a

join flow.core.dim_topshot_metadata b

on a.NFT_ID = b.NFT_ID

where (block_timestamp::date >= '2022-05-01' and block_timestamp::date <= '2022-06-01'

and team = 'Dallas Mavericks'

or team = 'Boston Celtics'

or team = 'Golden State Warriors'

or team = 'Miami Heat' )

Run a query to Download Data

flipside