TOTAL_USERS | TOTAL_MINT_USERS | TOTAL_REDEEM_USERS | TOTAL_MINT_VOLUME | TOTAL_REDEEM_VOLUME | TOTAL_VOLUME | TVL | FEE | |
|---|---|---|---|---|---|---|---|---|
1 | 8609 | 8607 | 8601 | 2956829.48 | 2950890.23 | 5907719.71 | 5939.25 | 29508.9023 |
picwetotal count
Updated 2025-04-20
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 mint_events AS (
SELECT
date_trunc('day', block_timestamp) AS tx_date,
event_data:user::string AS user_address,
event_data:weUSDAmount::decimal AS mint_amount,
1 AS mint_count
FROM movement.core.fact_events
WHERE event_address = '0xed805e77c40d7e6ac5cd3e67514c485176621a2aa21e860cd515121d44a2f83d'
AND event_module = 'weusd_operations'
AND EVENT_RESOURCE = 'MintedWeUSD'
AND block_timestamp >= '2025-03-25'
),
redeem_events AS (
SELECT
date_trunc('day', block_timestamp) AS tx_date,
event_data:user::string AS user_address,
event_data:weUSDAmount::decimal AS redeem_amount,
1 AS redeem_count
FROM movement.core.fact_events
WHERE event_address = '0xed805e77c40d7e6ac5cd3e67514c485176621a2aa21e860cd515121d44a2f83d'
AND event_module = 'weusd_operations'
AND EVENT_RESOURCE = 'BurnedWeUSD'
AND block_timestamp >= '2025-03-25'
),
daily_stats AS (
SELECT
tx_date,
m.user_address,
SUM(mint_amount) AS mint_amount,
0 AS redeem_amount,
SUM(mint_count) AS mint_count,
0 AS redeem_count
FROM mint_events m
GROUP BY tx_date, user_address
UNION ALL
Last run: about 1 month ago
1
70B
3s