Eman-Raz$AXL Selling vs. Buying Over Time
Updated 2024-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct tx_hash) as "Swap Count",
case when token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then sum(amount_in)
when token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then sum(amount_out)
end as "Swap Volume ($AXL)",
case when token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then sum(amount_in_USD)
when token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then sum(amount_out_USD)
end as "Swap Volume ($USD)",
case when token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then 'Sell'
when token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' then 'Buy'
end as "Direction"
from ethereum.defi.ez_dex_swaps
where (token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3' or
token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3')
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1,5, token_in, token_out
order by 1
QueryRunArchived: QueryRun has been archived