TOKEN | TOTAL_POOLS | TOTAL_TRANSACTIONS | TOTAL_VOLUME_SOLD | TOTAL_VOLUME_BOUGHT | |
|---|---|---|---|---|---|
1 | GOLD | 54 | 9876790 | 811283032973.323 | 1320623495290.49 |
2 | USDC | 243 | 377303493 | 157781860877.932 | 910617596764.762 |
3 | EURC | 40 | 15197310 | 199970305.629286 | 186834002.998577 |
10BlockchainAnalyse des RWAs sur Stellar : Volumes, Transactions et Pools de Liquidité
Updated 2025-02-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
35
36
›
⌄
WITH token_pools AS (
SELECT
lp.LIQUIDITY_POOL_ID,
CASE
WHEN lp.ASSET_A_TYPE = 'native' THEN 'XLM'
ELSE lp.ASSET_A_CODE
END AS token_a,
CASE
WHEN lp.ASSET_B_TYPE = 'native' THEN 'XLM'
ELSE lp.ASSET_B_CODE
END AS token_b
FROM stellar.defi.fact_liquidity_pools AS lp
),
all_tokens AS (
SELECT
LIQUIDITY_POOL_ID,
token_a AS token
FROM token_pools
WHERE token_a IN ('USDC', 'EURC', 'GOLD', 'TOKENIZED_BOND')
UNION ALL
SELECT
LIQUIDITY_POOL_ID,
token_b AS token
FROM token_pools
WHERE token_b IN ('USDC', 'EURC', 'GOLD', 'TOKENIZED_BOND')
),
recent_trades AS (
SELECT
HISTORY_OPERATION_ID,
SELLING_LIQUIDITY_POOL_ID,
BUYING_ASSET_CODE,
SELLING_ASSET_CODE,
SELLING_AMOUNT,
BUYING_AMOUNT
Last run: 30 days ago
3
167B
11s