STABLECOINS_MARKET_CAP | TVL_TOTAL | TOTAL_VOLUME_24H | XLM_PRICE | |
|---|---|---|---|---|
1 | 49081275.6900897 | 78093030.7975406 | 38310872.7488765 | 244.249168784 |
10BlockchainAggregé
Updated 2025-02-19
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 stablecoin_data AS (
SELECT
SELLING_ASSET_CODE AS token,
SUM(SELLING_AMOUNT) / 1e6 AS stablecoin_market_cap -- Correction pour Stellar stroops
FROM stellar.defi.fact_trades
WHERE SELLING_ASSET_CODE IN ('USDC', 'EURC', 'GOLD', 'TOKENIZED_BOND')
GROUP BY SELLING_ASSET_CODE
),
tvl_data AS (
SELECT
DATE_TRUNC('day', LEDGER_CLOSED_AT) AS date,
SUM(SELLING_AMOUNT) / 1e6 AS total_value_locked -- Ajustement d'échelle réduit
FROM stellar.defi.fact_trades
WHERE LEDGER_CLOSED_AT >= DATEADD(DAY, -7, CURRENT_DATE)
AND TRADE_TYPE = 1 -- Filtrer uniquement les entrées de TVL
GROUP BY DATE_TRUNC('day', LEDGER_CLOSED_AT)
),
volume_data AS (
SELECT
SUM(SELLING_AMOUNT) / 1e6 AS total_volume_24h -- Ajustement d'échelle réduit
FROM stellar.defi.fact_trades
WHERE LEDGER_CLOSED_AT >= DATEADD(HOUR, -24, CURRENT_DATE)
),
xlm_data AS (
SELECT
AVG(CAST(PRICE_N AS FLOAT) / NULLIF(CAST(PRICE_D AS FLOAT), 0)) AS xlm_price -- Correction du prix XLM
FROM stellar.defi.fact_trades
WHERE SELLING_ASSET_CODE = 'XLM'
AND LEDGER_CLOSED_AT >= DATEADD(DAY, -7, CURRENT_DATE)
)
SELECT
(SELECT SUM(stablecoin_market_cap) FROM stablecoin_data) AS stablecoins_market_cap,
(SELECT SUM(total_value_locked) FROM tvl_data) AS tvl_total,
(SELECT total_volume_24h FROM volume_data) AS total_volume_24h,
(SELECT xlm_price FROM xlm_data) AS xlm_price;
Last run: 29 days ago
1
68B
7s