freemartianBalance Type Liquidity
Updated 2022-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with source as(
select
date,
balance_type,
PROJECT_NAME as token_name,
a.currency,
balance / POW(10, decimal) as adjusted_bal,
adjusted_bal * price as bal_usd
from osmosis.core.fact_daily_balances a LEFT JOIN osmosis.core.dim_labels b on a.currency = b.ADDRESS
LEFT JOIN osmosis.core.dim_prices c on LOWER(b.PROJECT_NAME) = lower(c.SYMBOL) and c.recorded_at = a.date
where 1=1
and date > CURRENT_DATE - 60
and token_name != 'INJ')
select
date,
balance_type,
sum(bal_usd)
from source
group by 1,2
Run a query to Download Data