Swap route

Updated 3 days ago

with

stablecoins as (

select '0x37a4dd9ced2b19cfe8fac251cd727b5787e45269' as token_address

union all

select '0xb75d0b03c06a926e488e2659df1a861f860bd3d1' as token_address

union all

select '0x059a6b0ba116c63191182a0956cf697d0d2213ec' as token_address

union all

select '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1' as token_address

union all

select '0x0bbda0f76e205fc6a160b90a09975fa443b3fe44' as token_address

main as (

select

tx_id,

block_timestamp,

swapper,

platform,

symbol_in,

symbol_out,

case

when amount_in_usd is not null then amount_in_usd

when amount_out_usd is not null then amount_out_usd

when token_in in (select token_address from stablecoins) then amount_in

when token_out in (select token_address from stablecoins) then amount_out

end as amount_usd,

Last run: 3 days ago

	SWAP_ROUTE	SWAPS	SWAPPERS	VOLUME_USD	AVERAGE_AMOUNT_USD	DAILY_AVERAGE_SWAPS	DAILY_AVERAGE_SWAPPERS
1	StableCoin => StableCoin	442333	21458	80375945.9920492	180.85501166	1242.508427	60.275281
2	StableCoin => Other tokens	1909377	76745	802216148.833571	404.403559019	5363.418539	215.575843
3	Other tokens => StableCoin	1907969	77701	804461032.665986	406.543125812	5344.45098	217.64986
4	Other tokens => Other tokens	2070205	203420	374031333.735673	171.801367285	5815.182584	571.404494

393B

flipside