superflyUntitled Query
Updated 2022-10-26
9
1
2
3
4
5
›
⌄
select sum (balance/ power(10, 6)) AS balance, avg (balance/ power(10, 6)) AS AVG_balance,
median (balance/ power(10, 6)) AS median_balance, count(distinct(address)) AS holders
from osmosis.core.fact_daily_balances--- I US GENERAL TABEL
where 1 = 1 and date_trunc('day', date) = '2022-10-26'
and currency = 'uosmo'---BLOCKCHAON OSMOS
Run a query to Download Data