shoa1bGMX - Number of Liquidated wallets - weekly
Updated 2022-08-18Copy Reference Fork
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
›
⌄
WITH gmx_liquidations_base AS (
SELECT
block_timestamp,
tx_hash,
event_inputs:to AS wallet_address
FROM
avalanche.core.fact_event_logs
WHERE
1 = 1
AND block_timestamp::DATE BETWEEN '2022-07-01' AND '2022-08-01'
-- AND tx_hash = LOWER('0xd4b34453a97c92892040977fd4786c4d0d8c34b4131ccd690cebef729512388c')
AND origin_to_address = LOWER('0xf2ec2e52c3b5f8b8bd5a3f93945d05628a233216') -- gmx position manager
AND origin_function_signature = '0xde2ea948'
AND event_inputs:from = LOWER('0x9ab2de34a33fb459b538c43f251eb825645e8595') -- gmx vault
AND event_inputs:to != origin_from_address
)
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(wallet_address) AS liquidated_wallets_count
FROM
gmx_liquidations_base
GROUP BY
week;
Run a query to Download Data