flipside

    Copy of MM labels
    KaskoazulCopy of MM labels
    Updated 2022-03-04

    WITH MangoLabels AS (
    SELECT
    address,
    address_name,
    label
    FROM solana.labels
    WHERE label in ('binance', 'kraken', 'ftx', 'coinbase', 'fireblocks', 'wormhole', 'allbridge', 'drift', 'zeta', '01protocol', 'tulip', 'raydium', 'atrix', 'orca', 'saber', 'parrot')
    ),

    MangoToEx AS (
    SELECT
    block_timestamp::date as fecha,
    tx_id,
    label
    -- tx_from_address,
    -- post_mint,
    -- pre_mint
    FROM solana.transactions t
    INNER JOIN solana.labels l--MangoLabels ML
    ON t.tx_from_address = l.address
    WHERE MONTH (fecha) = 2
    AND program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' --Mango Markets V3
    AND succeeded = 'TRUE'
    )

    SELECT *
    FROM MangoToEx
    Run a query to Download Data