flipside

    [LRON] - top 20 users by witdrawal volume
    saeedmzn[LRON] - top 20 users by witdrawal volume
    Updated 2025-04-02
    -- forked from [LRON] - top 20 users by deposit volume @ https://flipsidecrypto.xyz/studio/queries/223dc93e-c916-4876-81e7-2d46c6d94e9b

    with Ron_price as (
    SELECT
    hour::date as date,
    median (price ) usd_price
    FROM ronin.price.ez_prices_hourly
    WHERE symbol = 'RON'
    AND hour::date = DATEADD(day, -1, CURRENT_DATE)
    GROUP BY 1;
    ),
    deposit as (
    select
    block_timestamp ::date date ,
    tx_hash ,
    ORIGIN_FROM_ADDRESS user ,
    amount ,
    amount_usd
    from ronin.core.ez_token_transfers
    where origin_to_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
    and from_address <> '0x0000000000000000000000000000000000000000'
    and to_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
    ),
    withdraw as (
    select
    block_timestamp ::date date ,
    tx_hash ,
    ORIGIN_FROM_ADDRESS user ,
    amount ,
    amount_usd
    from ronin.core.ez_native_transfers
    where origin_from_address = to_address
    and from_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
    and origin_to_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
    ),
    final as (
    Last run: 27 days ago
    USER
    STAKED_AMOUNT
    1
    		0x24e4d38e2e71d1b403e8b2300ae185312e336ccb 35,232
    2
    		0x7aca694d1b4a2f6b81b2144c9819f13c07575c22 19,303
    3
    		0xe0a20b13952692bd13924fd9d0048c3b20e13262 17,317
    4
    		0x664e050f472166c3bb78903ac2bda09146388cbf 15,014
    5
    		0x98ae8d7f079ca44dd065534b0ba7e1083b6d3d32 11,343
    6
    		0x1810d7ebbb2c250ee89bd86adf50aa77286d8d13 10,005
    7
    		0x540fd165774f8de502e454ca11f4902c5bccd25d 5,004
    8
    		0xf51eb9e5f56edb1c12404a898c63a10d37fc63f9 5,001
    9
    		0x65314eeb6e7edab42d1017cbe59d0dfbc313aa0d 4,658
    10
    		0x162d6f99d6c8f0da37380d6f27736ab83afadd72 3,300
    11
    		0x1f7c0a8275bf61763dfc2bcb5a59e38b63573bfb 3,000
    12
    		0xdc9ffaa7596a8e4e39592ffa4ab7293c07c24ed7 2,701
    13
    		0xa9183eafda1c7c812a9dd7d9eb093f2e229f8eb7 2,500
    14
    		0xc0a52e8073f8c90a4c41a91b30b155185038d9cb 2,000
    15
    		0xc021f6f0dd6fbeb1ed0c9bb3274b41f5223bed84 1,885
    16
    		0x3988ca41661f3133a75cdacdeab8e08e44a89de3 1,703
    17
    		0x216aa7d4be95c8023b25e90ef64990dc87b8a1af 1,640
    18
    		0x9a93d59d0549f33ba214c9c9e4edbb0ba4f7933f 1,637
    19
    		0xbb2c68f5fa8e227ae8b41a2b41e68c1957fb92bc 1,615
    20
    		0x914f9dbba991ee2b87df935a97cd307f1638269a 1,520
    20
    1KB
    3s