damidezHolder list
    Updated 2025-01-03
    WITH transfers AS (
    -- Inflow and outflow data
    SELECT
    DATE(BLOCK_TIMESTAMP) AS date,
    'inflow' AS Flow,
    TX_TO AS wallet,
    AMOUNT / pow(10, decimal) AS amount,
    FROM eclipse.core.fact_transfers
    WHERE MINT = 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
    AND succeeded = 'TRUE'
    UNION ALL
    SELECT
    DATE(BLOCK_TIMESTAMP) AS date,
    'outflow' AS Flow,
    TX_FROM AS wallet,
    AMOUNT / pow(10, decimal) AS amount,
    FROM eclipse.core.fact_transfers
    WHERE MINT = 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
    AND succeeded = 'TRUE'
    )

    -- Calculate the current balance for each holder
    SELECT
    wallet,
    ROUND(SUM(CASE WHEN Flow = 'inflow' THEN amount ELSE -amount END)) AS holding_amount
    FROM transfers
    GROUP BY wallet
    ORDER BY holding_amount DESC
    limit 100;

    Last run: about 2 months ago
    WALLET
    HOLDING_AMOUNT
    1
    HKWEMPBY4zWn8x9ascmKWMGDhcr7WRwNrhAHyvTe1PJT11916170505
    2
    MooNKdkR6tUvY3V8k24YPfGmWNcHhggCousJNfb1MT79845824881
    3
    3fXnpaqT7sPqeAGZzUfHGYsDDfv8dRkXsgFWTzkvkHua4094261333
    4
    D6aUT8Ci33fMirJhET6amys5rqX8uFCPJMCGqyB9ZmZG2107889351
    5
    2XYZ9YpHsCFiBm4rqLKv7vtjcExH8whFrFDAN5Xqmbdk1291250384
    6
    4NDhXBxETJqZLiN4UKvuS9b6jr2ycWNVRVXLak5TaSGq1014010000
    7
    FuhDBdrNTbujE6uY8GhAU1yUQVJotGkKYbUCBumwEafQ989756000
    8
    954Kj3zjeRSbAWh72jd5mvmGu3EErFbdiNPFHdXrAnEv969389083
    9
    FVBRf5sSEKqJ7crWTT6FuPPgSeT8s3yShvqjtBn9Ff7i950953000
    10
    9M3gAgdbwaSa5z36rDF3W96NGCKhurFndP9YYrtgH6wY878199000
    11
    2LftXT4Pr8jTEx1VVkPsasP77wam6iz9ifgbRPR7zts7860035000
    12
    5G4F8iB78FFiv2Hes4LrPwc4vP3tLuHBnZTNyMce9Pge834546000
    13
    ENM3WJEXzTJ5jaDWRFETrthbRBARbtHtXqY29fNWjCYo829696000
    14
    JD2pdUUT8VRtUV2Z9AyDZ16WupA53n1RbbWdxUxosneP819995000
    15
    6ka9kdHJAvvFjTndvHtruhxV7qvh6AKWLA9fceLiHS41815230910
    16
    2dDX372ujLicSQwnAQcucxoppaFKGNTQTNQxRcDCRnMt815145000
    17
    hezgU57bhCF4ESn1tNutPGNH5SaEdutR6cEVenpZs9B776342000
    18
    AErC2AYerPYq7HufTwXkJxqaDk6u8idgsFm478FjVcod766642000
    19
    3NvNJ2caXvfTf2ZoeQT4JsakMjxCCd5q7XtjkXAH59KE708438000
    20
    GV6FjeorBGwY41epmEoMrgGZXA4eVK8cYY2XMJdLrc9t659935000
    100
    6KB
    1s