nitsWithdrawal Stats by User
Updated 2022-08-13
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date(block_timestamp) as day, symbol, count(DISTINCT tx_id) as total_txs,
sum(total_txs) over (partition by symbol order by day) as cum_txs,
sum(withdrawn_usd) as total_withdrawn_value,
sum(total_withdrawn_value) over(partition by symbol order by day) as cum_withdrawn_value,
cum_withdrawn_value/cum_txs as withdrawn_amt_per_tx
from aave.withdraws
where depositor_address = {{addr}}
GROUP by 1, 2
-- limit 100
Run a query to Download Data