adriaparcerisasbase1.3
Updated 2023-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
status,
COUNT(distinct tx_hash) AS num_transactions--,
--sum(case when status='SUCCESS' then 1 else 0 end)/sum(case when status='SUCCESS' then 1 else 1 end) as success_rate
FROM base.goerli.fact_transactions
GROUP BY 1,2
order by 1 asc,2
Run a query to Download Data