nitsIL protection over time (past week)
Updated 2022-05-18
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date(block_timestamp) as day, sum(il_protection_usd ) as total_il_protection_usd , count(*) as total_txs,
total_il_protection_usd /total_txs as amt_per_tx,
avg(amt_per_tx) over (order by day) as avg_amt_per_tx,
sum(total_txs) over (order by day) as cumulative_txs,
sum(total_il_protection_usd) over (order by day) as cumulative_il_protection_usd
from thorchain.liquidity_actions
where il_protection_usd is not NULL and il_protection_usd > 0 and day >= CURRENT_DATE -9
GROUP by 1
-- limit 100
Run a query to Download Data