EVENT_NAME | SYMBOL | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|---|
1 | Borrow | APT | 512 | 339 | 35835446.8525922 | 69991.107133969 |
2 | Borrow | USDC | 2090 | 1096 | 4979006.27023503 | 2382.29965083 |
3 | Borrow | USDT | 1033 | 682 | 1662152.35974217 | 1609.053591232 |
4 | Borrow | aBTC | 2920 | 2491 | 25714978.4256162 | 8806.499460827 |
Afonso_Diazby symbol and event
Updated 2025-04-10
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,
avg(price) as token_price_usd
from
aptos.price.ez_prices_hourly
where
token_address != '0x4e1854f6d332c9525e258fb6e66f84b6af8aba687bbcb832a24768c4e175feec::abtc::ABTC'
and dt >= '2024-08-27'
group by 1, 2
union all
select
hour::date as dt,
token_address,
avg(price) as token_price_usd
from
aptos.price.ez_prices_hourly
where
token_address = '0x4e1854f6d332c9525e258fb6e66f84b6af8aba687bbcb832a24768c4e175feec::abtc::ABTC'
and dt >= '2024-10-18'
group by 1, 2
union all
select
hour::date as dt,
'0x4e1854f6d332c9525e258fb6e66f84b6af8aba687bbcb832a24768c4e175feec::abtc::ABTC' as token_address,
avg(price) as token_price_usd,
from
crosschain.price.ez_prices_hourly
where
Last run: about 2 months ago
4
237B
29s