MostafaUntitled Query
Updated 2022-08-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
ORIGIN_FROM_ADDRESS as unstakers,
--date_trunc(week, block_timestamp) as date,
sum(EVENT_INPUTS:amount/pow(10,18)) as unstaked_aave
from ethereum.core.fact_event_logs
where contract_address = lower('0x4da27a545c0c5b758a6ba100e3a049001de870f5') -- stake aave contract
and block_timestamp>='2022-01-01'
and EVENT_NAME='Redeem'
and TX_STATUS='SUCCESS'
group by 1
order by 2 DESC
limit 10
Run a query to Download Data