Chain | Swap Count | Swapper Count | Swap Amount (SATOSHI) | Swap Amount (USD) | |
|---|---|---|---|---|---|
1 | Ethereum | 4887 | 1325 | 2238349.32013575 | 3618807.87 |
2 | Solana | 2804 | 578 | 247522.98159732 | 366490.79 |
3 | Base | 2158 | 456 | 263176.119478881 | 387882.44 |
Eman-RazSATOSHI Swap Stats
Updated 2025-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with overview as (with base as (with tab1 as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
when token_in=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217') then amount_in
when token_out=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217') then amount_out
end as swap_amount, case
when token_in=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217') then amount_in_usd
when token_out=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217') then amount_out_usd
end as swap_amount_usd
from base.defi.ez_dex_swaps
where (token_in=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217') or
token_out=lower('0x45e7eaedb8e3360f850c963c5419a5236e451217')))
select 'Base' as "Chain", count(distinct tx_hash) as "Swap Count",
count(distinct swapper) as "Swapper Count", sum(swap_amount) as "Swap Amount (SATOSHI)",
sum(swap_amount_usd) as "Swap Amount (USD)"
from tab1
where block_timestamp::date>='2025-01-01'
group by "Chain"),
ethereum as (with tab1 as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
when token_in=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c') then amount_in
when token_out=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c') then amount_out
end as swap_amount, case
when token_in=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c') then amount_in_usd
when token_out=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c') then amount_out_usd
end as swap_amount_usd
from ethereum.defi.ez_dex_swaps
where (token_in=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c') or
token_out=lower('0xcbf4d5efa82e32a9187385480a7c74cb062b956c')))
select 'Ethereum' as "Chain", count(distinct tx_hash) as "Swap Count",
count(distinct swapper) as "Swapper Count", sum(swap_amount) as "Swap Amount (SATOSHI)",
sum(swap_amount_usd) as "Swap Amount (USD)"
from tab1
where block_timestamp::date>='2025-01-01'
group by "Chain"),
Last run: 19 days ago
3
143B
15s