USER | TRANSACTIONS | |
|---|---|---|
1 | 4bEk3CLwmnRHQxUEqDtNcXabz8RSdQyMpsAKJTaM8NUc | 2976739 |
2 | 6mqEFHtzz7cV6dtoM1PHYTtjs29cXJkfX8M3TbsnkgMx | 1898001 |
3 | GWkzBdMKjk2Akv2XXrRfEU6GwNmALPVHB3caCa5X4E6F | 1659730 |
4 | 3BtWv8uGQ2KHFQqMk5XPSR7PK8zZZvVK88hAdCG4ifVm | 1523847 |
5 | GgYVRoqAW5xHG11vYRPbEzm6yzs4PP63Di8HcmzeHrfe | 1510686 |
6 | AJZpisn6JLpTYxDtb7JeoN5UZaNe2GYNrHY6m9kDxT93 | 1327709 |
7 | DJiDXfe1jSRmgYuKjzDCbnYciZkXCRbdRR8ezDbM15iF | 1193381 |
8 | AJHPKAYCDxwM65ApTYpc11YKhBEcxC3ACQSSKvT5ARdU | 1106466 |
9 | 58VRQbj4NfkzcG2bV7Gf73MQvyBys9dwPFtDraoutuGw | 1037099 |
10 | 4znFcGqYdWn7KMqsWT4rfapzoJbt5Paygh5F8bBByvpB | 1005655 |
11 | G6vg3i7RBgsXyE85Xi6QJkH65HvJHjqVVHbaLRk9Y4Su | 1003006 |
12 | 8ZApXr3yd3FKX8XH6qarBWVTiUDiKbGSDuT2gGqFpDz2 | 999714 |
13 | 6DWjwtGBGeTKLefrQHaRGkMecky89ZyHDjr9wFhkx9fS | 996175 |
14 | Avq6mGDgbLgj77JBKnsPKufZCXeZvby6dLggdgMWSGQN | 953022 |
15 | GFWsgNzASfMCPvRHLjGNKKcPv5d4Wv2kiwHaRy3tfDLY | 862952 |
16 | EgDizWqSycE8zYMj264DRAWyr84wbFV4tTVe4KJdPwUr | 704255 |
17 | 4beaZ4KgbZxHjX8Rw9QsetLNnC9ZDsrykGBaDYB7PCoy | 696255 |
18 | AWJCzNzYSNfFRuH4BrdLBXXcCyuhSq1XrKhBEMSALr6h | 666213 |
19 | G6r4KRfpUY8ZsfHxy9LtCSAy3HKZfd9t1KKyuvYBnzKK | 659707 |
20 | 4Ezy5n1attpaCcCFVuVhguq4zYheyu45PrAs93yyhX91 | 658557 |
Afonso_DiazTop 100 users
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with
main as (
select
tx_id,
block_timestamp,
signers[0] as user,
from
eclipse.core.fact_transactions
where
succeeded
)
select
user,
count(distinct tx_id) as transactions,
from
main
group by 1
order by 2 desc
limit 100
Last run: 3 months ago
100
5KB
183s