Alihastam2023-06-05 01:34 PM
Updated 2023-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('day',block_timestamp) as date,
count (distinct tx_hash) as num_tx ,
count (distinct origin_from_address) as num_users,
sum (amount) as unstake_amount,
sum (amount_usd) as unstake_usd
from ethereum.core.ez_token_transfers
where FROM_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
and ORIGIN_TO_ADDRESS='0x4da27a545c0c5b758a6ba100e3a049001de870f5'
and block_timestamp >= CURRENT_DATE-90
and symbol='AAVE'
group by 1