RayyykSolana Flash 1
Updated 2022-09-30
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 table_1 as (select date_trunc('day', a.block_timestamp) as day,
count(distinct(a.tx_id)) as tx_count,
sum(tx_count) over (order by day) as cumu_tx_count,
count(distinct(signers[0])) as wallet_count
from solana.core.fact_transactions a
join solana.core.fact_events b on a.tx_id = b.tx_id
where program_id in ('rwdNPNPS6zNvtF6FMvaxPRjzu2eC51mXaDT9rmWsojp',
'stkBL96RZkjY5ine4TvPihGqW8UHJfch2cokjAPzV8i',
'LVLYTWmTaRCV5JcZ5HQkU1bhEjx34xqGiT3eWU6SuX9',
'q1yEkaNeJ9iRXE7BJejSMkT3PF7HsaL1Eu6em9sQYCw',
'mgr99QFMYByTqGPWmNqunV7vBLmWWXdSrHUfV8Jf3JM',
'crt4Ymiqtk3M5w6JuKDT7GuZfUDiPLnhwRVqymSSBBn',
'nameXpT2PwZ2iA6DTNYTotTmiMYusBCYqwBLN2QgF4w')
and a.block_timestamp >= current_date - 30
group by 1),
table_2 as (select count(distinct(a.tx_id)) as total_tx_count,
count(distinct(signers[0])) as total_wallet_count
from solana.core.fact_transactions a
join solana.core.fact_events b on a.tx_id = b.tx_id
where program_id in ('rwdNPNPS6zNvtF6FMvaxPRjzu2eC51mXaDT9rmWsojp',
'stkBL96RZkjY5ine4TvPihGqW8UHJfch2cokjAPzV8i',
'LVLYTWmTaRCV5JcZ5HQkU1bhEjx34xqGiT3eWU6SuX9',
'q1yEkaNeJ9iRXE7BJejSMkT3PF7HsaL1Eu6em9sQYCw',
'mgr99QFMYByTqGPWmNqunV7vBLmWWXdSrHUfV8Jf3JM',
'crt4Ymiqtk3M5w6JuKDT7GuZfUDiPLnhwRVqymSSBBn',
'nameXpT2PwZ2iA6DTNYTotTmiMYusBCYqwBLN2QgF4w'))
select day,
tx_count,
cumu_tx_count,
wallet_count,
(select total_tx_count from table_2),
(select total_wallet_count from table_2)
from table_1
order by 1 desc
Run a query to Download Data