flipside

    Holder More than 1 rwa
    datavortexHolder More than 1 rwa
    Updated 2025-04-16
    WITH transfers AS (
    SELECT
    contract_address,
    LOWER('0x' || SUBSTR(topics[1], 27)) AS from_address,
    LOWER('0x' || SUBSTR(topics[2], 27)) AS to_address,
    CAST(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64)) AS FLOAT) /
    CASE
    WHEN contract_address = LOWER('0xad6605f4987031fd2d6d6816be53eb7c5b764bf7') THEN POWER(10, 6)
    WHEN contract_address = LOWER('0x53fc82f14f009009b440a706e31c9021e1196a2f') THEN POWER(10, 6)
    WHEN contract_address = LOWER('0xe08b4c1005603427420e64252a8b120cace4d122') THEN POWER(10, 18)
    WHEN contract_address = LOWER('0x7c6a937943f135283a2561938de2200994a8f7a7') THEN POWER(10, 8)
    WHEN contract_address = LOWER('0x7c64925002bfa705834b118a923e9911bee32875') THEN POWER(10, 6)
    WHEN contract_address = LOWER('0x0b84f124596dac26010a9f79b7d8feade4ebbdbf') THEN 1
    WHEN contract_address = LOWER('0xbb9360d57f68075e98d022784c12f2fda082316b') THEN POWER(10, 6)
    WHEN contract_address = LOWER('0xbfdef5e389bb403426337081ecd1d05bc5193203') THEN POWER(10, 6)
    WHEN contract_address = LOWER('0x3a206f8f7cec45f1bd48ee5f370d04f609504d56') THEN POWER(10, 6)
    END AS amount
    FROM avalanche.core.ez_decoded_event_logs
    WHERE event_name = 'Transfer'
    AND contract_address IN (
    LOWER('0xad6605f4987031fd2d6d6816be53eb7c5b764bf7'),
    LOWER('0x53fc82f14f009009b440a706e31c9021e1196a2f'),
    LOWER('0xe08b4c1005603427420e64252a8b120cace4d122'),
    LOWER('0x7c6a937943f135283a2561938de2200994a8f7a7'),
    LOWER('0x7c64925002bfa705834b118a923e9911bee32875'),
    LOWER('0x0b84f124596dac26010a9f79b7d8feade4ebbdbf'),
    LOWER('0xbb9360d57f68075e98d022784c12f2fda082316b'),
    LOWER('0xbfdef5e389bb403426337081ecd1d05bc5193203'),
    LOWER('0x3a206f8f7cec45f1bd48ee5f370d04f609504d56')
    )
    ),
    address_balances AS (
    SELECT
    contract_address,
    address,
    SUM(CASE WHEN direction = 'in' THEN amount ELSE -amount END) AS balance
    Last run: about 2 months ago
    Holder
    Number of Tokens Held
    Tokens Held
    Token Balances
    Percentage of Supply Held
    1
    		0xc09e8a0d3158e9b253e23b1f511cf34569bd47f93
    [ "XTBT", "$XEVT", "$XRV" ]
    [ 10899155.364576, 2044320.691349, 3993278.182195 ]
    [ "44.65%", "67.13%", "100%" ]
    2
    		0xfd1392c3299aafb06582c6b3690c4cc3a73bacf13
    [ "XTBT", "$XRV", "$XEVT" ]
    [ 37.769589, 5, 1.996536 ]
    [ "0%", "0%", "0%" ]
    3
    		0x121c5f97c58f5dee289812f83b98c9612bf1aa912
    [ "BUIDL", "$ACRED" ]
    [ 41279615.99999999, 5000 ]
    [ "78.26%", "100%" ]
    4
    		0x640c90869708f4cae26e724b1018c79b150cfebf2
    [ "$XEVT", "XTBT" ]
    [ 2.10076, 6.087979000000001 ]
    [ "0%", "0%" ]
    5
    		0xec58f252bc47f502273233c0d0ac4eb19a82cae72
    [ "$XEVT", "XTBT" ]
    [ 1000886.057792, 444046.728419 ]
    [ "32.87%", "1.82%" ]
    5
    595B
    8s