Approach
This bounty requires data from up to last year, so the new dataset for Polygon cannot be used, as it has not yet been backfilled, for that reason we are going to use flipside_prod_db.polygon.udm_events
table.
In order to find all the addresses related to NFTs following piece of code is used, then its join to the query table.
select * from polygon.core.dim_labels where project_name like '%opensea%' or project_name like '%nft%'
To find users first interaction, we find the first time a user interacted with an NFT platform (using code above) and compare it with their very first transaction date, if they are same, these users started off with NFT for the first time.
Volume
The charts below the amount of transferred volume in USD.
- The first chart, shows the hourly volume in the past week.
- The second chart shows the daily volume in the last month, It can be seen that no volume was transferred during the first five days of July.
- The last chart shows the daily volume in the last year, it can be seen that during March 9 and 10 there was a sharp increase in volume.
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...