In this tutorial, we will introduce a collection of new datasets recently added to Chainbase. These datasets provide developers with valuable information related to various decentralized finance (DeFi) protocols and platforms. With the help of these datasets, developers can organize and manage data more efficiently, enabling them to build decentralized applications (dApps) and streamline the development process.
Dataset Overview
This update includes 8 new datasets from prominent DeFi projects such as Orion Protocol, SashimiSwap, Verse Ecosystem, DeFiSwap, SaitaSwap, VesperFi, TokenReactor, and Level Finance. These datasets cover different types of dex & yield aggregator protocols & Derivatives, offering a comprehensive range of data for developers to utilize.
To give you an idea of the available data, let's explore some typical scenarios:
- Historical Records of Liquidity and Trading: For protocols like Orion Protocol, SashimiSwap, Verse Ecosystem, and SaitaSwap, developers can access historical records of liquidity and trading. This includes details such as transaction IDs, timestamps, pool information, token pairs, input/output amounts, and wallet addresses involved.
- Vaults Data: VesperFi dataset provides indexing of vaults data. Developers can query information about various vaults, including their names, symbols, input/output tokens, reward tokens, deposit limits, fees, creation timestamps, total value locked in USD, and more. This data helps developers gain insights into vault performance and management.
- Wallet Actions: By utilizing the "GetWalletActions" query, developers can retrieve deposit and withdraw information associated with a specific wallet address. This query provides details such as transaction amounts, timestamps, block numbers, sender/receiver addresses, and transaction hashes.
- Token Information: Dataset6 also includes information about tokens used in the protocols. Developers can retrieve data such as token IDs, names, symbols, and decimal precision, which are crucial for working with token-related operations.
How to Access the Data
To access the datasets, you can use the provided GraphQL queries in combination with the ChainBase API.
For example, to retrieve liquidity and trading data from Orion, SashimiSwap, Verse Ecosystem, and SaitaSwap, you can use the "transactionsQuery" with the necessary parameters. The query provides information about swaps, deposits, and withdrawals, including transaction IDs, timestamps, pool details, token symbols, wallet addresses, and amounts involved.
Similarly, you can utilize the "GetVaults" query to access vaults data from VesperFi and retrieve information such as vault IDs, names, symbols, input/output tokens, reward tokens, deposit limits, fees, creation timestamps, and more.
If you need to query specific wallet actions related to deposits and withdrawals, you can use the "GetWalletActions" query and provide the wallet address as a parameter. This query will retrieve the corresponding deposit and withdraw information, including amounts, timestamps, block numbers, and transaction hashes.
The dataset outputs provided in the JSON format demonstrate the structure and sample data returned by the queries. Developers can parse and process this data as needed for their applications.
GraphQL Demo
Orion、Sashimi、Verse、Saitaswap
View all historical records related to liquidity and trading.
query transactionsQuery($poolAddresses: [Bytes]!) {
swaps(
orderBy: timestamp
orderDirection: desc
where: {pool_in: $poolAddresses}
) {
id
timestamp
pool {
id
__typename
}
tokenIn {
symbol
__typename
}
tokenOut {
symbol
__typename
}
from
amountIn
amountOut
to
_walletAddress
__typename
}
deposits(
orderBy: timestamp
orderDirection: desc
where: {pool_in: $poolAddresses}
) {
id
timestamp
pool {
inputTokens {
symbol
__typename
}
outputToken {
symbol
__typename
}
__typename
}
from
inputTokenAmounts
outputTokenAmount
to
_walletAddress
__typename
}
withdraws(
orderBy: timestamp
orderDirection: desc
where: {pool_in: $poolAddresses}
) {
id
timestamp
pool {
id
__typename
}
inputTokens {
symbol
__typename
}
outputToken {
symbol
__typename
}
from
inputTokenAmounts
outputTokenAmount
to
_walletAddress
__typename
}
}
{
"poolAddresses":
[
"0x76fe189e4fa5ff997872ddf44023b04cd7cb03d2",
"target-wallect-address2"
]
}
Below are the dataset outputs.
{
"data": {
"swaps": [
{
"id": "0xa6f63fcb6bec8818864d96a5b1bb19e8bd85ee37b2cc916412e720988440b2aa-36",
"timestamp": "1675353395",
"pool": {
"id": "0x76fe189e4fa5ff997872ddf44023b04cd7cb03d2",
"__typename": "LiquidityPool"
},
"tokenIn": {
"symbol": "USDC",
"__typename": "Token"
},
"tokenOut": {
"symbol": "ATK",
"__typename": "Token"
},
"from": "0x420a50a62b17c18b36c64478784536ba980feac8",
"amountIn": "100",
"amountOut": "99680123783317",
"to": "0x13e557c51c0a37e25e051491037ee546597c689f",
"_walletAddress": "0x13e557c51c0a37e25e051491037ee546597c689f",
"__typename": "Swap"
}
],
"deposits": [
{
"id": "0x19091db3c1985005a31582b28791b7c9c67ab563a4af63473b4d194f237a9f82-221",
"timestamp": "1675353059",
"pool": {
"inputTokens": [
{
"symbol": "ATK",
"__typename": "Token"
},
{
"symbol": "USDC",
"__typename": "Token"
}
],
"outputToken": {
"symbol": "tokenA/USD Coin",
"__typename": "Token"
},
"__typename": "LiquidityPool"
},
"from": "0x837962b686fd5a407fb4e5f92e8be86a230484bd",
"inputTokenAmounts": [
"500000000000000000",
"500000"
],
"outputTokenAmount": "499999999000",
"to": "0x76fe189e4fa5ff997872ddf44023b04cd7cb03d2",
"_walletAddress": "0x837962b686fd5a407fb4e5f92e8be86a230484bd",
"__typename": "Deposit"
}
],
"withdraws": []
}
}
Vesperfi
Indexing the vaults data.
query GetVaults {
vaults {
id
name
symbol
inputToken {
id
name
symbol
decimals
}
outputToken {
id
name
symbol
decimals
}
rewardTokens {
id
token {
id
name
symbol
decimals
}
type
}
depositLimit
fees {
id
feePercentage
feeType
}
createdTimestamp
createdBlockNumber
totalValueLockedUSD
cumulativeSupplySideRevenueUSD
cumulativeProtocolSideRevenueUSD
cumulativeTotalRevenueUSD
inputTokenBalance
outputTokenSupply
outputTokenPriceUSD
pricePerShare
stakedOutputTokenAmount
rewardTokenEmissionsAmount
rewardTokenEmissionsUSD
deposits {
id
hash
logIndex
to
from
blockNumber
timestamp
asset {
id
name
symbol
decimals
}
amount
amountUSD
}
withdraws {
id
hash
logIndex
to
from
blockNumber
timestamp
asset {
id
name
symbol
decimals
}
amount
amountUSD
}
}
}
Below are the dataset outputs.
{
"data": {
"vaults": [
{
"id": "0x01e1d41c1159b745298724c5fd3eaff3da1c6efd",
"name": "vaWBTC Pool",
"symbol": "vaWBTC",
"inputToken": {
"id": "0x2260fac5e5542a773aa44fbcfedf7c193bc2c599",
"name": "Wrapped BTC",
"symbol": "WBTC",
"decimals": 8
},
"outputToken": {
"id": "0x01e1d41c1159b745298724c5fd3eaff3da1c6efd",
"name": "vaWBTC Pool",
"symbol": "vaWBTC",
"decimals": 18
},
"rewardTokens": [
{
"id": "0x1b40183efb4dd766f11bda7a7c3ad8982e998421",
"token": {
"id": "0x1b40183efb4dd766f11bda7a7c3ad8982e998421",
"name": "VesperToken",
"symbol": "VSP",
"decimals": 18
},
"type": "DEPOSIT"
}
],
"depositLimit": "0",
"fees": [
{
"id": "performance-fee-0x01e1d41c1159b745298724c5fd3eaff3da1c6efd",
"feePercentage": "0",
"feeType": "PERFORMANCE_FEE"
}
.....
Query the withdraw and deposit information from a specific address.
query GetWalletActions($wallet: String) {
withdraws(where: {from: $wallet}) {
amount
amountUSD
blockNumber
from
hash
id
logIndex
timestamp
to
}
deposits(where: {from: $wallet}) {
amount
amountUSD
blockNumber
from
hash
id
logIndex
timestamp
to
}
}
Tokemak
Indexing the vaults data.
query GetVaults {
vaults {
id
name
symbol
inputToken {
id
name
symbol
decimals
}
outputToken {
id
name
symbol
decimals
}
rewardTokens {
id
token {
id
name
symbol
decimals
}
type
}
depositLimit
fees {
id
feePercentage
feeType
}
createdTimestamp
createdBlockNumber
totalValueLockedUSD
inputTokenBalance
outputTokenSupply
outputTokenPriceUSD
pricePerShare
stakedOutputTokenAmount
rewardTokenEmissionsAmount
rewardTokenEmissionsUSD
deposits {
id
hash
logIndex
to
from
blockNumber
timestamp
asset {
id
name
symbol
decimals
}
amount
amountUSD
}
withdraws {
id
hash
logIndex
to
from
blockNumber
timestamp
asset {
id
name
symbol
decimals
}
amount
amountUSD
}
}
}
Below are the dataset outputs.
"vaults": [
{
"id": "0x03dcccd17cc36ee61f9004bcfd7a85f58b2d360d",
"name": "TokemaktFEI",
"symbol": "tFEI",
"inputToken": {
"id": "0x956f47f50a910163d8bf957cf5846d573e7f87ca",
"name": "Fei USD",
"symbol": "FEI",
"decimals": 18
},
"outputToken": {
"id": "0x03dcccd17cc36ee61f9004bcfd7a85f58b2d360d",
"name": "TokemaktFEI",
"symbol": "tFEI",
"decimals": 18
},
"rewardTokens": [
{
"id": "0x2e9d63788249371f1dfc918a52f8d799f4a38c94",
"token": {
"id": "0x2e9d63788249371f1dfc918a52f8d799f4a38c94",
"name": "",
"symbol": "",
"decimals": 18
},
"type": "DEPOSIT"
}
],
"depositLimit": "0",
"fees": [],
"createdTimestamp": "1644421806",
"createdBlockNumber": "14172800",
"totalValueLockedUSD": "762.80706",
"inputTokenBalance": "1140783329820937940379",
"outputTokenSupply": "1140783329820937940379",
"outputTokenPriceUSD": "669129000000000000",
"pricePerShare": "1000000000000000000",
"stakedOutputTokenAmount": null,
"rewardTokenEmissionsAmount": null,
"rewardTokenEmissionsUSD": null,
"deposits": [
{
"id": "deposit-0x06d22097be2493b0e82f55b9f079ef94bba21f9802c7dd8e060765663123ed1a",
"hash": "0x06d22097be2493b0e82f55b9f079ef94bba21f9802c7dd8e060765663123ed1a",
"logIndex": 105,
"to": "0x03dcccd17cc36ee61f9004bcfd7a85f58b2d360d",
"from": "0x72005e19120cf05eda67f44e3e1204d274c5529b",
"blockNumber": "14528625",
"timestamp": "1649197907",
"asset": {
"id": "0x956f47f50a910163d8bf957cf5846d573e7f87ca",
"name": "Fei USD",
"symbol": "FEI",
"decimals": 18
},
"amount": "41175434606179035985446",
"amountUSD": "46110.392794598805806373673992"
},
{
"id": "deposit-0x157506f481992d9b6f29258fb2ed497fbf13549a9cffc812774a9a819e031125",
"hash": "0x157506f481992d9b6f29258fb2ed497fbf13549a9cffc812774a9a819e031125",
"logIndex": 192,
"to": "0x03dcccd17cc36ee61f9004bcfd7a85f58b2d360d",
"from": "0x9c073ee3701a5cc639b4f12a3a6db50c2ac36aa0",
"blockNumber": "14309547",
"timestamp": "1646249803",
"asset": {
"id": "0x956f47f50a910163d8bf957cf5846d573e7f87ca",
"name": "Fei USD",
"symbol": "FEI",
"decimals": 18
},
"amount": "1101207888839650000000",
"amountUSD": "1100.39189379401981935"
},
Query the withdraw and deposit information from a specific address.
query GetWalletActions($wallets: [Bytes]!) {
withdraws(where: {from_in: $wallets}) {
amount
amountUSD
blockNumber
from
hash
id
logIndex
timestamp
to
}
deposits(where: {from_in: $wallets}) {
amount
amountUSD
blockNumber
from
hash
id
logIndex
timestamp
to
}
}
{
"wallets":
[
"target-wallect-address",
"target-wallect-address1"
]
}
Conclusion
With these datasets, developers can access valuable data related to liquidity, trading, vaults, and wallet actions. This information allows developers to build decentralized applications, analyze protocol performance, and make data-driven decisions.
The provided GraphQL queries and dataset outputs serve as starting points for accessing the data. More datasets mean more possibilities! We're excited to see how this growing collection of datasets will help unlock new innovations and drive the future of blockchain technology.
Happy coding and exploring the possibilities with Chainbase Dataset!
About Chainbase
Chainbase is an all-in-one data infrastructure for Web3 that allows you to index, transform, and use on-chain data at scale. By leveraging enriched on-chain data and streaming computing technologies across one data infrastructure, Chainbase automates the indexing and querying of blockchain data, enabling developers to accomplish more with less effort.
Want to learn more about Chainbase?
Visit our website chainbase.com Sign up for a free account, and Check out our documentation.
Website｜Blog｜Twitter｜Discord｜Link3
