with final_tab as (with tab1 as (select tx_id, case when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' then 'USDC.eth' when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp' then 'USDC.matic' when currency_in='ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349' then 'USDC.axl' when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/HktfLoADCk9mnjv7XJiN4YXK9ayE6xinLzt8wzcsR2rY' then 'USDT.eth' when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH' then 'USDC.sol' when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' then 'USDC.arb' when currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu' then 'USDC.op' end as "Stablecoin", sum(amount_in)/pow(10,6) as volume, case when sum(amount_in)/pow(10,6)<=1 then 'Balance<=1 Unit' when sum(amount_in)/pow(10,6)>1 and sum(amount_in)/pow(10,6)<=10 then '110 and sum(amount_in)/pow(10,6)<=100 then '10100 and sum(amount_in)/pow(10,6)<=1000 then '1001000 and sum(amount_in)/pow(10,6)<=10000 then '1K10000 and sum(amount_in)/pow(10,6)<=100000 then '10K100000 and sum(amount_in)/pow(10,6)<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from sei.defi.fact_dex_swaps where (currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' or -- 'USDC.eth' currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp' or -- 'USDC.matic' currency_in='ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349' or -- 'USDC.axl' currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/HktfLoADCk9mnjv7XJiN4YXK9ayE6xinLzt8wzcsR2rY' or -- 'USDT.eth' currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH' or -- 'USDC.sol' currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' or -- 'USDC.arb' currency_in='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu') -- 'USDC.op' group by 1,2), tab2 as (select tx_id, case when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' then 'USDC.eth' when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp' then 'USDC.matic' when currency_out='ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349' then 'USDC.axl' when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/HktfLoADCk9mnjv7XJiN4YXK9ayE6xinLzt8wzcsR2rY' then 'USDT.eth' when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH' then 'USDC.sol' when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' then 'USDC.arb' when currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu' then 'USDC.op' end as "Stablecoin", sum(amount_out)/pow(10,6) as volume, case when sum(amount_out)/pow(10,6)<=1 then 'Balance<=1 Unit' when sum(amount_out)/pow(10,6)>1 and sum(amount_out)/pow(10,6)<=10 then '110 and sum(amount_out)/pow(10,6)<=100 then '10100 and sum(amount_out)/pow(10,6)<=1000 then '1001000 and sum(amount_out)/pow(10,6)<=10000 then '1K10000 and sum(amount_out)/pow(10,6)<=100000 then '10K100000 and sum(amount_out)/pow(10,6)<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from sei.defi.fact_dex_swaps where (currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' or -- 'USDC.eth' currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp' or -- 'USDC.matic' currency_out='ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349' or -- 'USDC.axl' currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/HktfLoADCk9mnjv7XJiN4YXK9ayE6xinLzt8wzcsR2rY' or -- 'USDT.eth' currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH' or -- 'USDC.sol' currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' or -- 'USDC.arb' currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu') -- 'USDC.op' group by 1,2) select * from tab1 union all select * from tab2) select "Classification", count(distinct tx_id) as "Swap Count", "Stablecoin" FROM final_tab group by 1,3

🌊Performance analysis of stablecoins on the Sei