0xasmrUntitled Query
    Updated 2022-08-16
    SELECT
    CONCAT('0x', SUBSTRING(input_data, 10, 64)) AS wallet_address,
    COUNT(tx_hash) AS liquidation_count
    FROM avalanche.core.fact_transactions
    WHERE origin_function_signature = '0xde2ea948'
    AND block_timestamp > CURRENT_DATE() - interval '3 months'
    GROUP BY 1
    ORDER BY 1 DESC
    Run a query to Download Data