mohammadhRUNE Movement from Crypto.com
    Updated 2022-06-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