dannyamahCountry Coins Token Holders
Updated 2024-09-05
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 transfers AS (
SELECT
tx_to AS address,
SUM(amount) AS amount,
CASE
WHEN mint = 'F9mv7XXbrXZb1sP2JUoswbCB3WHQM4QGMFDTVfnRZMnP' THEN 'France Coin'
WHEN mint = '4XQvdipJBdrb5hUgUrbZPPFmp6BCav41n55dc7KDYW3m' THEN 'England Coin'
WHEN mint = '52DfsNknorxogkjqecCTT3Vk2pUwZ3eMnsYKVm4z3yWy' THEN 'Germany Coin'
ELSE mint
END AS token
FROM
solana.core.fact_transfers
WHERE
block_timestamp >= '2024-02-01'
AND mint IN (
'F9mv7XXbrXZb1sP2JUoswbCB3WHQM4QGMFDTVfnRZMnP',
'4XQvdipJBdrb5hUgUrbZPPFmp6BCav41n55dc7KDYW3m',
'52DfsNknorxogkjqecCTT3Vk2pUwZ3eMnsYKVm4z3yWy'
)
GROUP BY
1, 3
UNION ALL
SELECT
tx_from AS address,
SUM(- amount) AS amount,
CASE
WHEN mint = 'F9mv7XXbrXZb1sP2JUoswbCB3WHQM4QGMFDTVfnRZMnP' THEN 'France Coin'
WHEN mint = '4XQvdipJBdrb5hUgUrbZPPFmp6BCav41n55dc7KDYW3m' THEN 'England Coin'
WHEN mint = '52DfsNknorxogkjqecCTT3Vk2pUwZ3eMnsYKVm4z3yWy' THEN 'Germany Coin'
ELSE mint
END AS token
FROM
solana.core.fact_transfers
WHERE
QueryRunArchived: QueryRun has been archived