TOTAL_HOLDERS | |
|---|---|
1 | 34748 |
Updated 2025-03-25
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
›
⌄
--SELECT * FROM ronin.price.ez_prices_hourly
--WHERE SYMBOL ilike '%SLP%'
--where tx_hash = '0xe3ae180c2b67aa7153c8bba7cb994b1b017da16d648ba8d27256d2343af12067'
--LIMIT 50
--SELECT count(tx_hash)
--COUNT(distinct tx_hash) AS total_transfers
--FROM ronin.core.ez_token_transfers
--WHERE tx_hash = '0x171ad44353f88f43df8b72a8cd5293671b3b9579e3f930e42df5a22e3acbdaf7'
--where contract_address = LOWER('0xa8754b9fa15fc18bb59458815510e40a12cd2014');
with base as (
SELECT
TO_ADDRESS as Wallet
, AMOUNT
from ronin.core.ez_token_transfers
WHERE 1=1
AND contract_address = lower('0x03affae7e23fd11c85d0c90cc40510994d49e175')
UNION ALL
SELECT
FROM_ADDRESS as Wallet
, -AMOUNT
from ronin.core.ez_token_transfers
WHERE 1=1
AND contract_address = lower('0x03affae7e23fd11c85d0c90cc40510994d49e175')
),
refine as (
SELECT
wallet
, SUM (amount) as balance
from base
Group by 1
--having balance > 0.00000000001
Last run: 2 months ago
1
9B
3s