Eman-RazAXL Swaps Over Time
Updated 2025-06-13
999
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 ethereum as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in
when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out
end as swap_amount, case
when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in_usd
when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out_usd
end as swap_amount_usd, 'Ethereum' as "Chain"
from ethereum.defi.ez_dex_swaps
where (token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') or
token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3'))),
bsc as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
when token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_in
when token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_out
end as swap_amount, case
when token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_in_usd
when token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_out_usd
end as swap_amount_usd, 'Bsc' as "Chain"
from bsc.defi.ez_dex_swaps
where (token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') or
token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65'))),
polygon as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
when token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_in
when token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_out
end as swap_amount, case
when token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_in_usd
when token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_out_usd
end as swap_amount_usd, 'Polygon' as "Chain"
from polygon.defi.ez_dex_swaps
where (token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') or
token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940'))),
QueryRunArchived: QueryRun has been archived