Motilola7D Omni 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 Mongy swap count @ https://flipsidecrypto.xyz/studio/queries/1ec8b4e5-7a0f-4481-befc-ca3e80da21cc
WITH swaps AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
swapper,
CASE
WHEN swap_from_mint = 'A8vJzs6ygbZQyYLf9FKund8j3pDfUzxBeje8rJiypump' THEN 'sold'
ELSE 'bought'
END AS direction
FROM solana.defi.ez_dex_swaps
WHERE (swap_from_mint = 'A8vJzs6ygbZQyYLf9FKund8j3pDfUzxBeje8rJiypump'
OR swap_to_mint = 'A8vJzs6ygbZQyYLf9FKund8j3pDfUzxBeje8rJiypump')
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