flipside

    powerful-violet
    i_danpowerful-violet
    Updated 2025-01-21
    --SELECT
    -- program_name
    -- , count(*)
    --FROM crosschain.olas.ez_olas_staking
    --GROUP BY 1

    WITH first_stake AS (

    SELECT
    origin_from_address
    , MIN(block_timestamp) AS first_stake_date
    FROM
    crosschain.olas.ez_olas_staking
    GROUP BY
    1
    )--,

    --subsequent_stakes AS (

    SELECT
    s.origin_from_address
    , s.block_timestamp
    FROM
    crosschain.olas.ez_olas_staking s
    JOIN
    first_stake f ON s.origin_from_address = f.origin_from_address
    WHERE
    s.block_timestamp > f.first_stake_date
    ),

    groups AS (

    SELECT
    origin_from_address
    , EXTRACT(week FROM first_stake_date) AS group_week
    FROM
    QueryRunArchived: QueryRun has been archived