zakkisyedNET Token Emissions
    Updated 2023-05-27
    WITH emissions AS (
    -- Calculate the unlocked supply (emissions) of the specified addresses over time
    SELECT DATE_TRUNC('day', last_activity_block_timestamp) AS date,
    user_address,
    SUM(current_bal) AS unlocked_supply,
    CASE
    WHEN user_address = '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68' THEN 'Community Treasury'
    WHEN user_address = '0x98830c37aa6abdae028bea5c587852c569092d71' THEN 'Association'
    WHEN user_address = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' THEN 'Eco Inc.'
    WHEN user_address = '0x99f98ea4a883db4692fa317070f4ad2dc94b05ce' THEN 'Association'
    WHEN user_address = '0xa28f219bf1e15f5217b8eb5f406bcbe8f13d16dc' THEN 'Claim Contract'
    END AS tag
    FROM ethereum.core.ez_current_balances
    WHERE contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
    AND user_address IN (
    '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68',
    '0x98830c37aa6abdae028bea5c587852c569092d71',
    '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca',
    '0x99f98ea4a883db4692fa317070f4ad2dc94b05ce',
    '0xa28f219bf1e15f5217b8eb5f406bcbe8f13d16dc'
    )
    GROUP BY DATE_TRUNC('day', last_activity_block_timestamp), user_address, tag
    )
    SELECT date,
    CASE
    WHEN unlocked_supply >= 0 THEN 'Received'
    ELSE 'Sent'
    END AS direction,
    ABS(unlocked_supply) AS unlocked_supply,
    SUM(ABS(unlocked_supply)) OVER (PARTITION BY user_address ORDER BY date) AS cumulative_emissions,
    tag
    FROM emissions
    ORDER BY date;

    Run a query to Download Data