nitsDeposit 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(supplied_usd) as total_supplied_value,
sum(total_supplied_value) over(partition by symbol order by day) as cum_supplied_value,
cum_supplied_value/cum_txs as deposited_amt_per_tx
from aave.deposits
where depositor_address = {{addr}}
GROUP by 1, 2
-- limit 100
Run a query to Download Data