damidezfrom Assest by TRANSAC
Updated 2024-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from from Assest by volume @ https://flipsidecrypto.xyz/studio/queries/4558dc29-1d5c-4e1f-b2c9-98a7c5dc1d93
select
from_asset,
count(distinct tx_id) as transaction,
sum(coalesce(from_amount_usd, to_amount_usd)) as volume_usd
from thorchain.defi.fact_swaps
where affiliate_address = 'rg'
GROUP BY from_asset
order by transaction desc
LIMIT 10;
QueryRunArchived: QueryRun has been archived