bitquery queries

list deployed contract addresses by an account

{
  ethereum(network: ethereum) {
    smartContractCalls(
      smartContractMethod: {is: "Contract Creation"}
      caller: {is: "0x9dfc3cbf922cd187990c1bb82a7bd134350c2d37"}
      options: {desc: "date.date"}
    ) {
      date {
        date
      }
      smartContract {
        address {
          address
        }
      }
      block(time: {before: "2021-12-30"}) {
        timestamp {
          time(format: "%Y-%m-%d")
        }
      }
    }
  }
}

txn count and sum of gas used by a contract

query MyQuery {
  ethereum(network: ethereum) {
    transactions(
      success: true
      txTo: {in: ["0x2cec1ed41c42b4573a598979e3d416fb7bbdf4c2", "0x5030e0c9a07b54c45b3ff3bb24c442f5075d6a7f", "0xd76b58f71271988f1235b55693b1a7d383011a92", "0x3212650963f219431ca5080d44373ed9a02cdfbf", "0x890b0f3f7b2917f7d5859bc68e6c6eea1026ba90", "0x9c32c0e817830e40bc0632bb365a092f0e39057a", "0xca883c55082de9cecf72ec60f5e71970b86a0da8", "0x798b964d9807a98d03c9932cb5989291c4c54354", "0x7f9ac1b8c63b95f196ff1daab3b7d6bbb953467d", "0x65b80630c256a527341b6e24c4c5d75558de4939", "0xce77a9f979e700b13b8e27dd4dd9f38d383a7515", "0x511c41f063402a3f5b439f860bd53c7145fab032", "0x7cc1669a3ef1304db932c0dc0bc539b838d1e15e", "0xe22415b337113ca32a32c92f7c60c9f3b4acefd3", "0x66943100bf0464c1ec43b957a5f72fe2d67a3678", "0x01dc689804a1c05040b68388b9fd4a3755837d0c", "0xa377bec3971ed3cb13d9a192fb2fd47599a85572", "0xb671c3883307cf05bb3dff77a9754e87b4347195", "0xd6da3c786d0c54c19dbc11c4bf018c5d6b9da9c3", "0x6c8670c7031ac8ea9ee0b5138038a6a15fc1d37d", "0xb8df363e0dd784defa2c23ad281cad70e34b9895", "0x1ea51f9d4b69745a25b06bf18f8461740322940a", "0x52e2a44945f28ee13ec7fcb9c44573f1de87f2f5", "0x12191e219b41d144cc6f9a8396e07bf9cdb891fb", "0xa34bd5f804a0e5fee22ce37962170f1afd764075", "0xb887261e11d3d9cc3b96ef37ad220140c9c5404b", "0xf70b702bf839c1f338c90f912f2e7ccebf892761", "0xef71862273817c9e082ca2c92486c8dcdcd9356f", "0xdfa42284475636ecc1e04f519b075ec7f1e04f48", "0x13c1b06b5762da081e45f302b0d7696a7fa1f526", "0xfcb65d5e7b8150ee047bcc9b33cac42d24aca1b4", "0xeb661d12171b066a4d0523dbe9d7ed309353eb60", "0x0e7100e836150589b2be7030523d23c86a2093b5", "0x12e1422d9153ff3195e3739d400bd0f78a9d7afb", "0x4023f93668b132e1903c6a4841721ff197ae7b03", "0x83fb0973451090a83a3abca8ec5f30e9c889527e", "0xa68f65bb1169359df1a7c66113c5b4e9a9bbb5d6", "0x79ecdb8c66c6d9e6deb5ef361fb4c360a522f995", "0x4a59f94b5056335595d48f6706c5e1ae90fe8be3", "0xcd8b73c03ba077336c619751e18690bda5b26ff2", "0x985918b0d6d1061950461f1432b1ecd57265ef18", "0xf20660a2dcbd7f6a6cae982e602de46457c38697", "0x4773d4e5647ece557515d63b0c85f1979a7bd850", "0xc0da3b8e1095a7a43b390dd2800c23619ce4c195", "0xc4073985ac969fcc3791790b6d52c7ee529ce959", "0xcdb71cfda8df66e807ee3f9cfc59fe8b375c927d", "0x3d948cb1497985e1096015a14fe40fbb5e4e4f46", "0x42bc516d598b9f4cd474d1978f3723bd822c5259", "0x0b8c1bbb4b27984f33b98fcdd718a01211dfe295", "0x18da3ed5a63f7648b2d6c28e9a4ff11c39abb952", "0xd9e1b7060af802bb5b65412f726c649f0a8671ac", "0x21222bfe9e4ad3fa035f1b79fa7f2268d8b69fd8", "0x9363c9ff9ec654016e52a9c5103d5362bd0a317a", "0x838785a244453f44733420785a1b326fc1604938", "0x228632d36dc76f446fcff09be462717febaf4e00", "0x8dead4d38a9cfa7fdb07b89623e5d14144138649", "0xf16f20b72d51fa9bc9ad97a44be0cf2d8be5d214", "0x615f29457a06db67ebba1a7e5140365f2da0a5c3", "0xecccf44ec93e27d4acac6463515301648f0bf943", "0x0f4fc69c77dd5e1c1941ff6af4a07b75fb32f049", "0x9cd754c2b793cb2ec67e73223a1c3cc46917276f", "0x3fa524897361206cb668f28aeb2365f738ac73a5", "0x42a971e858ba231e82c4fd3ff42ec3dc77dc07c1", "0x51c7c5fd6b1cef7c0ca771ede64402003a00a293", "0x73fadeaef4085ca08effbcd2ea71757f25959828", "0x602f9269b9ca2bdaf004a7a2e0f0f2adc96df04a", "0x9d8edb72714b9b52bc33ecdce7029a9cc08c1b1b", "0x08607a41b816b12799851624de1ead5d65849129", "0x85f5ed5054ed908a7805e69041103b217cd26151", "0xabaa810484e78087dc97a8a4f1b09b967d6c34db", "0x84a07aa4e5d64f51f880e06dcf37cae03316758a", "0x05f4c4ce8dbb059ea37ae8ed31d502df7ab557ff", "0x625bad4d807738cb6eee2541a24ec71dc1e36e62", "0x5e54804d15456eb9a97dc55a5f36db324e4084a2", "0xa8468ba1355d3023e80a224bd8692d6df6deb827", "0xc82f9e7c82059375e3b5e7c39b07b660fdd1c9fd", "0x8e4a852109fa5c27dd18b7143af4c5f9397df07f", "0x5495de7b6b7693accf835ab82ada0bb741152bfa", "0x85f054dc597bd0642a2348622d1149224c880934", "0x8c529f7c72480b9e9ce81fba0ed46effcdebcba2", "0x190ddbf512484a7879e204e9116573ef70c1ba76", "0x9549843f597647615e6705e8c930a3334111335b", "0xd67babd5bccb0c7487fab4b868651a6957a661c2", "0x48a5a32912ced18482d1845ff8e8c5cd7310c8c1", "0x0c9ea0967c33909601a19b5be3164db040a7477f", "0xc5f0633a92c65b299637e43b4b6661cd26127318", "0xa85ca6af4c0787321805505a609062969b53fd99", "0x6e02251cd2e422f08d0c637a1f5a6e7e859b12b8", "0x7eaa901ba5179ae79bd6e05f5992d991ff3c664e", "0xe79fe16336fb3dc2275f9f81b134d55a003de17d", "0x0595e838bbbca326e5c2d7f43f633caff5937120", "0x3d5badc4b5b2e86e72e35b7bd5b8e1c448aaca47", "0x2e4d699863a46b65a919408e742373d2ec1013b8", "0xdd01c9f07699aadd03d085271eae722c443cc9d6", "0xee5abfe81afa459ae282dccc556f11663f9dc561", "0xf7da1e8e28d20c4f71c8c7b6ef427589f9d797cd", "0xeb24201718282d2c9942f0d10e56e4f18e6b3537", "0x785417e9ab581f0bc9caa4f24b657f9a08beb54f", "0x36d468d8680fe9e765d72058039b66836ce366ac", "0x535f5d6e4aac08cae8ef0c5c881e05eecd161576"]}
    ) {
      gasValue(calculate: sum, success: true)
      count
    }
  }
}