damidezpair volume
Updated 2024-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from payable-emerald @ https://flipsidecrypto.xyz/studio/queries/fd0bb8b7-579b-422c-b245-82df12a27f2f
SELECT
CONCAT(from_asset, ' --> ', to_asset) AS asset_pair,
COUNT(DISTINCT tx_id) AS transaction_count,
SUM(COALESCE(from_amount_usd, to_amount_usd)) AS volume_usd
FROM thorchain.defi.fact_swaps
WHERE affiliate_address = 'rg'
GROUP BY asset_pair
ORDER BY volume_usd DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived