with tab3 as (with tab1 as (select tx_hash, symbol_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 block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and (token_in_contract='6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near' or -- DAI token_in_contract='usn' or -- USN token_in_contract='fusd.tkn.near' or -- FUSD token_in_contract='usdt.tether-token.near' or -- USDt token_in_contract='17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1' or -- USDC token_in_contract='a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' or -- USDC.e token_in_contract='dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near') -- USDT.e group by 1,2), tab2 as (select tx_hash, symbol_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 block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and (token_out_contract='6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near' or -- DAI token_out_contract='usn' or -- USN token_out_contract='fusd.tkn.near' or -- FUSD token_out_contract='usdt.tether-token.near' or -- USDt token_out_contract='17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1' or -- USDC token_out_contract='a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' or -- USDC.e token_out_contract='dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near') -- USDT.e group by 1,2) select * from tab1 union all select * from tab2) select "Classification", count(distinct tx_hash) as "Swap Count", "Stablecoin" FROM TAB3 group by 1,3

Analysis of Stablecoins Performance on the Near Protocol