MLDZMNsolt2 copy
Updated 2023-08-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from solt2 @ https://flipsidecrypto.xyz/edit/queries/89281c87-5766-4172-985c-ff4339b1066e
select
date_trunc('day', first_transaction_stamp) as date,
SWAP_PROGRAM,
count (distinct sender) as new_users
from (
select
distinct swapper as sender,
SWAP_PROGRAM,
min(block_timestamp) as first_transaction_stamp
from solana.core.fact_swaps
where block_timestamp>='2023-08-01'
and SUCCEEDED = 'TRUE'
and (SWAP_TO_MINT = '31k88G5Mq7ptbRDf3AM13HAq6wRQHXHikR8hik7wPygk' or SWAP_FROM_MINT = '31k88G5Mq7ptbRDf3AM13HAq6wRQHXHikR8hik7wPygk')
group by 1,2
)
group by 1,2
Run a query to Download Data