DigitalDanOwnership Distribution copy
    Updated 2023-04-25
    -- forked from Ownership Distribution @ https://flipsidecrypto.xyz/edit/queries/ca5a59a6-f008-4e33-94a9-3a3f61762f5d

    WITH date_range AS (
    SELECT
    DATEADD('day', -1 * days, CURRENT_DATE()) AS balance_date
    FROM (
    SELECT
    ROW_NUMBER() OVER (ORDER BY seq4()) - 1 AS days
    FROM
    TABLE(GENERATOR(ROWCOUNT => 30))
    )
    ),

    daily_total_balance AS (
    SELECT
    date_range.balance_date,
    SUM(CURRENT_BAL) AS total_balance
    FROM
    date_range
    CROSS JOIN ethereum.core.ez_current_balances
    WHERE
    CONTRACT_ADDRESS = lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')
    AND DATE(LAST_ACTIVITY_BLOCK_TIMESTAMP) <= date_range.balance_date
    GROUP BY
    date_range.balance_date
    ),

    wallet_activity AS (
    SELECT
    USER_ADDRESS,
    MAX(DATE(LAST_ACTIVITY_BLOCK_TIMESTAMP)) AS last_activity_date
    FROM
    ethereum.core.ez_current_balances
    WHERE
    CONTRACT_ADDRESS = lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')
    GROUP BY
    Run a query to Download Data