PS0G1sol wallets beh
Updated 2023-05-01
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
›
⌄
WITH deposits AS (
SELECT
block_timestamp,
tx_id,
tx_from AS user
FROM solana.core.fact_transfers
JOIN solana.core.dim_labels ON mint = address
WHERE tx_to = 'RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx'
AND mint IN ('RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a', 'So11111111111111111111111111111111111111112')
),
main AS (
SELECT * FROM deposits
)
SELECT
label,
count(tx_id) as tx_count
FROM solana.core.fact_events
LEFT OUTER JOIN solana.core.dim_labels
ON program_id = address
WHERE signers[0] IN (SELECT user FROM main)
AND label NOT LIKE 'solana'
AND label IS NOT NULL
GROUP BY label
ORDER BY tx_count DESC
Run a query to Download Data