boomer77new wallet creation
Updated 2022-01-16
9
1
2
3
4
5
6
7
8
›
⌄
with firstx as (select date(block_timestamp) as dt, to_address, ROW_NUMBER() OVER(PARTITION BY to_address ORDER BY block_timestamp ASC) as rank
from thorchain.transfers)
select dt, count(distinct to_address) as new_address, SUM(new_address) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_wallet
from firstx
where rank = 1
group by 1
Run a query to Download Data