Sbhn_NP2024-06-28 12:43 PM
Updated 2024-10-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with base as (select DISTINCT sender,
from aptos.core.fact_events
join aptos.core.fact_transactions using(tx_hash)
where event_type = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387::event::PriceFeedUpdate'
)
select
sum(amount/pow(10,8)) as apt
from aptos.core.ez_native_transfers
where to_address = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387'
and from_address in (select sender from base)
QueryRunArchived: QueryRun has been archived