Rebase
Query for the amount of token balances rebased daily across all holders.
Currently, we support the following tokens for rebasing calculation.
Table | Rebase Frequency | Token |
|---|---|---|
ethereum.assets.steth_rebase | Daily
(~1200-1300 UTC) |
The
ethereum.assets.steth_rebase provide the total balances of stETH rebased across all wallets on ethereum from 17th May 2023 onwards. Lido stETH is calculated every day. Lido rebased balances are calculated through the concept of shares with the event TokenRebased() that occurs once daily:
balanceOf(account) = shares[account] * totalPooledEther / totalShares
Lido | Lido Docs
More on token rebase.
-- Check for rebased amount of stETH daily across a set of wallets
select
rebase_date,
address,
sum(rebase_amount) as sum_rebase
from ethereum.assets.steth_rebase
where address in ('0xdc24316b9ae028f1497c275eb9192a3ea0f67022', -- Lido: Curve Liquidity Farming Pool Contract
'0x611f97d450042418e7338cbdd19202711563df01', -- Justin Sun
'0x0bc3807ec262cb779b38d65b38158acc3bfede10') -- Nouns DAO: Treasury
group by 1,2
Column Name | Description | Example |
|---|---|---|
rebase_date | Date of balances rebase (UTC). | 2023-08-27 |
address | Address of stETH holder. | 0x02ed4a07431bcc26c5519ebf8473ee221f26da8b |
rebase_amount | Token amount rebased normalized. Calculated by the difference in wallet balances post rebase. | 1.654727361 |
post_rebase_balance | Pre-rebase token balances. | 17,373.55 |
pre_rebase_balance | Post rebase token balances. | 17,371.90 |
raw_shares_balance | Raw amount of token shares held. | 15,273,903,544,632,900,000,000 |
raw_shares_delta | Raw amount of token shares changed in the last token transfers. | 8,860,354,417,703,550,000,000 |
rebase_annualized_apr | Annualized APR on the day of the rebase. | 4.01775 |
rebase_block_number | Rebase block number. | 18,005,977 |
rebase_block_timestamp | Rebase block timestamp, this is slightly over 1200 hrs each day. | 2023-08-27 12:23:23 |
rebase_transaction_hash | Rebase transaction hash emitted by token contract. | 0x10390c921f56ff70cd8016d38971c8e85b8be4724b9fcb3492b5666402d723e4 |
last_activity_block_number | Last activity block number of token shares balance change. | 17,495,583 |
last_activity_block_timestamp | Last activity timestamp of token shares balance change. | 2023-06-16 23:12:23 |
last_activity_transaction_hash | Last activity crediting/debiting token shares into the account. | 0x28b09b69943db047197d77b517a6144b26c34c62cbcfab5d2e380c2b007c8ceb |
rebase_amount_str | Rebase amount in string to retain precision. | 1.654727361 |
post_rebase_balance_str | Post rebase token balances (in string to retain precision). | 17373.54979 |
pre_rebase_balance_str | Pre rebase token balances (in string). | 17371.89506 |
raw_shares_balance_str | Raw amount of token shares held (in string) | 15273903544632944992349 |
raw_shares_delta_str | Raw amount of token shares changed in the last token transfers (in string). | 8860354417703552690034 |
Last modified 1mo ago