Opensea Sales

This is a BETA and is currently updating every 15mins. Looker Studio is pretty sh!te so resetting the date filtering is a bit finicky. You need to choose the "auto date range" option to reset the table. 

Things to note:

1. Data goes back to the end of Season 5. 

2. Retired player sales have been filtered out of the dataset as they often get bought in bulk and it's hard to assign the correct sale price. 

3. This doesn't capture multi-player trades. 

4. Free transfers between wallets have been filtered out. 

5. Numbers down the left menu allow you to see the different worksheets within this dataset. 

Known bugs:

1. Ratings and age are the current for the player in question, not the historical values at the time of sale. I'm going to be fixing this so that they reflect the historical values at some point.

2. If a player is minted and sold before a player database update is completed, they'll be missing from the dataset (or show as nulls) until the next player database refresh (which is every 6 hours). 

3. We are not capturing all of the Opensea Sales. There appears to be the odd transaction not being picked up. We'll look to do a backfill once we work out how to do that :)