Pmisha-bmlMdxcurator
Updated 2022-04-24
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
Select BALANCE_DATE as dt,
count(user_address) as curator,
sum(balance) as total_balance,
sum(curator) over (order by dt asc) as cummlative,
sum(amount_usd) as total_balance_in_usd
from ethereum.erc20_balances
where contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
and balance >= 1000
and BALANCE_DATE >= '2021-06-01'
and BALANCE_DATE <= CURRENT_DATE-5
group by dt
order by dt
Run a query to Download Data