AephiaEV leaderboard new
Updated 2023-05-31
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
›
⌄
WITH transactions AS (
select
--*
distinct signers[0] as wallet,
count(tx_id) as txs,
count(distinct instruction:accounts[1]) as max_fleets
FROM solana.core.fact_events
WHERE program_Id = 'TESTWCwvEv2idx6eZVQrFFdvEJqGHfVA1soApk2NFKQ'
AND succeeded = 'true'
And block_timestamp > '2023-04-26' --AND block_timestamp < '2023-03-27'
--limit 100
group by 1
)
SELECT
--*
wallet,
txs as txs,
max_fleets as max_fleets
from transactions
group by 1,2,3
order by 2 desc
Run a query to Download Data