Sbhn_NPstablecoins deposit vs other
Updated 2023-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select 'Stablecoins' as type,
count(DISTINCT tx_hash) as txs,
sum(supplied_usd) as volume
from ethereum.aave.ez_deposits
where block_timestamp >= CURRENT_DATE - 90
and symbol in ('USDT','USDC','DAI')
group by 1
UNION ALL
select 'Other Tokens' as type,
count(DISTINCT tx_hash) as txs,
sum(supplied_usd) as volume
from ethereum.aave.ez_deposits
where block_timestamp >= CURRENT_DATE - 90
and symbol not in ('USDT','USDC','DAI')
group by 1
Run a query to Download Data