the query which fails

Returns the latest transfer on Base, where transfer sender is 0x0000…dead, 0x4e3a…1b60 or 148 more, transfer receiver is 0x0000…dead, 0x4e3a…1b60 or 148 more and currency smart contract is 0x, 0x4200…0006 or 2 more: sender, receiver, smart contract, currency name, currency symbol, unique of transfer receiver and block number.

By ziko_mode · saved 28 November 2024 · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $currencies: [String!], $holders: [String!], $count: Int, $offset: Int) {
  EVM(dataset: archive, network: $network) {
    Transfers(
      where: {Transfer: {Sender: {in: $holders}, Currency: {SmartContract: {in: $currencies}}, Receiver: {in: $holders}}}
      limit: {count: $count, offset: $offset}
    ) {
      Transfer {
        Sender
        Receiver
        Currency {
          SmartContract
          Name
          Symbol
        }
      }
      uniq(of: Transfer_Receiver)
    }
    Blocks(limit: {count: 1}, orderBy: {descending: Block_Number}) {
      Block {
        Number
      }
    }
  }
}

Variables

{"network": "base", "currencies": ["0x", "0x4200000000000000000000000000000000000006", "0x833589fcd6edb6e08f4c7c32d4f71b54bda02913", "0xb1a03eda10342529bbf8eb700a06c60441fef25d"], "holders": ["0x000000000000000000000000000000000000dead", "0x4e3ae00e8323558fa5cac04b152238924aa31b60", "0x97b9d2102a9a65a26e1ee82d59e42d1b73b68689", "0xc1b13e49761244dd511e5085376b43aa94d8804a", "0xc882b111a75c0c657fc507c04fbfcd2cc984f071", "0x0d0707963952f2fba59dd06f2b425ace40b492fe", "0xa317b402db7224f30c1bcb58aa226041eff702ab", "0xcbbd242a7f23e065532a99699b3c76eca3781ad6", "0x45fc328b7c31fcec3be7a322f8309a0e5f348a10", "0x17a3ad8c74c4947005afeda9965305ae2eb2518a", "0x439759d3e07ee8b52cb5ce89683cb2ec472ebb10", "0xdede39a9000b557d15453510ad462745f7448232", "0xadad4ce0c68f50a19cf5063e0b91d701daab1df1", "0x1046b0a8c3b16065add6cfff09c3b53fab24515d", "0x3b54f4fbfafd0e7167dcd70594e2d1b8bcbfe4e9", "0x88529d2289d47e9339938f25f2e56a33c91671cb", "0x5c5d0b1fbec50b3236febbb87b22db5b0e4c7306", "0x9aa0c1e7cdcd1bbe6e5300debb28f377f4488b20", "0x3bb24099f321f2330828fb06693a50433554ba42", "0xae4d720c1fb55990f13fc5f349ef72d1254f6c9a", "0x559d3530ce6a773ed85139f03b48559f677c7309", "0x414e5411e828d69db80d9d0020597bd8b41a4025", "0x1fa304fa4f422e1f552031f3bb9b4d93616ee3b7", "0x47fec26ced1722bdddcbb5b984d433991048d906", "0x61ddd5c961ad9e485fefc7c165feb32fd11ae552", "0x18b597743a03ff55447f9edb73621af89f7cd13a", "0x26c51965f4b5f172f98c7d3f68a55d00076e8653", "0xf6f6d531ed0f7fa18cae2c73b21aa853c765c4d8", "0x1bfc74841fe9ec54ee4013458c98f6907f17e31d", "0xb6ab8502e56abf04232de05604a64a413a2c172f", "0x7d96d012ce7dbc7fcc411eef5152ad26bfac1dab", "0x15a4bc976bf38b8671e5d067a8c78d018fdbebc7", "0x026ebff523e928d5e073ea8b07d9740aacad3480", "0x36563971da38909c917bce229abf78cbb9a70dd7", "0x069a8a46111613043c82406e961efe6a5c443636", "0x653ec2dfd7d8f8943cd487a579b97cbb73e09b33", "0xc73b86953e75552897a592637a4ea46a740027e8", "0x182a532bef261b4aa287dcd3e2dd19ba3d57372a", "0xb18cd39461d03567d4270700b919ac214a2db6d1", "0x967279b2b9d6709e13161d0fe33ff3bc347ff30c", "0x2145917a46839ae87cd11b626aee1d15ce1f8260", "0x087a3f49a7e3585c73adc35ee0465e75ca895a11", "0x6d9f8dd4aa9159a05fc511c5077acb800670dd0a", "0xb50352a036a0bced5247bcf196e535c24cb99d44", "0xee4b10f64e611b86f830b99c4cdfec0cea4ba3f8", "0xe6053aa8a71d10f74d94314d60efefc7a8e5c6b6", "0x227acf4f3d42fa59af9fba86a2b5704edc9c6f4c", "0x2c56e8634c4deb5339dab34b24f2d2d37c21e9c4", "0xeb969856071c7f6fb1bc9a035d83cf0f6256c8d1", "0xb072acf77eb3b09279b433679002045d33668817", "0x326841efd63340767e02ec88e583f18a82af4a48", "0xfca78e50737bc30274a567446a363fb8e5b9814a", "0xa640ce460dcfd2693008c1c38ced030b8ce8ecc4", "0x438a5728fc3ff225a22b48fbaeeb3b55897900d0", "0xb8ff1df8fe89716d3206335fe9c4502fdc5ee244", "0x03a7fdca0a0555e160aaa6af2c4587834f735acd", "0xa4f10b35c19557f74ef5d8bc4e1d8062f3beb900", "0x8a7158f1208e9b1bbda2a0094ce442f52c51f3ac", "0x1322b81caffbb5bc83d496a67b7f3739f865e448", "0xdde1b64bdeb47d92aed6b35ef5a70aa354c5b1db", "0xbf954f39cd07078dc32e52b13b1385205afada1a", "0x29b3965cb076e79ed4ba1691905992f7454629df", "0xe83e7a9ceaf8f26f71686a55677371e77b538194", "0x10dcb538f6fcabaa2d0ae69c621985eb7f197741", "0xd6216fc19db775df9774a6e33526131da7d19a2c", "0x9f00a7114a312a8b67d6c63dd3afdb682d295f6e", "0x24b340d436c0ac856f1efd2c70a615972f5239bd", "0xd74896c519d296d655abade3355f22b94487d9fd", "0x63959bda3f849d9f0e999428f5ac581ee763ef79", "0xc25e850f6cede52809014d4eecca402eb47bdc28", "0x972d78aafcc16d3929292e718eff82c5987c1d04", "0xe8794a823f98c4397668e250cf7dd5265abb044a", "0x5b90dbad511741a80dcf8b0db7aafe89967a36aa", "0x18b0f4547a89fe4c5fe84f258bea3601fa281e9f", "0x20352974c6db6098b3f3e6b86a170da665cae147", "0x7110d94153ccbf0a6f9d11527648549516b4c809", "0x079758d7ac8804cf5b346f30b4ebbe9e7488a89e", "0x68117a395015ce713252d44351a63b02771be539", "0x87422d6a1b319cfe044a61e6ca90f9f043674eba", "0xeca0b6454eff51b7b6092cb85c7f6848b262ba19", "0x6750318c71b66ff9f05a8148423ccf808ccb3f95", "0xa5208d5e111a9b648b465fce646e1b4e8b581b79", "0xd129452859c3e32e11bbb86a0dfa80dbedd84f71", "0x192e893b5dd289a3eaee18e951201c623fb60b30", "0xbf5266ef43aa8cb81432aba230a1f64a760713a8", "0x355fb674f1156a812b93e56a81c36b001dc0cd44", "0x461a5b8326ba0e2dfd133651a3b559dc8d3b0400", "0x6c86f54b9f35e19bcafb7e9764b2bc35486db661", "0x3c823ab935ec2d68a2365916c725358b8df29ae6", "0x86b38d97cdd7476dc08693580a7b2eb828d2ff09", "0x8563329d81dfb138940a46185932bf3b7f46cf04", "0xff177611293ec015e347ac64e261439c3f31f419", "0x4c2a994ef90873e16437b19eaf29171cb19e3453", "0x9732d544061575f6cf7c506aae63727961dac0cc", "0xf9a0f05634e91523a7adbdaecdd6aba81d380ecd", "0x0eb71295d002676cef0fef60e439d410baf83643", "0x9f7d9f7228299d2a7da2b3013475a7141a0858d8", "0x55038f72943144983baab03a0107c9a237bd0da9", "0x63b170042f2d502ca898b321981a8efc3e4a0dd4", "0x0c5a2c72c009252f0e7312f5a1ab87de02be6fbe", "0x277fe0d748958dff41245992baa862933e5c97fe", "0x63bd997a5d3cf91343d68941ef925df6161224dc", "0x4afe513fb3e7747da2a415ab3f8d9327fdea6e09", "0xd95ce06415bebfc3219b699dd2afa09aca38e70e", "0x41a1092006241800f8b0a95b78e2363c90050c3e", "0xf1635ee330900b5d6ff7dee8b8987a75bf42e4ce", "0x3e13d4de93264649fba83cf8666312f2f249e544", "0x9ede0e1d0b1399852c625cbc975fe001cd6db782", "0x3c3092c9c85fb42a1f59c5c937910a52f4910740", "0xc3f6b6c4309ba9a9887216dbebf39fac78406696", "0x3096ebc597f2fd74b62d08f1d438ff17de9b44b6", "0xb6ab277732c89a9d25b2cc7b819947609dc91da3", "0xb796c557a4e9e958d082ee98761baad904664885", "0x78bbdedd45c31f0ae0071ff0e0b6742c2e45b39b", "0x2f1e4b9644a9ee9ec5a786d8aa8e900ad2085058", "0x89a4291bfbbfca84f9b0141b7ea3c40690558a2a", "0x4a8b35c2dbae3cf4fb45aed2335b7953f55414de", "0x64baeb02876aa58078aa25c1c43b7a5492873559", "0xbd19c1af254953188ed78ee35904b6d26b18e5ee", "0xdbfa4a850653e34ee6b8dcc6a29803b4d09c78f2", "0xe91cb49fd461e63a5968d5b9dd87aa83d305977c", "0xdb749839418fbb32d557bb338da7bb77c00bbd13", "0x67862d84ba70e8cc913aeb2ed12019d93c9381f3", "0xfafab363ff1214a32a9b145e65240258ef6f528f", "0x0568b384bfbaf475276f6a1ea118a070d5e06ad9", "0x3d3bcf1509efd667f5f7a1cad5d0e0c6ec318630", "0x4ee3720e0d5a434895744fd6229e6fb06aa991d1", "0x41588ccaa5fb75807c8d745b735569715b6490fe", "0xa70a16710db3fee4446a6965a0768ab90874c1e1", "0x27e93e25acc91601e6fc5e65ddbb6f98040c9936", "0x142f1535e5cf8c5b38cd26669d526bb9bf24c5ca", "0xcbaa21e461d7c061706f9f5a101aa38d99b71d29", "0x4a7186f05b68d1a2fa0f7f327715d0003e5f6689", "0x719249d8766a51d9ce9fe7ed12062d9f74c6359d", "0x2bdf1a698d39a4358e2c162deacc038fadb8a9d5", "0xa5238b9836ddc4c66f7fe0ea9b7467df8a867b55", "0x860e468ca7716dfa0deb4fc84459a74b3974e5c5", "0xb0a55bbeb21665bd0d885f6b15527a180d27793d", "0xe532070de7e4a61979ce036a05802de58ec190b1", "0x3cff5236ef7b734e2675cdf458e813443495aeab", "0x2a4a178abad1ae62e8fd06b2b6c5ae3d5d2e3735", "0x650a1f324584ebbd19639ff589d8216edbaeea8f", "0x382ffce2287252f930e1c8dc9328dac5bf282ba1", "0xe37951822320b28773df9143cf8ab1b7255719a2", "0x9c975819f11a2101830204b5ee8d6493454e558a", "0x7be4e73e85fa4c073020f1a76974a6c9d4f8be2e", "0x5f74843a461ec6aa77b7fa52722435bd07d82150", "0x5dde19008bd540c3e2c8a3a3d8fd64e38b1e95dd", "0xe352e959f682dc284e5ba741006d3d489f80c49e", "0xb943930bb393b501d9776a9cda082e8c2fec4b35"], "count": 25000, "offset": 0}

Similar queries