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?

Methodology:

For this bounty, I have used 4 tables for my queries: flow.core.fact_events, flow.core.fact_nft_sales, flow.core.dim_contract_labels and new table flow.core.dim_topshot_metadata

I have analyzed data for TopShot Marketplace Sales and also TopShot NFTs Sales.

Also, I have filtered results from 1 week before NBA Conference Finals (10th May) till 1 week after NBA Conference Finals (05 June) for a better comparing of the impact.

Based on the 2 above charts, we can sense impact of NBA Conference Finals on TopShot sales. as we see, most number of TopShot sales has achieved during NBA Conference Finals. we can see high spikes especially between 16th and 27th May.

Also in terms of number of buyers and sellers, we can see high some higher spikes during NBA Conference Finals. the impact of these finals are visible lightly on both charts especially between 16th and 22th May.

In terms of sale volume, we can more obviously sense the impact of NBA Conference finals on TopShot sales. as we see, highest volume of sales has achieved during finals timespan especially on 24th and 25th May.

And in the above and left charts, we can see some increasing trends over time and we can say the slope of these charts (especially volume) have got sharper over time and during finals.

The National Basketball Association Conference Finals are the Eastern and Western championship series of the National Basketball Association (NBA), a major professional basketball league in North America. The NBA was founded in 1946 as the Basketball Association of America (BAA). The NBA adopted its current name at the start of the 1949–50 season when the BAA merged with the National Basketball League (NBL). The league currently consists of 30 teams, of which 29 are located in the United States and 1 in Canada. Each team plays 82 games in the regular season.[A] After the regular season, eight teams from each of the league's two conferences qualify for the playoffs. At the end of the playoffs, the top two teams play each other in the Conference Finals, to determine the Conference Champions from each side, who then proceed to play in the NBA Finals. Trophies were given to each conference winner starting in 2001. In 2022, they named them the Bob Cousy Trophy for the Eastern Conference and the Oscar Robertson Trophy for the Western Conference. Also that year, the league started naming a NBA Conference Finals Most Valuable Player (MVP) for each conference.

The 2022 NBA Conference Finals bracket is set following two Game 7s to close out the second round, with the Boston Celtics and Dallas Mavericks advancing. With two rounds of play in the books, the conference finals will decide which teams will represent their respective conferences in the 2022 NBA Finals. The four teams vying for the last two spots are the Celtics, Mavericks, Golden State Warriors and Miami Heat.

The conference finals began in the East. The first game was played on Tuesday, May 17, and the West had Game 1 on Wednesday, May 18.

The games had a 2-2-1-1-1 format with the higher seed hosting Games 1, 2, 5 and 7 (if necessary). The lower seed had the chance to host Games 3, 4 and 6 (if necessary).

Here is the full seven-game schedule for both conferences:

Eastern Conference

No. 1 Miami Heat vs. No. 2 Boston Celtics

Game 1: Miami won 107-118

Game 2: Boston won 127-102

Game 3: Miami won 109-103

Game 4: Boston won 102-82

Game 5: Boston won 93-80

Game 6: Miami won 111-103

Game 7: Boston won 100-96

Western Conference

No. 3 Golden State Warriors vs. No. 4 Dallas Mavericks

Game 1: Golden State won 112-87

Game 2: Golden State won 126-117

Game 3: Golden State won 109-100

Game 4: Dallas won 119-109

Game 5: Golden State won 120-110

On the 2 above charts, we can see number of TopShot NFT buyers and sellers over time by their team. as we see, the highest number of these users has acheived on 22nd May (during finals).

In terms of sales volume, we can also see some high spikes during finals timespan. as we see, the volume for Golden State Sarriors is getting more and more over time.

and in terms of growth rate (cumulative volume of sales), we can also see Golden State Warrior on the first rank by far. after that, we can see a close compete between Dallas and Miami over time.

In terms of number of sales, we can also see high spike on 22nd May and other dates during finals.

Moreover, we can see Golden State Warriors sales is getting more and more over time.

in terms of growth rate (cumulatve sales count), we can see Golden state is leading the way . after that, there is a close compete between 3 others.

On the above pie-charts, we can see distribution of Teams by their Number of Sales, Number of Buyers, Number of Sellers, and Volume of Sales.

As we can see, Golen State Warriors are the most popular NFT on the NBA Topshots. After that, we have Dallas Mavericks on the 2nd place.

Conclusion

According to the above analysis, we have realized that volume of sales for NBA TopShots has increased Significantly during NBA Conference Finals.

As we see, Golden State Warriors (as the winner of one of competitions) is the most popular NFT on NBA.TopShot in all terms (volume, number of sellers/buyers, number of sales).