mahdishUntitled Query
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with holders AS (
SELECT
block_timestamp,
post_balance.value:owner AS wallet,
post_balance.value:mint AS token,
post_balance.value:uiTokenAmount:uiAmount AS amount,
ROW_NUMBER() OVER (PARTITION BY wallet, token ORDER BY block_timestamp DESC) AS rank
FROM solana.core.fact_transactions,
LATERAL FLATTEN(input => post_token_balances) post_balance
WHERE SUCCEEDED = 'True'
AND post_balance.value:owner = wallet
AND post_balance.value:mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
AND block_timestamp >= '2022-03-15'
ORDER BY 1,2,4
)
SELECT
count(distinct(wallet))
from holders
where rank=1
AND amount IS NOT NULL
AND amount != ''
Run a query to Download Data