ACCOUNT | TRANSACTION_COUNT | |
|---|---|---|
1 | GDLYECYW23R4K7LLMCNK6ZG4BMA6ODESNTUHNK56E3DOW6723VJ2HX5J | 5540609 |
2 | GBNHHWVHIP7GT3UNIP6O7H5C6WSMVYSJR62AJJRSGO3ECRNPOJI3MELV | 4475237 |
3 | GAWMXRPIAMZ5GDBAOKKI3BZXZWIKRX3ALAH3ENPFCIGAE4IHCP5NGPG2 | 3776914 |
4 | GCYHACG4RDWBPBODEDFPSAV6XOUMLYE7LD66I3CWZ4Z4B4QJGHOCVWP3 | 3704340 |
5 | GDZRSRB4DOK3372HO2OKYVJKGTL5MYF5VUSO5CD5CJJNQVG35HMBQT6U | 3597351 |
6 | GCLM2V4D45RTGXTUYB6LU32Q3IUWZC5NN4KF5S6SCYXEZZLUOIKDKCJI | 3383993 |
7 | GAWLY7WEF5GGT5WCX2MMJEZG3CHLW73P7QJWOL7YWKV2LVH7NVL67ZVN | 3178703 |
8 | GC7L4BVK43SBE3U445M2GXP2FY2AGYMEUO5V5B6GWWFHP2JOXBWOHOA3 | 3062650 |
9 | GAFLVHUGQACYPJCYHNKPVNVTPJSQQ5ED3UYPFGJQTQUVNZ5FFWIIW463 | 2882740 |
10 | GDRQAROTM7WYEHZ42SXUVUOHO36MLQKLFIZ5Y2JBWVQRPCJ3SQBBA3LH | 2594003 |
11 | GDZ23WE4AZA6WXGRSRMQXH5JNUNOMY63V5KYEQ7KTV2QMDDUC7O4LK5Q | 2209321 |
12 | GA7SLX6K4RVNCCELUNLRNM4FKQQDN5OOAJQCIQ25H6HSZMJUAOG5VAH4 | 2209297 |
13 | GBFRNBRBQ3WVP5PQUDJ34TBXOFWZCSBRGJ7EZTGEH6ETAEXMVOQH6ZT7 | 2208663 |
14 | GC5YCXJBGSOBDV4FDXA5KMRFSYOBK5QHTVA5LXZRA4UUQVGXGNYVU5PD | 2207179 |
15 | GD5GXQ36J3SKH756HIXYRKNOGXTFBP6MSF6DVZHBF6TBDP6EK3TLXOAC | 2190674 |
16 | GBD5U2WBPQIC6BVLLSXR5Q4MTOSYNPKCTVJBP4CXW2JR3DU4CH6Q2REX | 2157147 |
17 | GDQXVQUQBC5VB7QEEXWW6P2HNUVVXTCPBZK3VW7NOM7SCLJZ3F4K4SWI | 2147274 |
18 | GAZKG7XTKNN2O7ULT65G5KNSX5HCEWENFD3XZEGSTENCTEXOP5ZOS252 | 2030594 |
19 | GCZ3KJTTCCUE2NES4626CQ24LF6WOJFSO3N2FLZKCE3PCYDCDHFVV5MW | 2022343 |
20 | GAJUFVS4TJSL4CAMHXMQFMTVPGM4H3ONNPYUTXTSYQEZZZP6Z5WFPZXZ | 1984975 |
par_rnStellar 05
Updated 2025-02-18
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
›
⌄
WITH TransactionSummary AS (
SELECT
COUNT(*) AS total_transactions
FROM
stellar.core.fact_transactions
),
FeeSummary AS (
SELECT
SUM(FEE_CHARGED / POWER(10, 7)) AS total_fees,
AVG(FEE_CHARGED / POWER(10, 7)) AS avg_fee,
MAX(FEE_CHARGED / POWER(10, 7)) AS max_fee
FROM
stellar.core.fact_transactions
),
MonthlyTransactionCount AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(*) AS transaction_count
FROM
stellar.core.fact_transactions
GROUP BY
transaction_date
ORDER BY
transaction_date DESC
),
TopAccounts AS (
SELECT
ACCOUNT,
COUNT(*) AS transaction_count
FROM
stellar.core.fact_transactions
GROUP BY
ACCOUNT
ORDER BY
transaction_count DESC
LIMIT
Last run: about 2 months ago
...
1000
66KB
51s