DAY | REFUND_COUNT | REFUND_COUNT_CUMULATIVE | |
|---|---|---|---|
1 | 2025-05-21 00:00:00.000 | 20903 | 7887909 |
2 | 2025-05-20 00:00:00.000 | 17398 | 7867006 |
3 | 2025-05-19 00:00:00.000 | 19293 | 7849608 |
4 | 2025-05-18 00:00:00.000 | 19085 | 7830315 |
5 | 2025-05-17 00:00:00.000 | 12235 | 7811230 |
6 | 2025-05-16 00:00:00.000 | 16610 | 7798995 |
7 | 2025-05-15 00:00:00.000 | 20554 | 7782385 |
8 | 2025-05-14 00:00:00.000 | 20447 | 7761831 |
9 | 2025-05-13 00:00:00.000 | 29482 | 7741384 |
10 | 2025-05-12 00:00:00.000 | 37661 | 7711902 |
11 | 2025-05-11 00:00:00.000 | 25615 | 7674241 |
12 | 2025-05-10 00:00:00.000 | 23764 | 7648626 |
13 | 2025-05-09 00:00:00.000 | 16725 | 7624862 |
14 | 2025-05-08 00:00:00.000 | 13504 | 7608137 |
15 | 2025-05-07 00:00:00.000 | 8849 | 7594633 |
16 | 2025-05-06 00:00:00.000 | 9226 | 7585784 |
17 | 2025-05-05 00:00:00.000 | 7098 | 7576558 |
18 | 2025-05-04 00:00:00.000 | 6889 | 7569460 |
19 | 2025-05-03 00:00:00.000 | 5039 | 7562571 |
20 | 2025-05-02 00:00:00.000 | 6715 | 7557532 |
pietrektRefund Events Count
Updated 9 hours ago
9
1
2
3
4
5
6
7
›
⌄
-- could be hourly
WITH refunds as (select block_timestamp, ROW_NUMBER() OVER(ORDER BY block_timestamp) as rownum from thorchain.defi.fact_refund_events order by block_timestamp),
refund_count as (select to_date(block_timestamp) as day, count(rownum) as refund_count, ROW_NUMBER() OVER(ORDER BY day) as rownum from refunds group by day),
refund_count_cumulative as (select day, refund_count, (select SUM(refund_count) from refund_count as b where b.rownum <= a.rownum) as refund_count_cumulative from refund_count as a)
select * from refund_count_cumulative WHERE day is not null order by day DESC
Last run: about 9 hours agoAuto-refreshes every 24 hours
...
1451
57KB
3s