Query editor
with ankr_supply as (select time, net_trend, sum(net_trend) over (order by time) as cum_supply_ankrfrom (select date_trunc('day', evt_block_time) as time, sum(value/1e18) as net_trendfrom (select evt_block_time, cast(value as double) as valuefrom erc20_ethereum.evt_Transferwhere contract_address = 0x8290333ceF9e6D528dD5618Fb97a76f268f3EDD4 --ankr tokenand "to" != 0x0000000000000000000000000000000000000000 -- Null Addressand "to" != 0x9c2578bf9e37eb1d0ddf45a410723d95e554cbdd --Team Vested Contractand evt_block_time >= date('2019-02-21') -- contract deployedunion allselect evt_block_time,(-1)*cast(value as double) as valuefrom erc20_ethereum.evt_Transferwhere contract_address = 0x8290333ceF9e6D528dD5618Fb97a76f268f3EDD4 --ankr tokenand "from" != 0x0000000000000000000000000000000000000000 -- Null Addressand "from" != 0x9c2578bf9e37eb1d0ddf45a410723d95e554cbdd -- Team Vested Contractand evt_block_time >= date('2019-02-21') -- contract deployed) xgroup by 1order by 1 desc) t),ankr_token_staking as (select time, net_trend, sum(net_trend) over (order by time) as total_staked_ankrfrom (select date_trunc('day', evt_block_time) as time, sum(amount/1e18) as net_trendfrom (select evt_block_time, cast(amount as double) as amountfrom ankr_ethereum.AnkrTokenStaking_evt_Delegated --delegated table, deposit ANKR tokenwhere evt_block_time >= date('2022-08-04') -- contract deployedunion allselect evt_block_time, (-1)*cast(amount as double) as amountfrom ankr_ethereum.AnkrTokenStaking_evt_Undelegated --undelegated table, withdraw ANKR tokenwhere evt_block_time >= date('2022-08-04') -- contract deployed) xgroup by 1order by 1 desc) t),ankr_price as (select day as time, round(avg(price), 6) as avg_pricefrom(select date_trunc('day', minute) as day, pricefrom prices.usd where blockchain = 'ethereum' and symbol = 'ANKR') xgroup by 1order by 1 desc)select time, cum_supply_ankr, cum_supply_ankr*avg_price as marketcap, total_staked_ankr,total_staked_ankr*avg_price as ankr_staked_usd,(total_staked_ankr/cum_supply_ankr)*100 as staked_percentfrom ankr_supplyleft join ankr_token_staking using (time)left join ankr_price using (time)order by 1 desc