theericstoneAlchemix Farmers
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
-- 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