farid-c9j0VMInflow vs Outflow (rune amount)
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with inflow as (
select
block_timestamp::date as day
,sum(RUNE_AMOUNT) as amount
from flipside_prod_db.thorchain.transfers
where FROM_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
and TO_ADDRESS LIKE 'thor%'
group by 1
)
, outflow as (
select
block_timestamp::date as day
,sum(RUNE_AMOUNT) as amount
from flipside_prod_db.thorchain.transfers
where TO_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
and FROM_ADDRESS LIKE 'thor%'
group by 1
)
select 'inflow' as Type,* from inflow
union all
select 'outflow' as Type,* from outflow
Run a query to Download Data