LTirrellSolana Signers and Fee Payers -- succeeded-only
Updated 2023-12-07
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
›
⌄
-- forked from Solana Signers and Fee Payers @ https://flipsidecrypto.xyz/edit/queries/7d69821b-2a72-4a0d-afca-920a20d48a4d
select
'Signers' as type,
date(block_timestamp) as date,
count(distinct s.value) as wallets
from
solana.core.fact_transactions,
lateral flatten(signers) as s
where
date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
and succeeded = TRUE
group by
date
UNION
select
'Fee Payers' as type,
date(block_timestamp) as date,
count(distinct signers[0]) as wallets
from
solana.core.fact_transactions
where
date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
and succeeded = TRUE
group by
date