Address | Total Deposits | Total deposit volume (USD) | |
|---|---|---|---|
1 | solver-multichain-asset.near | 240 | 1999839.56867951 |
2 | fomo-solver-test.near | 169 | 75.464367424 |
3 | 0x6aa1e9c9029ef5172c0a0f58ea6e7205a82a24e1 | 161 | 70.513465368 |
4 | 0x0981a291bc35628f4085ec05370f00ef3bc96ea5 | 144 | 227.038820293 |
5 | 75d44b5a0f717b05cfa0a5869f5245a28bf21f1e9d13778c2e7e176b5ffb1a8d | 137 | 35.613031582 |
6 | solver-priv-liq.near | 132 | 6847406.64642106 |
7 | 0x2fba7e4fc20620893cb22a348185265fbce8e343 | 114 | 106.905061637 |
8 | mohsenkheyri.near | 82 | 1852.290278319 |
9 | chemtrails.near | 76 | 4310.532334543 |
10 | 0xdafbfa79d7268be286574c6641d34993d9f00bd3 | 75 | 72.73184993 |
11 | 0xdead698d1ff2efca2c4c1f171d6a92dd3b3e5e73 | 72 | 13.246267838 |
12 | hodler81.near | 72 | 13590.488472912 |
13 | e23426f6510e3f07d6f58dca15fd42966e41b09fba487dd7aa22930831e6e82a | 69 | 1219.726181239 |
14 | just-a-user.near | 68 | 93.736183484 |
15 | zunem001.tg | 57 | 4840.12577711 |
16 | 0x91543e6369bc96868a4a5c2a0e76ddfa4336c823 | 55 | 1.863299424 |
17 | king04.near | 55 | 307.901830536 |
18 | kcameau.near | 52 | 1737.311788565 |
19 | iwontrememmberthisname.near | 52 | 112.833864998 |
20 | omnilanetest.near | 51 | 1692.734216913 |
Mrftixerothermic-azure copy
Updated 2025-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from xerothermic-azure @ https://flipsidecrypto.xyz/studio/queries/8d8b8637-6a8a-4884-9ea7-f75d0dc54df4
-- I used these queries for forking:
-- forked from [Parent Query] NEP245 Parsed Events - 20241205 @ https://flipsidecrypto.xyz/studio/queries/9016ac39-e42b-4591-bea9-dabef61822f7
-- forked from [Parent Query] NEP245 Parsed Mints and Burns Events @ https://flipsidecrypto.xyz/studio/queries/1ca044ae-9e66-4f51-bc61-0cc181cfc50e
with database as
(
select BLOCK_TIMESTAMP,TX_HASH,MEMO,LOG_EVENT_INDEX,OWNER_ID,SYMBOL,OLD_OWNER_ID,NEW_OWNER_ID,TOKEN_AMOUNT_ADJ,AMOUNT_USD
from $query('6539c74d-1822-495e-b77a-d376b9271099')
where MEMO in ('deposit')
)
SELECT
owner_id as "Address",
count (DISTINCT tx_hash) as "Total Deposits",
sum (amount_usd) as "Total deposit volume (USD)"
from database
group by 1
order by 2 desc
Last run: 23 days agoAuto-refreshes every 12 hours
...
1926
104KB
2s