Eman-RazTop 20 Swap Routes By Volume
Updated 2024-04-01
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 tab8 as (with tab7 as (with tab5 as (with tab3 as (with tab1 as (select block_timestamp, contract_address as contract_in, origin_from_address,
origin_to_address, from_address, to_address, tx_hash, raw_amount
from base.core.fact_token_transfers
where from_address=origin_from_address
and ORIGIN_FUNCTION_SIGNATURE='0xcac88ea9'
and origin_to_address='0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43'),
tab2 as (select block_timestamp, contract_address as contract_out, origin_from_address,
origin_to_address, from_address, to_address, tx_hash, raw_amount
from base.core.fact_token_transfers
where to_address=origin_from_address
and ORIGIN_FUNCTION_SIGNATURE='0xcac88ea9'
and origin_to_address='0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43')
select tab1.block_timestamp as date, contract_in, contract_out, tab1.origin_from_address as trader, tab1.tx_hash as swap,
tab1.raw_amount as volume_in, tab2.raw_amount as volume_out
from tab1 left join tab2 on tab1.tx_hash=tab2.tx_hash),
tab4 as (select address, symbol, decimals, name
from base.core.dim_contracts)
select date, contract_in, symbol as symbol_in, decimals as decimals_in, contract_out, trader, swap, volume_in, volume_out
from tab3 left join tab4 on tab3.contract_in=tab4.address),
tab6 as (select address, symbol, decimals, name
from base.core.dim_contracts)
SELECT date, contract_in, case
when contract_in='0x4200000000000000000000000000000000000006' then 'WETH'
else symbol_in end as "Symbol In", case
when contract_in='0x4200000000000000000000000000000000000006' then 18
else decimals_in end as "Decimals In", case
when contract_out='0x4200000000000000000000000000000000000006' then 'WETH'
else symbol end as "Symbol Out", case
when contract_out='0x4200000000000000000000000000000000000006' then 18
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived