DEPOSITOR | TRANSACTIONS | TOTAL_DEPOSIT_OLAS | TOTAL_DEPOSIT_USD | |
---|---|---|---|---|
1 | 0x91f1bfd331c499d729abf22abcf605a75b9dd8cd | 19 | 930728.50132963 | 1884380.53514494 |
2 | 0xcbaf750e27a6efa40f4b98cea00203c1bc92f662 | 8 | 229112.964826514 | 477621.571118436 |
3 | 0xd69a9068ebc98ca6f27ac92f45ffdce464719942 | 6 | 272710.312196406 | 289445.894926136 |
4 | 0xc8f7030a4e25585624e2fc792255a547255cd77c | 11 | 70185.847109262 | 140625.518991224 |
5 | 0xd7242b48f7ffcd9f4792a1c8749d6b0212ddf881 | 2 | 53491.413543135 | 127876.546709842 |
6 | 0x04213bf67204432a4d7ebc1fadf959e9950b0ea1 | 2 | 55853.431086249 | 108355.656307324 |
7 | 0x2f70a60047a6e3590bcc1d099700fdbe6f058ba6 | 4 | 48766.387834835 | 105491.495478386 |
8 | 0xfa1a1d97329c0b5ccd072f3afcdd64f25306f425 | 3 | 47082.656354612 | 101778.655454672 |
9 | 0x4edb5dd988b78b40e1b38592a4761f694e05ef05 | 1 | 27395.53038097 | 68488.825952426 |
10 | 0xbebb5faa55f519f6f6452e977873f2960c26fa28 | 2 | 28241.434207329 | 61892.149212378 |
11 | 0xa94d1199c5c23e1bb8d5d7cb427c96c5db380524 | 1 | 12035.540533499 | 25635.701336353 |
12 | 0xba95718a52b5a3dba749a7641712dc05a3550d4f | 3 | 13827.643215922 | 23898.253009621 |
13 | 0xf7547bc0dff96c599fcf258d53945b75847660c7 | 1 | 5548.776370094 | 5480.740137391 |
14 | 0xd40ab0d4d21f3586f3277a22cfcd4d9e9b851d6d | 1 | 532.398210056 | 1011.556599107 |
15 | 0xecff34c282c48095bb00af2cae746f236f5523a8 | 1 | 96.28021339 | 169.812990322 |
16 | 0xda44d2de6bd275365072c8b557db845dde043e55 | 1 | 41.605401382 | 116.495123869 |
17 | 0x3179996a3a7db9efc3469eb4f35781d68fc17d3d | 1 | 72.389960956 | 99.89814612 |
18 | 0xdf2317fdb466c952614b35c990f35734a8e0e378 | 1 | 6.08524909 | 23.960132296 |
19 | 0x26c632675ccd53018e4c96dee6420c4956f34c65 | 1 | 3.836718357 | 16.798042879 |
20 | 0xc1572a9cee49965611fb2acea686078894302e91 | 1 | 4.063474009 | 5.729498352 |
par_rnOlas 05
Updated 2025-01-21
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
›
⌄
WITH main AS (
SELECT
TX_HASH,
ORIGIN_FROM_ADDRESS AS user,
BLOCK_TIMESTAMP,
CASE
WHEN is_redeemed = 'TRUE' THEN 'Redeem'
ELSE 'Deposit'
END AS event_name,
olas_amount,
olas_amount_usd
FROM
crosschain.olas.ez_olas_bonding
)
SELECT
user AS depositor,
COUNT(DISTINCT TX_HASH) AS transactions,
SUM(olas_amount) AS total_deposit_olas,
SUM(olas_amount_usd) AS total_deposit_usd
FROM
main
WHERE
event_name = 'Deposit'
GROUP BY
user
ORDER BY
total_deposit_usd DESC
Last run: about 1 month ago
20
2KB
2s