rajsUntitled Query
Updated 2023-01-11Copy Reference Fork
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
block_timestamp,
tx_id,
address,
amount
FROM
(
SELECT
block_timestamp,
tx_id,
sender as address,
-amount / pow(10,6) as amount
from cosmos.core.fact_transfers
where currency = 'uatom'
union ALL
SELECT
block_timestamp,
tx_id,
receiver as address,
amount / pow(10,6) as amount
from cosmos.core.fact_transfers
where currency = 'uatom'
)
where address = 'cosmos1my7d7egfkz5k00q97fmwdmvcmac02axmezapdc'
-- group by 1
order by 1
Run a query to Download Data