BRIDGERS | AMOUNT_CATEGORY | |
|---|---|---|
1 | 1 | 10-20 |
2 | 36 | 2-5 |
3 | 7 | 5-10 |
4 | 208 | <2 |
5 | 1 | >20 |
Specterdistribution of tx
Updated 2025-01-23
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
›
⌄
WITH relaycte AS (
SELECT block_timestamp, tx_hash, to_address AS bridger,
amount
FROM sei.core_evm.ez_token_transfers
WHERE contract_address = '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'
AND from_address = '0xf70da97812cb96acdf810712aa562db8dfa3dbef'
--AND tx_hash = '0x4ef41446367adb2a6e64e38d6053cc557cc1b334a0d0105f9655b05506e621e7'
),
distx AS (
SELECT bridger,
COUNT(DISTINCT tx_hash) AS transaction_count
FROM relaycte
GROUP BY bridger
)
SELECT
COUNT(DISTINCT bridger) AS bridgers,
CASE
WHEN transaction_count < 2 THEN '<2'
WHEN transaction_count >= 2 AND transaction_count < 5 THEN '2-5'
WHEN transaction_count >= 5 AND transaction_count < 10 THEN '5-10'
WHEN transaction_count >= 10 AND transaction_count < 20 THEN '10-20'
WHEN transaction_count >= 20 THEN '>20'
END AS Amount_Category
FROM distx
GROUP BY Amount_Category
ORDER BY Amount_Category;
Last run: 3 months ago
5
56B
18s