rajsUntitled Query
Updated 2023-01-11
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
›
⌄
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