StangFAST005 - serum - min
Updated 2023-10-26
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
min AS
(
SELECT
min( a.block_timestamp ) AS "date"
, a.signers[0] AS "swapper"
FROM
solana.core.fact_events a
JOIN
solana.core.fact_transfers c
using ( block_timestamp , tx_id )
WHERE
a.block_timestamp::date >= '2023-02-01'
AND a.block_timestamp::date <= dateadd ( 'week' , -1 , current_date )
AND a.signers[0] = c.tx_to
AND a.succeeded = 'true'
AND a.program_id in (
'9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'
, '22Y43yTVxuUkoRKdm9thyRhQ3SdgQS7c7kB6UNCiaczD'
)
GROUP BY 2
ORDER BY 1 DESC
)
SELECT
date_trunc( 'week' , a."date" ) AS "date"
, count( distinct a."swapper" ) AS "swapper"
FROM
min a
GROUP BY 1
Run a query to Download Data