Arkanstatistic 1
    Updated 2023-01-10
    WITH
    table1 as ( -- success near
    SELECT
    block_timestamp,
    tx_hash,
    tx_status,
    substr(split(tx:"actions"[0], ':')[0], 3, len(split(tx:"actions"[0], ':')[0])-3) as action
    FROM
    near.core.fact_transactions
    WHERE block_timestamp::date >= '2022-12-1'
    ),
    s_ as ( -- success
    SELECT
    date_trunc('day', block_timestamp) as date,
    action,
    count(*) as tx_count
    FROM
    table1
    WHERE tx_status = 'Success'
    GROUP BY date, action
    ),
    f_ as ( -- fail
    SELECT
    date_trunc('day', block_timestamp) as date,
    action,
    count(*) as tx_count
    FROM
    table1
    WHERE tx_status = 'Fail'
    GROUP BY date, action
    )
    SELECT
    s_.date,
    CASE WHEN s_.action = 'eateAccoun' THEN 'CreateAccount' ELSE s_.action END action,
    s_.tx_count as success_count,
    f_.tx_count as fail_count,
    Run a query to Download Data