boomer77ust vs dai mcap
Updated 2022-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select balance_date as date, sum(balance) as marketcap, 'DAI' as coin
from ethereum.erc20_balances
where contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') and balance_date >= '2022-01-01'
group by 1
union
select date, sum(balance) as marketcap, 'UST' as coin
from terra.daily_balances
where currency in ('UST')
and address not in ('terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh', 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6','terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts',
'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f')
and year(date) = '2022'
group by 1
Run a query to Download Data