Query editor
with transfers as(select block_date, amount-- select min(block_date)from tokens.transferswhere blockchain = 'ethereum'and block_month >= date('2024-03-01')and contract_address = 0x3c3a81e81dc49A522A592e7622A7E711c06bf354and "to" = 0xc54cb22944F2bE476E02dECfCD7e3E7d3e15A8Fbunion allselect block_date, -amountfrom tokens.transferswhere blockchain = 'ethereum'and block_month >= date('2024-03-01')and contract_address = 0x3c3a81e81dc49A522A592e7622A7E711c06bf354and "from" = 0xc54cb22944F2bE476E02dECfCD7e3E7d3e15A8Fb),t1 as(select block_date as dt-- ,sum(amount) amount,SUM(SUM(amount)) OVER (ORDER BY block_date) AS supplyfrom transfersgroup by 1),t2 as(select *,LAG(supply,1) OVER (ORDER BY dt) as supply_1,LAG(supply,7) OVER (ORDER BY dt) as supply_7from t1-- where dt >= date('2025-01-01') and dt < current_date)select *,cast(supply as double)/cast(supply_1 as double)*100-100 as change_1d,cast(supply as double)/cast(supply_7 as double)*100-100 as change_7d,supply/1000000 as supply_afrom t2ORDER BY 1 DESC