zakkisyedRUNE Movement
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
›
⌄
select date_trunc(week,block_timestamp) as date, movement, sum(rune_amount) as RUNE, sum(rune_amount_usd) as USD
from
(
select block_timestamp, from_address, to_address, rune_amount, RUNE_AMOUNT_USD,
CASE WHEN from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6' then 'Outflow'
else 'Inflow'
end as movement
from flipside_prod_db.thorchain.transfers
where from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
or to_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
)
group by 1,2
order by 1 desc
Run a query to Download Data