Address Rank by Tx Count | Total Transactions | |
|---|---|---|
1 | 511079 | 101 |
Mrftiyour tx count
Updated 6 hours ago
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
›
⌄
-- forked from raw-turquoise copy copy @ https://flipsidecrypto.xyz/studio/queries/a7b0e398-d3af-46bc-8c2d-4ae8b2d082a9
WITH address_tx_counts AS (
SELECT
from_address,
COUNT(DISTINCT tx_hash) AS total_tx
FROM
monad.testnet.fact_transactions
GROUP BY
from_address
),
ranked_tx_counts AS (
SELECT
from_address,
total_tx,
RANK() OVER (ORDER BY total_tx DESC) AS tx_rank
FROM
address_tx_counts
)
SELECT
tx_rank AS "Address Rank by Tx Count",
total_tx AS "Total Transactions"
FROM
ranked_tx_counts
WHERE
from_address = LOWER('{{Address}}');
Last run: about 6 hours agoAuto-refreshes every 12 hours
1
14B
57s