luisqaTop balances Osmosis
Updated 2023-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
osmosis.core.fact_daily_balances.ADDRESS AS Address,
sum(osmosis.core.fact_daily_balances.balance),
osmosis.core.dim_labels.PROJECT_NAME AS Token,
osmosis.core.fact_daily_balances.BALANCE_TYPE
from
osmosis.core.fact_daily_balances
INNER JOIN osmosis.core.dim_labels ON osmosis.core.fact_daily_balances.currency = osmosis.core.dim_labels.address
WHERE
osmosis.core.fact_daily_balances.date = '2023-04-03'
AND osmosis.core.dim_labels.PROJECT_NAME = 'STRD'
AND osmosis.core.dim_labels.PROJECT_NAME = 'OSMO'
AND osmosis.core.dim_labels.PROJECT_NAME = 'ATOM'
AND osmosis.core.dim_labels.PROJECT_NAME = 'STARS'
GROUP by
osmosis.core.dim_labels.PROJECT_NAME,
osmosis.core.fact_daily_balances.BALANCE_TYPE,
osmosis.core.fact_daily_balances.ADDRESS
ORDER BY
sum(osmosis.core.fact_daily_balances.balance) DESC
Run a query to Download Data