zakkisyed(incorrect query)Holder distribution
    Updated 2023-04-24
    WITH user_net_worth AS (
    SELECT
    user_address,
    symbol,
    SUM(current_bal * usd_value_now) AS net_worth
    FROM ETHEREUM.core.ez_current_balances
    WHERE contract_address IN (
    '0x6982508145454ce325ddbe47a25d4ec3d2311933',
    '0x6b89b97169a797d94f057f4a0b01e2ca303155e4',
    '0x5026f006b85729a8b14553fae6af249ad16c9aab',
    '0x2f573070e6090b3264fe707e2c9f201716f123c7'
    )
    GROUP BY user_address, symbol
    )
    SELECT
    symbol,
    COUNT(CASE WHEN net_worth > 1000000 THEN user_address ELSE NULL END) AS over_1_million,
    COUNT(CASE WHEN net_worth > 100000 AND net_worth <= 1000000 THEN user_address ELSE NULL END) AS over_100k,
    COUNT(CASE WHEN net_worth > 10000 AND net_worth <= 100000 THEN user_address ELSE NULL END) AS over_10k,
    COUNT(CASE WHEN net_worth <= 1000 THEN user_address ELSE NULL END) AS less_equal_1000
    FROM user_net_worth
    where symbol in ({{token-symbol}})
    GROUP BY symbol;

    Run a query to Download Data