mo115NEAR stablecoin swaps - Top 10 Gainers
Updated 2024-08-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from NEAR stablecoin swaps - Daily - 30Days @ https://flipsidecrypto.xyz/studio/queries/e43cb7c9-bfc0-4b9a-a046-a04e584bc9f0
-- forked from NEAR stablecoin swaps @ https://flipsidecrypto.xyz/studio/queries/17f3209b-a6bf-43e2-97d4-a16664e71541
select
count (distinct TX_HASH) as "Transactions"
, TRADER as "Wallet"
, (sum(AMOUNT_OUT)-sum(AMOUNT_IN)) as diff
from near.defi.ez_dex_swaps
where SYMBOL_OUT in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')
and SYMBOL_IN in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')
group by 2
order by 3 DESC
limit 10
QueryRunArchived: QueryRun has been archived