AephiaCrew Packs leaderboard
Updated 2024-12-19
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 buyers AS (
select
--*
tx_to as wallet_buy,
----------------------------------------------------
sum(amount) as crew_packs_buy
from solana.core.fact_transfers
WHERE block_timestamp > '2024-05-01'
AND mint = 'CRWPXjZw73dMW3pG7UMhVWDrfk5NnzMCMuWj6hVLMCYm'
--limit 100
group by 1
--order by 2 desc
)
,sellers AS (
select
--*
tx_from as wallet_sell,
----------------------------------------------------
sum(amount) as crew_packs_sell
from solana.core.fact_transfers
WHERE block_timestamp > '2024-05-01'
AND mint = 'CRWPXjZw73dMW3pG7UMhVWDrfk5NnzMCMuWj6hVLMCYm'
--limit 100
group by 1
--order by 2 desc
)
SELECT
wallet_buy as wallet
,zeroifnull(crew_packs_buy) - zeroifnull(crew_packs_sell) as crew_packs
QueryRunArchived: QueryRun has been archived