How to use dune.com to collect some NFTs data

What is dune ?

Dune is a powerful tool for blockchain research, complete with all the tools you need to discover,explore,and visualize vast amounts of blockchain data. We can get data via a sql query and then present data as

• Bar charts
• Area Charts
• Scatter Charts
• Line Charts
• Pie Charts
• Counters
• Tables

Sql guides

Before we get into sql. In case you have no background on relational databases like mysql, let's break down what are relational databases.Relational databases contain a set of data tables so that a user can query some combination of tables to get only the subset of data (rows) they need.

Above is an example of a relational database.
With sql query we can get the data we need fast and efficiently.

Data sets

• Ethereum
• Gnosis chain
• Polygon
• Optimsm
• BNB smart chain

Create an dashboards via sql

WITH token_names as (
select * from
nft."tokens"
)

select name, symbol, count(*) as number_of_nfts
from erc721."ERC721_evt_Transfer" as scam_transfers
join token_names on token_names.contract_address = scam_transfers.contract_address
where scam_transfers."to" = '\x3E0DeFb880cd8e163baD68ABe66437f99A7A8A74'
AND scam_transfers."from" != '\x0000000000000000000000000000000000000000'
group by name, symbol
order by 3 desc