ludicrousStar Atlas - Daily Sage copy
Updated 2024-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from nundox / Star Atlas - Daily Sage @ https://flipsidecrypto.xyz/nundox/q/EOcfoiRZ_uaw/star-atlas---daily-sage
select
COUNT(distinct tx_id) as num_txs,
value
FROM
solana.core.fact_events,
lateral flatten(signers)
WHERE
program_id IN (
'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6',
'Cargo8a1e6NkGyrjy4BQEW4ASGKs9KSyDyUrXMfpJoiH'
)
AND succeeded = 'true' --AND log_messages::string NOT LIKE '%CreateGame%'
--AND log_messages::string NOT LIKE '%Idl%'
and block_timestamp > '2024-01-21'
AND block_timestamp < current_date -- and tx_id='5uCPceP1Z44gMwFgTDJ8zna7huEMr2boSwud5xHr55iyMFfG6vF7FzdRLgQnnPnuexSgTyrTw5tMweNqeCgyj4Xb'
group by
value
order by num_txs DESC;
QueryRunArchived: QueryRun has been archived