pietrektSavers liquidity withdrawals
Updated 2023-11-02
9
1
2
3
4
5
6
7
›
⌄
WITH savers_withdraws AS (SELECT to_date(block_timestamp) as day, REPLACE(asset, '.', '/') as asset, sum((emit_asset_e8 / POW(10,8))) as amount from thorchain.defi.fact_withdraw_events where 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, a.amount, asset_usd * a.amount as amount_usd, a.asset from savers_withdraws as a left join prices as b on a.day = b.day and a.asset = b.asset)
select * from joined order by day DESC
Run a query to Download Data