rajsUntitled Query
    Updated 2023-01-11
    SELECT
    address,
    sum(amount) as amount,
    min(date_joined) as date_joined
    FROM
    (
    SELECT
    -- *
    sender as address,
    -sum(amount) / pow(10,6) as amount,
    min(block_timestamp) as date_joined
    from cosmos.core.fact_transfers
    where currency = 'uatom'
    group by 1

    UNION all

    SELECT
    -- *
    receiver as address,
    sum(amount) / pow(10,6) as amount,
    min(block_timestamp) as date_joined
    from cosmos.core.fact_transfers
    where currency = 'uatom'
    group by 1
    )
    group by 1
    order by 2 desc
    Run a query to Download Data