yasmin-n-d-r-htokens swap from
    Updated 2025-02-21
    WITH t1 AS (
    SELECT
    SUM(SWAP_FROM_AMOUNT) AS volume,
    SWAP_TO_MINT
    FROM
    solana.defi.fact_swaps
    WHERE
    SWAP_FROM_MINT = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
    AND block_timestamp >= current_date - 30
    AND SWAP_TO_MINT != 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
    GROUP BY
    SWAP_TO_MINT
    ORDER BY
    1 DESC
    LIMIT
    11
    )
    SELECT
    b.LABEL_TYPE,
    a.volume AS label_volume,
    b.LABEL
    FROM
    t1 a
    INNER JOIN solana.core.dim_labels b ON a.SWAP_TO_MINT = b.address;
    Last run: about 2 months ago
    LABEL_TYPE
    LABEL_VOLUME
    LABEL
    1
    token53390.44922129jito
    2
    token191224.112039668jupiter staked sol
    3
    token1255161.60754666wrapped sol
    4
    token208965.830245346jupiter perps
    5
    token59617.750007616jupiter
    6
    token9058.499814332wormhole token
    7
    token20433.42056583usd coin
    7
    279B
    5s