Vamp-2819circulating supply and ratio
Updated 2022-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with supply as(
select
balance_date,
sum(non_adjusted_balance)/pow(10,18) as balance
from ethereum.erc20_balances
where contract_address= lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0' )
and balance_date >= '2022-01-01'
and USER_ADDRESS not in ('0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2','0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff','0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca','0x50d669f43b484166680ecc3670e4766cdb0945ce')
group by balance_date),
stake as (
select date_trunc('day', block_timestamp) as day, sum(amount) as amount from ethereum.core.ez_token_transfers where
block_timestamp>='2022-01-01' and to_address=Lower('0x5e3Ef299fDDf15eAa0432E6e66473ace8c13D908')
group by 1
),
merge as (
select supply.balance_date, supply.balance, stake.amount, (stake.amount/supply.balance) as ratio from supply inner join stake on stake.day = supply.balance_date
)
select * from merge
Run a query to Download Data