PS0G1sol wallets beh
    Updated 2023-05-01
    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