SpecterAverage Liquidation daily
Updated 2024-05-02
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
›
⌄
WITH WhAvgliquidation AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,
PLATFORM,
count(TX_HASH) AS TransactionCount
FROM
arbitrum.defi.ez_lending_liquidations
WHERE
Date != CURRENT_DATE
AND date >= '2024-01-1'
GROUP BY
Date,
PLATFORM
ORDER BY
Date
)
SELECT
Date,
Platform,
AVG(TransactionCount)
FROM
WhAvgliquidation
GROUP BY
Platform,
Date
QueryRunArchived: QueryRun has been archived