USER | TRANSACTIONS | VOLUME_USD | OLAS_VOLUME | |
|---|---|---|---|---|
1 | 0xeb2a22b27c7ad5eee424fd90b376c745e60f914e | 35 | 1602.15 | 652.1 |
2 | 0xfb6390202ad7d49c951a659546aca25507411115 | 39 | 102.6 | 37.105160212 |
3 | 0x4964d4b5084292a68764992874526904c8653b69 | 18 | 58.2 | 25.531968526 |
4 | 0x7f0169e557a98dad94ce3fba4df747c407f4a26b | 12 | 56.59 | 30.104778835 |
5 | 0xf390173a7d610474ee6628641d92a8c4b26160c7 | 11 | 53.7 | 28.863026565 |
6 | 0xf61046d2dc7f8d6ecd9d991113e6781a468820a6 | 22 | 51.06 | 14.476563981 |
7 | 0x4685a9d6dbbb29d95a9e82b647969f0d25076db8 | 12 | 48.83 | 26.071019899 |
8 | 0x5a0d1e38550959266926c8f77fac68acad1f824f | 11 | 45.42 | 25.0962526 |
9 | 0xc887911cd5627f3d468199cb7aad0a0545abe43a | 34 | 40.83 | 12.383139054 |
10 | 0x5321f043474793ea1560f05b346addbc3e478e01 | 12 | 35.55 | 20.374419874 |
11 | 0xa5f822895fa4ad690199d4a45d31a53ffe786b36 | 11 | 33.53 | 19.651786935 |
12 | 0xcb48cf085de03b959596c454aac9f7d324741610 | 11 | 30.43 | 18.712400062 |
13 | 0x224c450fe46255395d6398f8a646f37089fe5a10 | 4 | 29.96 | 14.805340608 |
14 | 0xe47578540b412496765c389d66bd21a3e6f22f74 | 6 | 29.55 | 17.73401593 |
15 | 0x867bca40726a4c5330683ea830215d3ee871e78e | 7 | 29.18 | 18.95099675 |
16 | 0xf05337fb9e3243d041905b49b1ec1aae8d3a47db | 4 | 27.86 | 13.849983466 |
17 | 0xe05ab86dee998bf55e2f81972fdbfb6575c4e8c1 | 9 | 27.17 | 17.658665242 |
18 | 0x9550d6dfd67059e9b12b7a7fd18972876ec002b2 | 8 | 27.03 | 17.980193019 |
19 | 0x25f4e7e7f137e42aa9696ca992f87fc88bf9b57e | 9 | 26.92 | 16.478180511 |
20 | 0x7343353a0f87f55f0f46f4c43c018a8c33195c36 | 2 | 26.07 | 15.97729828 |
Afonso_DiazTop users
Updated 2025-01-27
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
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
amount,
amount_usd,
origin_from_address as user,
program_name
from
crosschain.olas.ez_olas_staking
)
select
user,
count(distinct tx_hash) as transactions,
sum(amount_usd) as volume_usd,
sum (amount) as Olas_Volume
from
main
where
block_timestamp between '{{ start_date }}' and '{{ end_date }}'
group by 1
order by 3 desc
limit 100
Last run: 3 months ago
100
6KB
1s