datavortexTop Withdrawer
    Updated 10 days ago
    SELECT
    sender_id AS "Withdrawer",
    COUNT(DISTINCT tx_hash) AS "Total Withdraw Transactions",
    SUM(amount_usd) AS "Total Withdrawn Volume",
    AVG(amount_usd) AS "Avg Withdrawn Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions = 'withdraw_succeeded'
    AND amount_usd IS NOT NULL
    GROUP BY
    sender_id
    ORDER BY
    "Total Withdrawn Volume" DESC
    LIMIT 10;

    Last run: 10 days ago
    Withdrawer
    Total Withdraw Transactions
    Total Withdrawn Volume
    Avg Withdrawn Amount
    1
    senlinear.near21375025395.6546156352231.904481763
    2
    838987aaa6529de31f87112b0b8c78fa05093d42d470027b4704fc47b414f56716968796124.1100758407077.65745607
    3
    nbiv.near5664598939.21533631153552.48598815
    4
    b43dfe70c1a1418d3ea0edfd7dda5dc2ebd1f3b68517f0783b2c91f96e6587e52637093731.55099621426681.98273062
    5
    a9619033e4961a601741e38f242cd7b6f27ab8fc0ac0c9a9746638e3f4fe75ed15433309629.9247742216296.29821282
    6
    b522c17b8fddc50a270eede8cef3a87ccac6a2e838b8e50ca2134086cddef19714531736470.7738961218872.212233766
    7
    858de8addcda96c5dae4e6b212441c7de56de1e1138b176d9f651c2eb471198880230995407.060356338647.63972613
    8
    dda7474fd3395823c20ea9d3afe8cd8752107097dab10f9a0f1c9d97e92ffaa26230755933.9825222496063.451331004
    9
    09c49beccf65857169602e04a668998dab2d61b4ef12691633714ba53c9e77082529540570.14292041181622.80571681
    10
    01e467af296980e4a5730171c8b181f69d4491661389f1867a1a0829acc9bd5b1927014372.26580011421809.06662106
    10
    957B
    10s