flyingfishTransactions copy
Updated 2024-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Antonidas / Transactions @ https://flipsidecrypto.xyz/Antonidas/q/rO65SY5-elWX/transactions
-- forked from Transaction Failure Rate @ https://flipsidecrypto.xyz/edit/queries/8382cc51-5a1e-4784-b01a-f105fd2da713
-- forked from Blast Blocks @ https://flipsidecrypto.xyz/edit/queries/13fcbc09-be2d-4e85-8ac3-48a7c59020d5
select
date_trunc('minute', block_timestamp) as day_date,
count(1) as transactions
from blast.core.fact_transactions
where block_timestamp > current_date
group by 1
order by 1
QueryRunArchived: QueryRun has been archived