WITH from_transactions_cryptocom AS (

SELECT

to_date(block_timestamp) as date,

amount_e8 * (-1) as amount

FROM

thorchain.core.fact_transfer_events as c1

WHERE

c1.from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'

AND c1.asset = 'THOR.RUNE'

ORDER BY

date

),

to_transactions_cryptocom AS (

SELECT

to_date(block_timestamp) as date,

amount_e8 as amount

FROM

thorchain.core.fact_transfer_events as c1

WHERE

c1.to_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'

AND c1.asset = 'THOR.RUNE'

ORDER BY

date

),

transactions_all_cryptocom AS (

SELECT

*

FROM

from_transactions_cryptocom

UNION

ALL

SELECT

*

FROM

to_transactions_cryptocom