defi__joshTop 4 Latest Holders of $XSGD Token on Avalanche (AVAX) Chain as of March 18, 2025
    Updated 2025-03-19
    /*

    latest - transfers

    */


    --- LATEST HOLDERS OF XSGD TOKEN (CA: 0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e)
    --- https://snowscan.xyz/ (AVAX blockchain explorer)

    with raw as (
    select
    block_timestamp,
    from_address,
    to_address,
    amount
    from avalanche.core.ez_token_transfers
    where contract_address = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e'
    and block_timestamp::date = '2025-03-18'
    ),

    direction as (
    select
    block_timestamp,
    to_address as address,
    amount
    from raw
    union all
    select
    block_timestamp,
    from_address as address,
    -amount as amount
    from raw
    )
    Last run: about 1 month ago
    date and time of holding $XSGD
    holder
    $XSGD holding amount
    1
    2025-03-18 02:00:58.0000x490c58e7b3ceef022590f6f982da07a604cb6176545690.164061
    2
    2025-03-18 06:07:28.0000x23439166feec267f1a66e2815369a02f7b7920c4460792.374436
    3
    2025-03-18 06:07:54.0000x9b529bfd929d38d654d7f44ff3686a300c4c34ad460792.374436
    4
    2025-03-18 05:36:43.0000x9b529bfd929d38d654d7f44ff3686a300c4c34ad381095.934403
    5
    2025-03-18 06:01:04.0000xc638fc731ffd77b17c486f5ae4a85d40ad9db4fc276079.91457
    5
    435B
    1s