Motilola7D Karris swap count
Updated 2024-09-28
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
›
⌄
-- forked from 7D Ginnan swap count @ https://flipsidecrypto.xyz/studio/queries/2a41bf29-f713-4bd6-af9a-a3fd4ab372ae
WITH swaps AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
swapper,
CASE
WHEN swap_from_mint = 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump' THEN 'sold'
ELSE 'bought'
END AS direction
FROM solana.defi.ez_dex_swaps
WHERE (swap_from_mint = 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump'
OR swap_to_mint = 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump')
AND block_timestamp >= DATE_TRUNC('day', DATEADD('days', -7, CURRENT_TIMESTAMP))
),
buy_activity AS (
SELECT
date,
swapper,
COUNT(1) AS buy_count,
'bought' AS direction
FROM swaps
WHERE direction = 'bought'
GROUP BY date, swapper
HAVING buy_count >= 7
),
sell_activity AS (
SELECT
date,
swapper,
COUNT(1) AS sell_count,
'sold' AS direction
FROM swaps
WHERE direction = 'sold'
QueryRunArchived: QueryRun has been archived