SYMBOL_IN | TOTAL_TRANSACTIONS_STABLE | PERCENTAGE_TRANSACTIONS | TOTAL_SWAPPERS_STABLE | PERCENTAGE_SWAPPERS | TOTAL_VOLUME_STABLE | PERCENTAGE_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | BUSD | 797 | 0.01 | 369 | 0.1 | 8599.41 | 0 |
2 | DAI | 329519 | 5.58 | 55282 | 14.63 | 112783006.93 | 3.53 |
3 | USDT | 987815 | 16.72 | 125772 | 33.29 | 364628574.08 | 11.42 |
4 | USDC | 1511818 | 25.59 | 118924 | 31.47 | 1438670018.09 | 45.07 |
5 | EURS | 1023 | 0.02 | 290 | 0.08 | 649351.08 | 0.02 |
6 | UST | 2073 | 0.04 | 433 | 0.11 | 14237.76 | 0 |
7 | TUSD | 187 | 0 | 116 | 0.03 | 1791.3 | 0 |
datavortexpercentage
Updated 2025-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH all_tokens_totals AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions_all,
COUNT(DISTINCT origin_from_address) AS total_swappers_all,
SUM(amount_in_usd) AS total_volume_all
FROM polygon.defi.ez_dex_swaps
WHERE block_timestamp >= '{{ start_date }}'
AND block_timestamp < '{{ end_date }}'
),
stablecoin_totals AS (
SELECT
symbol_in,
COUNT(DISTINCT tx_hash) AS total_transactions_stable,
COUNT(DISTINCT origin_from_address) AS total_swappers_stable,
SUM(amount_in_usd) AS total_volume_stable
FROM polygon.defi.ez_dex_swaps
WHERE symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
AND block_timestamp >= '{{ start_date }}'
AND block_timestamp < '{{ end_date }}'
GROUP BY symbol_in
)
SELECT
symbol_in,
total_transactions_stable,
ROUND(total_transactions_stable * 100.0 / (SELECT total_transactions_all FROM all_tokens_totals), 2) AS percentage_transactions,
total_swappers_stable,
ROUND(total_swappers_stable * 100.0 / (SELECT total_swappers_all FROM all_tokens_totals), 2) AS percentage_swappers,
total_volume_stable,
ROUND(total_volume_stable * 100.0 / (SELECT total_volume_all FROM all_tokens_totals), 2) AS percentage_volume
FROM stablecoin_totals;
Last run: 19 days ago
7
311B
9s