RECEIVER_METRICS

IBC_insiderRECEIVER_METRICS

Updated 8 days ago

WITH RECEIVER_TABLE AS (

SELECT

-- SUBSTRING(SENDER, REGEXP_INSTR(SENDER, '[0-9]')) AS ADDRESS_PART

REGEXP_SUBSTR(RECEIVER, '^[A-Za-z]+') AS NET,

REGEXP_SUBSTR(RECEIVER, '^[A-Za-z]+') AS DESTINATION_NET,

'RECEIVE' AS TYPE,

FROM cosmos.core.fact_transfers

WHERE TRANSFER_TYPE = 'IBC_TRANSFER_OUT'

AND NULLIF(NET, '') IS NOT NULL

AND TX_SUCCEEDED

AND LOWER(CURRENCY) = 'uatom'

AND YEAR(BLOCK_TIMESTAMP) = '2025'

)

SELECT

NET,

SUM(AMOUNT/1E6) AS VOLUME,

COUNT(DISTINCT TX_ID) AS TX_NUMBER,

COUNT(DISTINCT RECEIVER) AS RECEIVER

FROM RECEIVER_TABLE

-- WHERE

-- BLOCK_TIMESTAMP > CURRENT_DATE - 30

GROUP BY NET

HAVING VOLUME > 100

ORDER BY TX_NUMBER DESC

Last run: 8 days ago

	NET	VOLUME	TX_NUMBER	RECEIVER
1	osmo	17918427.227	188032	20112
2	neutron	3859051.514918	28752	986
3	stars	151358.840648	12748	4675
4	pryzm	530157.384273	8179	1482
5	terra	148869.589919	6858	73
6	inj	399003.001985	5823	386
7	persistence	286363.529193	4904	110
8	elys	280043.072833	3864	1269
9	orai	327805.906156	3072	67
10	kujira	62927.828523	2767	141
11	core	18905.969512	2159	39
12	mantra	56543.505581	2154	161
13	secret	203670.347178	1724	59
14	stride	349210.417457	1700	1013
15	juno	79093.077769	1576	40
16	crc	113032.011861	1542	412
17	kava	169255.557923	1502	60
18	tnam	4886.168487	1083	239
19	dym	39939.994284	1080	157
20	umee	279921.509239	997	144

1KB

flipside