mohammadhRUNE Movement from Crypto.com
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with A as (select count(TO_ADDRESS) as withdrawn_number,sum(RUNE_AMOUNT) as outflow_amount,
date_trunc('week', block_timestamp) as block_week
from flipside_prod_db.thorchain.transfers
where FROM_ADDRESS ='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
and TO_ADDRESS LIKE 'thor1%'
group by block_week),
B as (select count(FROM_ADDRESS) as deposit_number ,sum(RUNE_AMOUNT) as inflow_amount,
date_trunc('week', block_timestamp) as block_week
from flipside_prod_db.thorchain.transfers
where TO_ADDRESS ='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
and FROM_ADDRESS LIKE 'thor1%'
group by block_week)
select A.withdrawn_number,A.block_week ,A.outflow_amount,B.deposit_number, B.inflow_amount
from A inner join B on A.block_week=B.block_week
Run a query to Download Data