zakkisyedPercentage holdings daily
    Updated 2023-05-05
    WITH daily_balances AS (
    SELECT
    contract_address,
    symbol,
    DATE(last_activity_block_timestamp) AS activity_date,
    COUNT(user_address) AS holder_count,
    SUM(current_bal) AS total_balance
    FROM ETHEREUM.core.ez_current_balances
    WHERE contract_address IN (
    '0x6982508145454ce325ddbe47a25d4ec3d2311933',
    '0x6b89b97169a797d94f057f4a0b01e2ca303155e4',
    '0x5026f006b85729a8b14553fae6af249ad16c9aab',
    '0x2f573070e6090b3264fe707e2c9f201716f123c7'
    )
    GROUP BY contract_address, symbol, DATE(last_activity_block_timestamp)
    ),
    daily_top_100_holders AS (
    SELECT
    contract_address,
    DATE(last_activity_block_timestamp) AS activity_date,
    SUM(current_bal) AS top_100_holders_balance
    FROM (
    SELECT
    *,
    ROW_NUMBER() OVER (PARTITION BY contract_address, DATE(last_activity_block_timestamp) ORDER BY current_bal DESC) AS row_num
    FROM ETHEREUM.core.ez_current_balances
    WHERE contract_address IN (
    '0x6982508145454ce325ddbe47a25d4ec3d2311933',
    '0x6b89b97169a797d94f057f4a0b01e2ca303155e4',
    '0x5026f006b85729a8b14553fae6af249ad16c9aab',
    '0x2f573070e6090b3264fe707e2c9f201716f123c7'
    )
    ) t
    WHERE row_num <= {{TopXholders}}
    GROUP BY contract_address, DATE(last_activity_block_timestamp)
    ),
    Run a query to Download Data