from thorchain.defi.fact_swaps_events where _DIRECTION = '2' and MEMO like '%+:%' and MEMO like '%/%' and block_timestamp is not null

group by day, asset order by day DESC),

prices AS (SELECT to_date(block_timestamp) as day, avg(asset_usd) as asset_usd, REPLACE(pool_name, '.', '/') as asset

from thorchain.price.fact_prices group by day, asset order by day DESC),

joined AS (SELECT a.day, COALESCE(a.amount, 0) as amount, asset_usd * a.amount as amount_usd, a.asset

from savers_adds as a left join prices as b on a.day = b.day and a.asset = b.asset)

select * from joined order by day DESC