boomer77wallet creation terra
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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, case
when dt >= '2022-03-25' then 'Post_integration'
else 'Pre_Intergration' end as terra
from firstx
where rank = 1 and year(dt) = '2022'
group by 1
Run a query to Download Data