misaghlbVelodrome Health (Redux) - staking
    Updated 2022-11-13
    with raw as (
    select LP_PROVIDER_ADDRESS , min(block_timestamp) as min_date
    from optimism.velodrome.ez_staking_actions
    group by LP_PROVIDER_ADDRESS
    )

    SELECT
    date_trunc('week', min_date) as date,
    count(distinct LP_PROVIDER_ADDRESS) as wallets,
    sum(wallets) over (order by date) as cumu_wallets
    from raw
    GROUP BY date
    Run a query to Download Data