Delamir-6014Untitled Query
    Updated 2022-11-17
    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