SQL
SQL
SQL
Gather complex insights, and turn them into a production-ready API endpoint with the power of SQL.
Gather complex insights, and
turn them into a production-ready API endpoint with the power of SQL.
Gather complex insights, and turn them into a production-ready API endpoint with the power of SQL.
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
}
]
}
Complex Insights
Industry Standard
Industry Standard
Basement SQL is backwards compatible with Postgres-flavored SQL
Basement SQL is backwards compatible with Postgres-flavored SQL
Low latency
Low latency
Datasets are optimized for fetching onchain data, and are super fast
Datasets are optimized for fetching onchain data, and are super fast
Instant Start
Instant Start
Instantly query and analyze the many pre-indexed datasets
Instantly query and analyze the many pre-indexed datasets
Free to use
Free to use
SQL is available to all users, regardless of your plan
SQL is available to all users,
regardless of your plan
Get in touch..
Get in touch…
Join hundreds of developers in building top-notch web3 products with Basement. Our team would love to show you how Basement can accelerate your development.
Join hundreds of developers in building top-notch web3 products with Basement. Our team would love to show you how Basement can accelerate your development.
Tailored Solutions
Our team can help you design a custom API, so you stay focussed on building
Dedicated Support
Get started faster, get a direct channel with our team of engineers