USER | TRANSACTIONS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|
1 | 0x409d17733f3bcd277d099c92a103f8288e2f2e8c9b5086144c4f37911eeb0834 | 797 | 43743962.5779937 | 54885.774878286 |
2 | 0x72c533f1d3a33666caae96c8c0da73a3f0169de192270e5f9c02b4824f6a52e5 | 630 | 23758710.6308641 | 37712.23909661 |
3 | 0x4bfe76df986d342f3144857787bd0f9432c315ffa658c1cd684ec7d5218aed30 | 469 | 8389984.30126229 | 16983.773889195 |
4 | 0xe74ea566562c1e5fa7334e8d2a2b1932b855f32fa219c2da60d93cf84f54c6f2 | 195 | 7762943.87065046 | 39809.968567438 |
5 | 0xf8ebd98e19a3e9545e8a6386de52031f12ca33bd7e6bdaf2b6e61b91baa1496d | 27 | 6765583.44859046 | 250577.16476261 |
6 | 0xbd84fc8cffc699dd1a1dcee7f072777dbc70f89d02fab6d0d78ff74c89f5f285 | 18 | 6559218.22500955 | 364401.012500531 |
7 | 0xcf3820c35f5f4f0d1937ca32ab4f924a95b2c7fe23263023db67753dc1c9ddf8 | 208 | 4911615.25286042 | 21732.810853365 |
8 | 0x2a3a1777f9a7d60bb2e56176dd5207a974663abf8569ccf7b48dd1dcc01bda87 | 10 | 4243577.29333333 | 424357.729333333 |
9 | 0xcbdc936403b7436df1faee7075f84eb5f3b3efa73f198534584b6cb5d54c60ab | 112 | 4179833.60298603 | 37319.942883804 |
10 | 0xc14150d4b5afb80a865bd8f16a59f2cf91c1eab1df5ef7789d684fa8579e7441 | 173 | 3977681.86908052 | 22600.46516523 |
11 | 0xe9ba684aa7bcdb5558061f700237fcfb986ced8562639d2fcf6c2a8433581f74 | 60 | 3736663.39692586 | 62277.723282098 |
12 | 0xeb5be6f835296b9ab7662de59e88339519f05240a31c1f6a6d09743aeff868d1 | 243 | 3641374.01957553 | 14985.078269858 |
13 | 0x9c901785b738976363e7a93c47cc97d00f0ac055032766e780d80ead6e90342c | 40 | 3537087.52728444 | 88427.188182111 |
14 | 0x7c70937d519e9b03b989886037766968055c599fe456c1dbb9252085023d855 | 181 | 3400654.90845987 | 18788.148665524 |
15 | 0xf2b2b41edfdb9c5bbfb4c7ad8e642c3b02b48415f034cd557e8f72c5e48cb2ce | 2 | 2867625 | 1433812.5 |
16 | 0x10c0159f47dfe220732dbf12109ccf62b96f7c5ceeefedf1b56bfad7cb968d32 | 23 | 2806387.61705211 | 122016.852915309 |
17 | 0xdf0fba62282ccb0a282b8d8161cacca84ae1c6e616a84e86e7c5825e8779c5ac | 23 | 2597589.66441678 | 112938.681061599 |
18 | 0xb25ed15c0ad87f68a5cc74912c59ad6429c89b28314085ec46b6970216e459a3 | 8 | 2406397.02416667 | 300799.628020833 |
19 | 0xec0dcebbdd52efc26ab8a92f0e1c3e3db771670d6171c03a1d48501e7c0a58da | 5 | 1832813.4825 | 366562.6965 |
20 | 0x4a0ad4fef6d8d1b9f3e633c67cc25ac3674bc22a3157b65f1dbc6e9d7f1c1978 | 15 | 1759810.90537785 | 117320.72702519 |
Afonso_DiazTop suppliers
Updated 2025-05-15
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: 17 days ago
100
10KB
54s