SYMBOL | UNIQUE_USERS | TOTAL_TRANSACTIONS | TOTAL_VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | USDt | 10321 | 48628 | 311473307.887412 | 6405.225546751 |
2 | USDC | 13587 | 134187 | 216947743.915633 | 1616.756793994 |
3 | FRAX | 428 | 4283 | 39638690.67963 | 9254.889255109 |
kravietzburrow Detailed Breakdown of Stablecoin Pool Metrics
Updated 2025-03-06
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
›
⌄
WITH stablecoin_pools AS (
SELECT
symbol,
COUNT(DISTINCT sender_id) AS unique_users,
COUNT(tx_hash) AS total_transactions,
SUM(amount_usd) AS total_volume_usd,
AVG(amount_usd) AS average_amount_usd
FROM
near.defi.ez_lending
WHERE
platform = 'burrow'
AND symbol ILIKE ANY ('USDt', 'USDC', 'FRAX')
AND actions IN ('deposit', 'increase_collateral')
AND block_timestamp >= '2024-08-01'
GROUP BY symbol
)
SELECT
symbol,
unique_users,
total_transactions,
total_volume_usd,
average_amount_usd
FROM
stablecoin_pools
ORDER BY total_volume_usd DESC
Last run: about 1 month ago
3
156B
3s