Eman-Raz🔎Tracking of $AXL Swaps (Last 1000 Swaps)
Updated 2024-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select block_timestamp as "Hour", case
when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then '🔴Sell'
when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then '🟢Buy'
end as "Sell/Buy",
case
when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in
when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out
end as "Swap Amount ($AXL)", case
when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in_usd
when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out_usd
end as "Swap Amount ($USD)", symbol_in || '➡' || symbol_out as "Token Pair", platform AS dex,
origin_from_address as "Swapper"
from ethereum.defi.ez_dex_swaps
where (token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') or
token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3'))
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
order by 1 desc
limit 1000
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived