rw2023Sharx 30 days buyers
Updated 2024-03-02
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 Sharx 7 days buyers @ https://flipsidecrypto.xyz/edit/queries/0e0343fd-f9a0-49fb-9ae8-d684d11cb6f2
-- forked from Sharx holders ranking @ https://flipsidecrypto.xyz/edit/queries/5cee8f85-a2f8-492a-8905-f8b58234998c
WITH nft_mint_addresses AS (
SELECT
address AS mint
FROM
solana.core.dim_labels
WHERE
label = 'sharx by sharky.fi'
),
tx_combined AS (
SELECT
tx_to AS whale,
SUM(amount) AS sharx_in,
0 AS sharx_out
FROM solana.core.fact_transfers
WHERE mint IN (SELECT mint FROM nft_mint_addresses)
AND block_timestamp > CURRENT_DATE - INTERVAL '30 days'
GROUP BY whale
UNION ALL
SELECT
tx_from AS whale,
0 AS sharx_in,
SUM(-amount) AS sharx_out
FROM solana.core.fact_transfers
WHERE mint IN (SELECT mint FROM nft_mint_addresses)
AND block_timestamp > CURRENT_DATE - INTERVAL '30 days'
GROUP BY whale
),
balance AS (
SELECT
whale,
QueryRunArchived: QueryRun has been archived