What is AAVE?

Aave is a decentralized crypto lending platform that lets users borrow and lend crypto. Aave uses smart contracts to automate the process. It specializes in overcollateralized loans that require users to deposit crypto worth more than the amount that they wish to borrow. Resource

What is Staking?

Staking is a process in which cryptocurrency holders volunteer to take part in validating transactions on the blockchain – in other words, checking that the ledger all adds up. The checking is not done by individuals, but by computers in the blockchain network, often via third-party staking services. Resource

What Is Cryptocurrency Circulating Supply?

the number of tokens in circulation in the market at any given time that are available for trade. Resource

In this dashboard, we intend to create visualizations weekly movements of AAVE tokens on the Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and withdrawal activities, as well as the daily staking and unstaking of AAVE tokens. For this purpose, as requested, we use the following tables along with the conditions:

Supply:

• Table: ethereum.aave.ez_deposits
• Condition: symbol ilike 'AAVE'

Withdraw:

• Table: ethereum.aave.ez_withdraws
• Condition: symbol ilike 'AAVE'

Stack:

• Table: ethereum.core.ez_decoded_event_logs
• Condition: origin_to_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5' and event_name ilike 'redeem'

UnStake:

• Table: ethereum.core.ez_decoded_event_logs
• Condition: origin_to_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5' and event_name ilike 'staked'