BlockTrackertest
Updated 2024-09-04
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
›
⌄
select
sum(amount)
from (
select
sum(amount_e8) as amount
from thorchain.defi.fact_rune_pool_deposit_events
union all
select
-1* sum(amount_e8) / pow(10,8) as amount
from thorchain.defi.fact_rune_pool_withdraw_events
)
select *
from thorchain.defi.fact_rune_pool_withdraw_events
where rune_address = 'thor10cfzgzg25cp5yjrkyg5dr9p7dqh0xlsdhawwjc'
select *
from thorchain.core.fact_transfers
where from_address = 'thor10cfzgzg25cp5yjrkyg5dr9p7dqh0xlsdhawwjc'
select sum(RUNE_AMOUNT)
from thorchain.core.fact_transfers
where to_address = 'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0'
and asset = 'THOR.RUNE'
select *
from thorchain.defi.fact_liquidity_actions
where from_address = 'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0'
QueryRunArchived: QueryRun has been archived