messaricomos-activity
    Updated 2024-01-23
    with base as (
    SELECT
    date(block_timestamp) as date,
    fee,
    fee_denom,
    tx_from,
    tx_succeeded
    from
    cosmos.core.fact_transactions
    ),
    fees as (
    select
    date,
    sum(fee) as fees,
    'uatom' as fee_denom
    from
    base
    where
    fee_denom = 'uatom'
    group by
    1
    ),
    activity as (
    select
    date,
    count(distinct tx_from) as active_addresses,
    count(*) as total_transactions,
    sum(
    case
    tx_succeeded
    when true then 1
    else 0
    end
    ) as successful_transactions,
    sum(
    case
    Last run: about 1 year ago
    DATE
    ACTIVE_ADDRESSES
    TOTAL_TRANSACTIONS
    SUCCESSFUL_TRANSACTIONS
    FAILED_TRANSACTIONS
    FEES
    FEE_DENOM
    1
    2024-01-23 00:00:00.0004085036544536409313521001908732uatom
    2
    2024-01-22 00:00:00.000332523294973281321365730499067uatom
    3
    2024-01-21 00:00:00.000389874195664180991467806684111uatom
    4
    2024-01-20 00:00:00.000362783356673340041663816574432uatom
    5
    2024-01-19 00:00:00.0004004897616397283033331148809790uatom
    6
    2024-01-18 00:00:00.00043502100065799801326441415083917uatom
    7
    2024-01-17 00:00:00.000485121133734113175019842110913562uatom
    8
    2024-01-16 00:00:00.000394451090931076871406638671506uatom
    9
    2024-01-15 00:00:00.000487271200931173152778693216764uatom
    10
    2024-01-14 00:00:00.000388901092701075041766651674695uatom
    11
    2024-01-13 00:00:00.0003301289973883741599574599816uatom
    12
    2024-01-12 00:00:00.0003344789417874821935561308604uatom
    13
    2024-01-11 00:00:00.000434031105191084082111703259921uatom
    14
    2024-01-10 00:00:00.000486051195971136475950646236265uatom
    15
    2024-01-09 00:00:00.0005148413413011641317717739652833uatom
    16
    2024-01-08 00:00:00.000346951027551001772578754313811uatom
    17
    2024-01-07 00:00:00.00034115100467983202147716477265uatom
    18
    2024-01-06 00:00:00.000352941081651020676098728025012uatom
    19
    2024-01-05 00:00:00.000403301090551070811974820009741uatom
    20
    2024-01-04 00:00:00.000461271281381250153123910485454uatom
    ...
    1202
    73KB
    42s