Moeaxl txns t
    Updated 2024-12-22
    select
    date_trunc('week', BLOCK_TIMESTAMP)::date AS date,
    monthname(BLOCK_TIMESTAMP) AS Month,
    count(TX_id) AS "transactions ",
    count(distinct TX_FROM) AS "active addresses "
    from axelar.core.fact_transactions
    where TX_SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP between CURRENT_DATE - interval '6 months' and current_date
    group by 1,2


    QueryRunArchived: QueryRun has been archived