with tab3 as (with tab1 as (select tx_hash, token_in as "Stablecoin", sum(amount_in) as volume, case when sum(amount_in)<=1 then 'V<=1 Unit' when sum(amount_in)>1 and sum(amount_in)<=10 then '110 and sum(amount_in)<=100 then '10100 and sum(amount_in)<=1000 then '1001000 and sum(amount_in)<=10000 then '1K10000 and sum(amount_in)<=100000 then '10K100000 and sum(amount_in)<=1000000 then '100K1000000 then 'V>1M Unit' end as "Classification" from near.defi.ez_dex_swaps where (token_in_contract='a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' or -- USDC.e token_in_contract='usdt.tether-token.near' or --USDt ** token_in_contract='dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near' or -- USDT.e token_in_contract='usn' or -- USN token_in_contract='6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near' or -- DAI token_in_contract='17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1') --USDC and amount_in<50000000 and token_in is not null group by 1,2), tab2 as (select tx_hash, token_out as "Stablecoin", sum(amount_out) as volume, case when sum(amount_out)<=1 then 'V<=1 Unit' when sum(amount_out)>1 and sum(amount_out)<=10 then '110 and sum(amount_out)<=100 then '10100 and sum(amount_out)<=1000 then '1001000 and sum(amount_out)<=10000 then '1K10000 and sum(amount_out)<=100000 then '10K100000 and sum(amount_out)<=1000000 then '100K1000000 then 'V>1M Unit' end as "Classification" from near.defi.ez_dex_swaps where (token_out_contract='a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' or -- USDC.e token_out_contract='usdt.tether-token.near' or --USDt ** token_out_contract='dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near' or -- USDT.e token_out_contract='usn' or -- USN token_out_contract='6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near' or -- DAI token_out_contract='17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1') --USDC and amount_out<50000000 and token_out is not null group by 1,2) select * from tab1 union all select * from tab2) select "Classification", count(distinct tx_hash) as "Swap Count", "Stablecoin" FROM TAB3 where "Stablecoin" is not null group by 1,3

⚫Performance analysis of stablecoins on the Near