Alexaytotal usd swaps
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with aeth as (select sum(amount_in_usd) as usd, 'aeth' as t
from ethereum.core.ez_dex_swaps
where pool_name like '%aETH%' and amount_in_usd>0),
reth as ( select sum(amount_in_usd) as usd, 'reth' as t
from ethereum.core.ez_dex_swaps
where pool_name like '%rETH%' and amount_in_usd>0),
steth as ( select sum(amount_in_usd) as usd, 'steth' as t
from ethereum.core.ez_dex_swaps
where pool_name like '%stETH%' and amount_in_usd>0)
select * from aeth
union
select * from reth
UNION
select * from steth
Run a query to Download Data