SELECT
contract_address as contract,
COUNT(*) AS mints
FROM erc721_transfer
WHERE "from" = '\x0000000000000000000000000000000000000000'
AND block_number BETWEEN {{block}} - 2000 AND {{block}}
GROUP BY contract_address
ORDER BY mints DESC
LIMIT 1000
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
{
"rows": [
{
"contract": "0x77777777bade65798B4DB184d52457c63b5b44B4",
"mints": 1337
},
{
"contract": "0xb6a37b5d14d502c3ab0ae6f3a0e058bc9517786e",
"mints": 430
}
]
}
Trusted by 400+ developers around the world every day, including web3 brands such as
Trusted by 400+ developers around the world every day, including web3 brands such as
Trusted by 400+ developers around the world every day, including web3 brands such as
Web3 Development with
SQL, GraphQL and Stream
Web3 Development using SQL, GraphQL
and Stream
Query just the data you need for your web3 app. From complex analysis using SQL to simple GraphQL requests for common use-cases.
Query just the data you need for your web3 app. From complex analysis using SQL to simple GraphQL requests for common use-cases.
Ethereum
Polygon
Zora
Sepolia
Designed For Developers
Any chain in one API
Use the same developer tools across multiple chains
Bring-your-own-stack
Build anywhere with industry-standard tools like SQL and GraphQL
Faster than the speed of light
Low-latency APIs, powering better UX and conversion
Dedicated Support
Chat and get support from our engineers directly
Stack
Best-in-class APIs for any chain, op-stack or custom L2
Stream
Sync to data-warehouses faster than ever
Production-Ready Data
Transactions and Events
Get close to the metal with decoded Transactions and Events
Addresses and Names
The most advanced ENS API, integrated throughout our platform
NFTs
Up-to-date metadata and interactions for all NFT types
Token Balances
Get accurate balances faster than ever for any ERC20 token
Designed For
Developers
Any chain in one API
Use the same developer tools
across multiple chains
Bring-your-own-stack
Build anywhere with industry-standard tools like SQL and GraphQL
Faster than the speed of light
Low-latency APIs, powering better UX and conversion
Dedicated Support
Chat and get support from our engineers directly
Stack
Best-in-class APIs for any chain, op-stack or custom L2
Stream
Sync to data-warehouses faster
than ever
Production-
Ready Data
Transactions and Events
Get close to the metal with decoded Transactions and Events
Addresses and Names
The most advanced ENS API, integrated throughout our platform
NFTs
Up-to-date metadata and interactions for all NFT types
Token Balances
Get accurate balances faster than ever for any ERC20 token
Built on Basement
Start building today
Whether you’re building a wallet or a brand new protocol. We got your back. Our APIs make building decentralised apps a breeze.
Start building today
Whether you’re building a wallet or a brand new protocol. We got your back. Our APIs make building decentralised apps a breeze.
Start building today
Whether you’re building a wallet or a brand new protocol. We got your back. Our APIs make building decentralised apps a breeze.