DATE | SIMPLIFIED_REASON | REFUND_COUNT | |
|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | emit asset | 213123 |
2 | 2024-11-11 00:00:00.000 | emit asset | 153726 |
3 | 2025-01-20 00:00:00.000 | emit asset | 150826 |
4 | 2025-01-27 00:00:00.000 | emit asset | 149146 |
5 | 2024-12-02 00:00:00.000 | emit asset | 133671 |
6 | 2025-01-13 00:00:00.000 | emit asset | 132126 |
7 | 2025-03-03 00:00:00.000 | emit asset | 125079 |
8 | 2024-11-18 00:00:00.000 | emit asset | 118962 |
9 | 2024-11-04 00:00:00.000 | emit asset | 104408 |
10 | 2024-12-16 00:00:00.000 | emit asset | 101923 |
11 | 2025-02-17 00:00:00.000 | emit asset | 101405 |
12 | 2024-11-25 00:00:00.000 | emit asset | 97891 |
13 | 2025-02-03 00:00:00.000 | emit asset | 96733 |
14 | 2025-03-10 00:00:00.000 | emit asset | 96071 |
15 | 2025-01-06 00:00:00.000 | emit asset | 95198 |
16 | 2024-03-11 00:00:00.000 | emit asset | 87502 |
17 | 2024-12-09 00:00:00.000 | emit asset | 86845 |
18 | 2024-03-04 00:00:00.000 | emit asset | 80133 |
19 | 2024-08-05 00:00:00.000 | emit asset | 77888 |
20 | 2024-03-18 00:00:00.000 | emit asset | 73463 |
Specterthorchain refund reason
Updated 2025-03-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
›
⌄
-- forked from thorchain refund @ https://flipsidecrypto.xyz/studio/queries/c6cf7660-a123-43ae-9812-714f97f724aa
SELECT DATE_TRUNC('week', block_timestamp) AS date,
CASE
WHEN LOWER(Reason) LIKE 'fail swap%' THEN 'fail swap'
WHEN LOWER(Reason) LIKE 'fail to process withdraw request%' THEN 'fail to process withdraw request'
WHEN LOWER(Reason) LIKE 'fail to add outbound tx%' THEN 'fail to add outbound tx'
WHEN LOWER(Reason) LIKE 'emit asset%' THEN 'emit asset'
WHEN LOWER(Reason) LIKE 'zero emit asset%' THEN 'zero emit asset'
WHEN LOWER(Reason) LIKE '2 errors occurred%' THEN '2 errors occurred'
WHEN LOWER(Reason) LIKE 'memo%' THEN 'memo'
WHEN LOWER(Reason) LIKE 'unable to withdraw%' THEN 'unable to withdraw'
WHEN LOWER(Reason) LIKE 'observed inbound tx%' THEN 'observed inbound tx'
WHEN LOWER(Reason) LIKE 'output rune%' THEN 'output rune'
WHEN LOWER(Reason) LIKE 'insufficient synth capacity%' THEN 'insufficient synth capacity'
WHEN LOWER(Reason) LIKE 'trading is halted%' THEN 'trading is halted'
WHEN LOWER(Reason) LIKE 'invalid tx type%' THEN 'invalid tx type'
ELSE Lower(Reason)
END AS simplified_reason,
COUNT(DISTINCT tx_id) AS refund_count
FROM thorchain.defi.fact_refund_events
WHERE block_timestamp >= '2024-01-01'
GROUP BY date, simplified_reason
ORDER BY refund_count DESC
Last run: about 1 month ago
...
937
67KB
2s