Delamir-6014Untitled Query
Updated 2022-11-17
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
32
33
34
35
36
›
⌄
with algo as (
SELECT block.block_timestamp::date as date,
count(DISTINCT account.address) as count,
sum(count) over(order by date) as cumu_users
from algorand.account as account, algorand.block as block
where account.created_at = block.block_id
and date >= '2022-01-01'
group by date
order by date
),
terra_users as (
select * from (
select
value as user,
min(block_timestamp) as first_use,
count(distinct tx_id) as txs
from terra.transactions t,
lateral flatten(input => t.tx_from)
group by 1
)
where first_use > '2022-01-01'
),
terra as (select *,
sum(users) over(order by first_date) as cum_users
from (
select
date(first_use) as first_date,
count(distinct user) as users
from terra_users
group by 1
order by 1
)),
eth_users as (
select * from (
Run a query to Download Data