JhanlycnStar Atlas Token Swaps
Updated 2023-10-13
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
swaps AS (
SELECT
DATE_TRUNC('DAY', fact_swaps.BLOCK_TIMESTAMP) AS SWAP_DAY,
fact_swaps.SWAPPER,
fact_swaps.SWAP_FROM_MINT,
fact_swaps.SWAP_TO_MINT
FROM
solana.core.fact_swaps AS fact_swaps
WHERE
(
fact_swaps.SWAP_FROM_MINT IN (
'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx',
'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk'
)
OR fact_swaps.SWAP_TO_MINT IN (
'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx',
'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk'
)
)
AND fact_swaps.BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '60 days'
AND SUCCEEDED
)
SELECT
swaps.SWAP_DAY AS Date,
COUNT(DISTINCT swaps.SWAPPER) AS UNIQUE_SWAPPER,
SUM(
CASE
WHEN swaps.SWAP_FROM_MINT = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
OR swaps.SWAP_TO_MINT = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' THEN 1
ELSE 0
END
) AS ATLAS_DAILY,
SUM(
CASE
Run a query to Download Data