DATE | Transactions | Users | Paid fee in SOL | Total transactions | Total Users | |
---|---|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 10 | 3 | 0.00011 | 86 | 13 |
2 | 2024-01-22 00:00:00.000 | 22 | 3 | 0.00027 | 76 | 10 |
3 | 2024-01-01 00:00:00.000 | 15 | 2 | 0.000295 | 15 | 2 |
4 | 2024-01-15 00:00:00.000 | 19 | 3 | 0.000125 | 54 | 7 |
5 | 2024-01-08 00:00:00.000 | 20 | 2 | 0.00014 | 35 | 4 |
MLDZMNbl1
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
count(*) as "Transactions",
count(distinct signers[0]) as "Users",
sum(FEE/1e9) as "Paid fee in SOL",
sum("Transactions") over (order by date) as "Total transactions",
sum("Users") over (order by date) as "Total Users"
from solana.core.fact_transactions s
join (select distinct block_timestamp, tx_id
from solana.core.fact_events where succeeded = True
and program_id = '5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe'
) events
using(tx_id, block_timestamp)
join lateral flatten (input => log_messages) logs
where BLOCK_TIMESTAMP >= current_date-{{Days_back}}
and logs.value ilike 'Program log: Instruction%'
group by 1
Last run: about 1 year agoAuto-refreshes every 6 hours
5
235B
151s