zakkisyedNo. of LockUps
    Updated 2023-06-10
    WITH lockups AS (
    SELECT
    DATE_TRUNC('DAY', block_timestamp) AS date,
    origin_from_address AS address,
    COUNT(*) AS num_lockups,
    SUM(decoded_log:amount / 1e18) AS total_amount
    FROM ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address IN (
    '0xa3e8e8a08a7a27f65fc4c7fdf87db698cd4b1807',
    '0x45a4f6a4ecff0bbbca99f4c26a7086e6b6492f76',
    '0x027a5981cfe14a9f33486a89a4a05f7ca1116f6d'
    )
    AND event_name = 'Deposit'
    GROUP BY DATE_TRUNC('DAY', block_timestamp), origin_from_address
    ),
    generation_cycles AS (
    SELECT
    DATE_TRUNC('DAY', block_timestamp) AS date,
    CEIL(DATEDIFF('DAY', '2023-01-07', DATE_TRUNC('DAY', block_timestamp)) / 14) AS generation_number
    FROM ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address IN (
    '0xa3e8e8a08a7a27f65fc4c7fdf87db698cd4b1807',
    '0x45a4f6a4ecff0bbbca99f4c26a7086e6b6492f76',
    '0x027a5981cfe14a9f33486a89a4a05f7ca1116f6d'
    )
    AND event_name = 'Deposit'
    GROUP BY DATE_TRUNC('DAY', block_timestamp)
    )
    SELECT
    gc.generation_number AS generation,
    lc.date AS date,
    lc.num_lockups AS num_lockups,
    lc.total_amount AS total_amount
    FROM lockups lc
    Run a query to Download Data