pouya_22Aave_deposits
Updated 2023-11-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_trunc(month, block_timestamp) date,
symbol,
count(DISTINCT tx_hash) txs,
count(DISTINCT depositor_address) users,
sum(supplied_usd) vol,
txs / users as tx_per_user,
vol / txs as vol_per_tx
FROM ethereum.aave.ez_deposits
WHERE symbol IS NOT NULL
GROUP BY 1,2
Run a query to Download Data