syedccomos-activity copy-messari
    Updated 2024-06-11
    -- forked from messari / comos-activity @ https://flipsidecrypto.xyz/messari/q/6fyvS-_RtZiZ/comos-activity

    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/1000000) as fees,
    'atom' 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,
    QueryRunArchived: QueryRun has been archived