Sandeshafter change
Updated 2022-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with ff as
(
select * from ethereum.erc20_balances
where contract_address='0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
and balance_date::date >= '2022-04-07'::timestamp
),
aft as
(
select balance_date::date as "date", count(user_address) as number_of_curators
from ff
where balance >=100
and "date" >= '2022-04-07'
group by "date"
)
select * from aft
Run a query to Download Data