roketa5
Updated 2022-12-01
9
1
2
3
4
5
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/d98304de-24d4-4251-8c39-e22b4f5c2d4f
select count(distinct osmosis.core.fact_daily_balances.ADDRESS ) , sum(BALANCE/pow(10,6)) , avg(BALANCE/pow(10,6))
from osmosis.core.fact_daily_balances inner join osmosis.core.dim_labels
on currency=osmosis.core.dim_labels.address
where date='2022-11-27' and PROJECT_NAME ='AXL'
Run a query to Download Data