near as (

Select

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs,

txs/1440 as tpm

From near.core.fact_transactions

Where block_timestamp::date >='2024-01-01'

Group by 1

order by 1 ASC

),

near_fail as (

Select

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as failed_txs

From near.core.fact_transactions

Where block_timestamp::date >='2024-01-01'

and tx_succeeded<>TRUE

Group by date

order by date ASC

),

daily as (

SELECT

x.date,

txs,

failed_txs,

txs-failed_txs as succeeded_txs,

(failed_txs/txs)*100 as pcg_failed,

(succeeded_txs/txs)*100 as pcg_succeeded

from near x, near_fail y where x.date=y.date

),

near2 as (

Select

trunc(block_timestamp,'week') as date,

count(distinct tx_hash) as txs,

txs/1440 as tpm