i_danoverview copy
    Updated 2025-04-10
    SELECT
    date_trunc(day, block_timestamp) AS "Day"
    , CASE
    WHEN EXTRACT(MONTH FROM "Day") = 1 THEN 'January'
    WHEN EXTRACT(MONTH FROM "Day") = 2 THEN 'February'
    WHEN EXTRACT(MONTH FROM "Day") = 3 THEN 'March'
    WHEN EXTRACT(MONTH FROM "Day") = 4 THEN 'April'
    WHEN EXTRACT(MONTH FROM "Day") = 5 THEN 'May'
    WHEN EXTRACT(MONTH FROM "Day") = 6 THEN 'June'
    WHEN EXTRACT(MONTH FROM "Day") = 7 THEN 'July'
    WHEN EXTRACT(MONTH FROM "Day") = 8 THEN 'August'
    WHEN EXTRACT(MONTH FROM "Day") = 9 THEN 'September'
    WHEN EXTRACT(MONTH FROM "Day") = 10 THEN 'October'
    WHEN EXTRACT(MONTH FROM "Day") = 11 THEN 'November'
    WHEN EXTRACT(MONTH FROM "Day") = 12 THEN 'December'
    END AS "Month"
    , COUNT(DISTINCT tx_hash) AS "Transactions"
    , SUM("Transactions") OVER (ORDER BY "Day") AS "Cummulative Transactions"
    , COUNT(DISTINCT from_address) AS "Users"
    , SUM(tx_fee) AS "Total Fees Spent"
    , SUM("Total Fees Spent") OVER (ORDER BY "Day") AS "Cummulative Fee Spent"
    , COUNT(CASE WHEN tx_succeeded THEN tx_hash END) AS "Total Successful Transactions"
    , -(COUNT(CASE WHEN NOT tx_succeeded THEN tx_hash END)) AS "Total Unsuccessful Transactions"
    , SUM(CASE WHEN tx_succeeded THEN 1 ELSE 0 END) * 100.0 / NULLIF(COUNT(tx_hash), 0) AS "Transaction Success Rate"
    FROM swell.core.fact_transactions
    GROUP BY 1
    ORDER BY 1 DESC


    Last run: 23 days ago
    Day
    Month
    Transactions
    Cummulative Transactions
    Users
    Total Fees Spent
    Cummulative Fee Spent
    Total Successful Transactions
    Total Unsuccessful Transactions
    Transaction Success Rate
    1
    2025-04-10 00:00:00.000April1039863537921430.0027643434141.74209318110377-2199.798038
    2
    2025-04-09 00:00:00.000April5011563433944120.012136092191.73932883849206-90998.186172
    3
    2025-04-08 00:00:00.000April4865162932794010.0082256508631.72719274548579-7299.852007
    4
    2025-04-07 00:00:00.000April4991862446283380.013104270271.71896709449749-16999.661445
    5
    2025-04-06 00:00:00.000April4782761947105320.0071682657441.70586282447742-8599.822276
    6
    2025-04-05 00:00:00.000April4664661468836560.0030713875841.69869455846626-2099.957124
    7
    2025-04-04 00:00:00.000April4700461002373570.0053329398831.69562317146953-5199.891499
    8
    2025-04-03 00:00:00.000April4883160532336730.010278995131.69029023148760-7199.854601
    9
    2025-04-02 00:00:00.000April4898160044027070.010437787851.68001123648856-12599.744799
    10
    2025-04-01 00:00:00.000April4864859554218160.007219274971.66957344848563-8599.825275
    11
    2025-03-31 00:00:00.000March4838959067736740.0064428094191.66235417348321-6899.859472
    12
    2025-03-30 00:00:00.000March4733758583844780.0045352342081.65591136447293-4499.907049
    13
    2025-03-29 00:00:00.000March4706658110473190.0067264504791.65137612946975-9199.806654
    14
    2025-03-28 00:00:00.000March4763157639812980.0025839944021.64464967947451-18099.622095
    15
    2025-03-27 00:00:00.000March4736157163503900.0086972110071.64206568547157-20499.569266
    16
    2025-03-26 00:00:00.000March4897256689894800.019530348321.63336847448547-42599.132157
    17
    2025-03-25 00:00:00.000March4737156200172940.0058363927711.61383812547226-14599.693906
    18
    2025-03-24 00:00:00.000March4767855726463320.0031576160911.60800173247569-10999.771383
    19
    2025-03-23 00:00:00.000March4622755249682490.0026225012291.60484411646112-11599.751228
    20
    2025-03-22 00:00:00.000March4629854787412170.0013728401791.60222161546201-9799.790488
    ...
    135
    13KB
    3s