USER | TRANSACTIONS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|
1 | 0x8c2c3117c620571cb2c34d1e38c150995cde560b | 33 | 14000475.0256498 | 424256.818959084 |
2 | 0x171c53d55b1bcb725f660677d9e8bad7fd084282 | 30 | 13555981.4252174 | 451866.047507248 |
3 | 0x8b93e317af3cacb25076f11c7e4d3546c3b041f8 | 11 | 9526835.07943849 | 866075.91631259 |
4 | 0x1aecba5af25d90f9a36eda909eaa1ed912a891f8 | 21 | 8365965.80383255 | 398379.323992026 |
5 | 0x155400081fa511995d29173e039057ef770d5776 | 16 | 6591721.55083153 | 411982.59692697 |
6 | 0xb9a6f783684d747616b7a619c94a334895c04957 | 20 | 5686984.94605683 | 284349.247302842 |
7 | 0x4b8c1ccb589903af6b459f8bcdf96d0b2a1a4ef0 | 30 | 5545986.29043076 | 184866.209681025 |
8 | 0xbc6f73dbd5dc7810c07e71c21b15643e1d39cf16 | 21 | 4414136.89686268 | 210196.995088699 |
9 | 0x629539454f8c8fa5a98b8c366f904a0455937138 | 17 | 4101330.56512634 | 241254.739125079 |
10 | 0x239c756f5f26cef33e35bf9d5ca985522ae515d9 | 9 | 3436304.91833473 | 381811.657592748 |
11 | 0x64d67bc86dbf8be384d1c4871870e96972b36a53 | 11 | 2332357.84923346 | 212032.531748497 |
12 | 0x9b2add83eef8d7bd6c85ebf35621fae33f07d109 | 161 | 2039565.95722179 | 12668.111535539 |
13 | 0x08de1d003fa57288dabfa426750c354944d49181 | 7 | 1999149.2636159 | 199914.92636159 |
14 | 0x6612dbfb836f5f3017fe4fbf7f4e1d46ab55e28c | 22 | 1566184.42660671 | 71190.201209396 |
15 | 0x74c77c2a5d0a2aa6a99b757b00cbd61c67dbd1c6 | 7 | 1537728.33388837 | 219675.476269767 |
16 | 0xc59369b9dbc3c66a2ca589d1e6468fc3ce57d795 | 16 | 1400817.21987009 | 87551.076241881 |
17 | 0xb3abe0777aa9685941e54744e704378b4b33eeaa | 11 | 1398847.75500449 | 127167.977727681 |
18 | 0xf70da97812cb96acdf810712aa562db8dfa3dbef | 168 | 1353652.26044504 | 8057.45393122 |
19 | 0x2d47437d39d41ad575c436438b780cea12532294 | 104 | 1326916.73102175 | 12758.814721363 |
20 | 0x7b3e637e0e27a6657cd7c21a5f46f90c6ea72307 | 1 | 1314028.98504289 | 1314028.98504289 |
Afonso_DiazTop users
Updated 2025-04-01
99
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 date,
token_address,
avg(price) as price_usd
from
sei.price.ez_prices_hourly
group by 1, 2
),
main as (
select
tx_hash,
block_timestamp,
to_address as user,
contract_address as token_address,
symbol,
amount,
amount * price_usd as amount_usd
from
sei.core_evm.ez_token_transfers a
left join
pricet on block_timestamp::date = date and pricet.token_address = a.contract_address
where
origin_to_address = '0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f'
)
select
user,
count(distinct tx_hash) as transactions,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd
from
main
Last run: about 1 month ago
100
8KB
4s