Solana transactions between timeperiod for liquidity pool

GraphQL API
1

Hi, I’m trying to find all the transactions that removed liquidity from the SOL-USDC pool from Raydium on 04/12/2021. But I’ve never used graphQL and I’m not entirely certain what fields to query for.

Is there a way that I can query for something to remove/add liquidity?
I’ve tried a few things, but without any results so far.

Assuming that if liquidity is removed, it should result in a transaction where the raydium token account for that symbol is the sender:

{
  transfer_via_senders_address: solana(network: solana) {
    transfers(
      date: {is: "2021-12-04"}
      senderAddress: {in: ["5dKxvA9vSGuEk3DYAzugEsfeRPatzYPzxkFFpQDGWDGS", "93oFfbcayY2WkcR6d9AyqPcRC121dXmWarFJkwPErRRE", "9TJMkaSEAwxcCeMovE2T377ZVhhUogx7ia8kxj4Q7cw4", "5qRZJVRBZX7FcGwoZbp39hGd9wZMXayrj2MF2vG3Snz9", "AmzPegAx1Z8FyZdUskdYY5DTqPLtTAtXzjU7Zcq7o5An", "PuKXLP3tPvutPWdjAbPXZwnGAxdS8WY3UKpK7NosS3p", "C6gfrxPbYJERJRgdDbwES7FT9yTWLCpfSHyHzCG1HSdN", "FEjd6Ahm6aR2n6PMX2PxWUhgbHFJV1yq2gyYFBgjWsm4", "zLGXRcckcM4dJnwha7zC9UfeCgxcFjqArtGjni53KFX", "97kDH3P3Eu8R1CC2cAwRWbug4SjQ6aqueK7TKPCkafcL", "FPZZ8bRAfqy5jdXno2d8y6cjHJUZvmGoLUacjzGChH6t", "HwuY4vrgc2mJr5zMHfQeQu35cHUf3Ngsy1dibWGHkYis", "CEs56zmErqyJAYf9ABtuwLJmEk7UNtJ2t9VDnsvruUBD", "DnYVWkML9qmsGgkpyDpCQxsB7YBU5eewdGRApet7gUVG", "2QdNixe37W254FZtRev3TRfia9uoV42fpQepYhADsx2H", "C6dnRNVmAmoKAPhki8k8esqyNCB7XGcxsmw2jy5dSNg7", "B4pnhAkr5YDcMX2fiZSBjBRMmZE3PNEWG8wdWdYBohCa", "J34iLVYk81bzVUdWtr6T4aW2Kt5tZsyHeKX5U23V4JZK", "BokGf4VteP4nhNAwkKokvwxrRa1tp8sSPLG996FqA9i2", "F9RiXdBpHdJzDiuYwS1YzxbyMGMDMBCDfBkiWXD67gND", "MZihwPviJgm5WjHDmh6c5pq1tTipuZnHFN3KBg63Mtj", "DRDqm7rLuGnkh9RU1H2aaaJihRSU2Yg3WhropTWmcpWW", "DCXb2NWyWvyxDX7QMfWZ7tyV6t2iD6cESvEN7kxT8TK7", "J2XqLQXUHQkSrpAFGBiAzSQNBzQPNutKuadSbJG6vRNi", "EPbAw2dYZZn5k5qAW99SE5MogUWSY2gBZM4ithTRRtkw", "3FmHEQRHaKMS4vA41eYTVmfxX9ErxdAScS2tvgWvNHSz", "Gh2YaVC1sjzZQMixnHNXDin6awBAV6p2D5zY8STMu4p4", "EHNe7HAAxbLfZZNKQcxc6k94FBiJTdqptkfjhioKzwhy", "7hLd9dJbp2oWC6puqZwYzmyxR3kUppRRHe4VuHxdHsvH", "AjhU2nq9BrBWTB2bGmD2eH2Wo3Hp3ymY3JHajkvfapG", "2dC2dTyWZvRVBp9m913QsPJEm76Cte7pizJ71v1bjKTP", "CP8VjLiwZkRBdyYzkNUyKZoxFpHUbRWNf631goyxeAQ1", "HK296WcKcEFAKRP6ajdctBZ1YzKzBKxmBWduL76TCKzb", "wcyW58QFNfppgm4Wi7cKhSftdVNfpLdn67YvvCNMWrt", "pbu5uGaQV2niefEo7HM2dWuubeACGgac3MvK1V7HSfj", "EJABt72DKvauPuzXih7yD1dQ33jw52udBH5ML1PiMji9", "7WRhThwJy6rM1phxDMgoYPneeGximFdDNXkzDQuKaUSU", "5odFuHq8jhqtNBKtCu4F2GvUiH5hB1zVfpS9XXbLf35d", "Ath4Yfj3R1VQZirYh2bgQpShYThQZRAWD1F8wHdFrPoB", "8ggtjBeQnA5xF3phPZXgjxqrAn8iea8RB46Xnq9CpMaC", "BooXF6Jz9kyo3ctMF8Htupx8KVXRjaZioTBEnheUD51a"]}
    ) {
      amount
      block {
        hash
        height
      }
      currency {
        address
        decimals
        name
        symbol
        tokenId
        tokenType
      }
      date {
        date
      }
      transferType
      receiver {
        address
      }
      sender {
        address
      }
    }
  }
}

(These are all the USDC token accounts for Raydium liquidity pool)
But this didn’t return any results, so I must have done something wrong.

2

Found what I was looking for, my ignorance when it came to Solana got the better part of me.

{
  solana(network: solana) {
    transfers(
      date: {after: "2021-12-03"}
      transferType: {is: burn}
      currency: {is: "8HoQnePLqPj4M7PUDzfw8e3Ymdwgc7NLGnaTUapubyvu"}
    ) {
      amount
      block {
        hash
        height
        timestamp {
          iso8601
        }
      }
      currency {
        address
        decimals
        name
        symbol
        tokenId
        tokenType
      }
      date {
        date
      }
      transferType
      transaction { signature }
      receiver {
        address
      }
      sender {
        address
      }
    }
  }
}