shoa1bGMX - Number of Liquidated wallets - weekly
    Updated 2022-08-18
    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