theericstoneAlchemix Farmers
    Updated 2023-03-09
    -- where can you see how many people are farming?

    WITH farmers_daily AS (
    SELECT DISTINCT origin_address AS address,
    date_trunc('day',block_timestamp) AS DATE
    FROM ethereum.udm_events
    WHERE contract_address = '0xab8e74017a8cc7c15ffccd726603790d26d7deca'
    AND event_name = 'TokensDeposited'
    AND block_timestamp > '2021-02-20'
    ),

    firstseen_dep AS (
    SELECT address, MIN(date) AS date
    FROM farmers_daily
    GROUP BY 1
    ),

    daily_tally AS (
    select date, count(address) as daily_new_depositors
    from firstseen_dep
    group by date
    order by 1 desc
    )

    select
    date,
    daily_new_depositors,
    sum(daily_new_depositors) OVER (ORDER BY daily_tally.date ASC ROWS BETWEEN unbounded preceding AND CURRENT row) AS cumulative_alcxslp_depositors
    from daily_tally
    order by date desc;

    Run a query to Download Data