AephiaSAGE txs pct_of_solana hourly
Updated 2024-01-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH transactions AS (
select
date_trunc('hour', block_timestamp) as date,
count(tx_id) as txs
FROM solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND succeeded = 'true'
--AND log_messages::string NOT LIKE '%CreateGame%'
--AND log_messages::string NOT LIKE '%Idl%'
and block_timestamp > current_date-7 AND block_timestamp < date_trunc('hour', current_timestamp) - interval '1 hour'
--limit 100
group by 1
order by 1 desc
),
solana AS (
select
--*
date_trunc('hour', block_timestamp) as date,
count(distinct (tx_id)) as solana_txs
FROM solana.core.fact_events
WHERE succeeded = 'true'
and block_timestamp > current_date-7--'2023-06-01' AND block_timestamp < current_date
group by 1
)
Select
QueryRunArchived: QueryRun has been archived