banbannardWallets Investigation - Protocols Interacted Filtered
Updated 2022-08-13
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 tx AS (
SELECT tx_id, signers[0] as wallets
FROM solana.core.fact_transactions
WHERE signers[0] IN ('4hAJEZUydSQBk2GnAuQDGenZvxJgXiZpEB9ms1NSzuP3', '7pRmHcVZRpmqCjZ9xrRQMQvuHS2sM3NLjW9yE6oE7ccu', 'FX5mCTEKAuLWzMsg6gGRWsAWjJW8iMPtRzns68bhiS71', 'GQbrgxZsRGm3XrrcD9RrwaYHNaLDgvLm4Q16sH7Ybo7r', '7Xw76wVtqLYcGPUoAU5QqyJ1bBRyu4BVw4iARRfBBBpP', '3eAqSzYLom3ykReg9SemaRX7yiiPDMRKvKyf3hMwYz1n')
),
base as (select tx_id from tx where wallets like {{wallet_address}})
SELECT date_trunc('day', block_timestamp) as day,
label,
case when label is null then 'Others'
else initcap(label) end as labels,
COUNT(1) AS interaction,
COUNT_IF(succeeded = TRUE) AS success, COUNT_IF(succeeded != TRUE) AS failure, ROW_NUMBER() OVER (ORDER BY interaction DESC) AS rn,
'SuccessFailure'
FROM solana.core.fact_events e LEFT JOIN solana.core.dim_labels l
ON e.program_id = l.address
WHERE e.tx_id IN (SELECT * FROM base)
--AND label_subtype != 'token_contract'
--AND label != 'solana'
GROUP BY 1,2
ORDER BY interaction DESC
Run a query to Download Data