flipside

    The programs interacting with UST in February
    SocioCryptoThe programs interacting with UST in February
    Updated 2022-02-15
    SELECT program_id, count (DISTINCT tx_id) as n_txs
    from solana.transactions
    where (pre_mint = 'A96PoNcxa9LMxcF9HhKAfA1p3M1dGbubPMWf19gHAkgJ' or
    pre_mint = 'CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm' or
    pre_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' or
    post_mint = 'A96PoNcxa9LMxcF9HhKAfA1p3M1dGbubPMWf19gHAkgJ' or
    post_mint = 'CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm' or
    post_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i')
    AND block_timestamp >= '2020-02-01'
    AND succeeded = 'TRUE'
    group by program_id
    order by n_txs DESC
    Run a query to Download Data