Haisenbergfull-tps
Updated 2024-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
block_timestamp :: date AS date,
count(*) AS transactions,
count(DISTINCT account_keys [0] :: string) AS unique_addresses,
count(*) /86400 AS tps,
avg( CASE WHEN succeeded = True THEN 100.0000 ELSE 0.0000
END) AS success_rate
FROM
solana.core.fact_transactions
WHERE
block_timestamp :: date >= CURRENT_DATE - interval '30 days'
GROUP BY
1
QueryRunArchived: QueryRun has been archived