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

Table	Rebase Frequency	Token
`ethereum.assets.steth_rebase`	Daily (~1200-1300 UTC)	Lido Staked ETH (stETH) https://docs.lido.fi/contracts/lido/

ethereum.assets.steth_rebase

Daily (~1200-1300 UTC)

Lido Staked ETH (stETH) https://docs.lido.fi/contracts/lido/

https://docs.lido.fi/contracts/lido/

Lido stETH Rebasing

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

Sample Query

-- 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

Table Column

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

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 updated 3 months ago