EVENT_NAME | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | Supply | 42142 | 8471 | 212336302.860275 | 5011.832389838 |
2 | Withdraw | 36407 | 6575 | 188079131.610308 | 5134.004793643 |
Afonso_Diazby event
Updated 2025-05-07
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
pricet as (
select
hour::date as dt,
token_address,
decimals,
symbol,
avg(price) as token_price_usd
from
aptos.price.ez_prices_hourly
group by 1, 2, 3, 4
),
main as (
select
tx_hash,
block_timestamp,
event_data:amount as amount_unadj,
token_address,
event_data:actor as user,
'Supply' as event_name
from
aptos.core.fact_events
join
aptos.core.fact_transfers transfers using (tx_hash)
where
payload_function = '0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::entry_public::lend_v2'
and event_type = '0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::lend::LendEvent'
and transfer_event = 'WithdrawEvent'
and user = transfers.account_address
and success
union all
select
Last run: 21 days ago
2
111B
72s