Examples

if you got timeout error please, try on other filters or use paid token basic get ton balance result is nano ton divide by 10 9 to get ton { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(address friendly \\"eqdrlq x6jkznhascgghh0h1iog3stk71zn8dcmroj8jpwra\\"){\n account storage balance grams\n }\n}\n" } get transactions for account { "endpoint" "https //dton io/graphql/", "query" "{\n raw transactions(\n address friendly \\"ef9vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvbxn\\"\n order by \\"lt\\"\n order desc true\n lt gt \\"40379620000003\\" # pass last lt from prev request here\n page size 150 # max transactions per 1 request\n ) {\n address\n workchain\n lt\n }\n}" } get transactions count for smart contract hash or by op code { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n order by \\"account storage balance grams\\"\n order desc true,\n account deleted 0\n account storage balance grams gt 100000000000\n ){\n balance account storage balance grams\n address\n workchain\n last tx at gen utime\n }\n}" } batch load a lot of transactions { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n order by \\"account storage balance grams\\"\n order desc true,\n account deleted 0\n account storage balance grams gt 100000000000\n ){\n balance account storage balance grams\n address\n workchain\n last tx at gen utime\n }\n}" } get top accounts by balance over all network { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n order by \\"account storage balance grams\\"\n order desc true,\n account deleted 0\n account storage balance grams gt 100000000000\n ){\n balance account storage balance grams\n address\n workchain\n last tx at gen utime\n }\n}" } nfts get all nfts of wallet { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n parsed nft owner address address friendly \\"eqdrlq x6jkznhascgghh0h1iog3stk71zn8dcmroj8jpwra\\"\n order by \\"parsed nft index\\"\n order desc true\n parsed nft true nft in collection 1 # check that collection approve nft with such address\n account state state init code method name \\"get nft data\\"\n account deleted 0 \n page size 10\n page 0\n ){\n nft address address\n nft workchain workchain\n nft index parsed nft index\n \n \tcollection address parsed nft collection address address\n collection workchain parsed nft collection address workchain\n }\n}" } get all nft items for collection { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n account state state init code method name \\"get nft data\\"\n parsed nft collection address address friendly \\"eqbpa7td5vdwgltzeszsp32mkzqzlqhjaosktax0mkmjhq b\\"\n order by \\"parsed nft index\\"\n order desc true\n parsed nft true nft in collection 1, # check that collection approve nft with such address\n account deleted 0 # account not deleted\n ){\n nft address address\n nft workchain workchain\n nft index parsed nft index\n \n \tcollection address parsed nft collection address address\n collection workchain parsed nft collection address workchain\n \n parsed nft content storage type\n parsed nft content offchain url\n }\n}" } jettons get all wallets for jetton { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n account state state init code method name \\"get nft data\\"\n parsed nft collection address address friendly \\"eqbpa7td5vdwgltzeszsp32mkzqzlqhjaosktax0mkmjhq b\\"\n order by \\"parsed nft index\\"\n order desc true\n parsed nft true nft in collection 1, # check that collection approve nft with such address\n account deleted 0 # account not deleted\n ){\n nft address address\n nft workchain workchain\n nft index parsed nft index\n \n \tcollection address parsed nft collection address address\n collection workchain parsed nft collection address workchain\n \n parsed nft content storage type\n parsed nft content offchain url\n }\n}" } positive jetton wallets top up sum and average { "endpoint" "https //dton io/graphql/", "query" "{\n grouptransactions(\n by \[\\"gen utime toyyyymmdd\\"]\n aggregations \[\n {field \\"parsed jetton wallet balance diff\\", operation \\"sum\\"},\n {field \\"parsed jetton wallet balance diff\\", operation \\"avg\\"}]\n filter by {\n or \[{address friendly \\"eqafbvitaoka9p0i1sazd2peg7fzqip449mtcasd qrlfa9a\\"}], \n gen utime gte \\"2024 07 01 00 00 00\\",\n gen utime lt \\"2024 08 01 00 00 00\\"\n parsed jetton wallet balance diff gt 0 # only positive balance topup\n }\n ) {\n parsed jetton wallet balance diff sum\n parsed jetton wallet balance diff avg\n }\n}" } get all balances of jetton wallets for user { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n parsed jetton wallet owner address address friendly \\"uqdfmsdtwqp5d ykxx xlulvs4hivraky38ftt2hs5yaaima\\" # owner address\n account deleted 0 # account not deleted\n parsed jetton wallet data is approved 1 # wallet is real\n order by \\"parsed jetton wallet balance\\"\n order desc true\n ){\n # jetton address (concat workcahin\ address for raw form)\n parsed jetton wallet jetton address address\n parsed jetton wallet jetton address workchain\n \n # balance of jetton\n parsed jetton wallet balance\n }\n}" } top jettons by locked balances this example is available only for authorized users because of long request time { "endpoint" "https //dton io/graphql/", "query" "{\n wall locks groupaccountstates(\n by \[\\"parsed jetton wallet jetton address workchain\\", \\"parsed jetton wallet jetton address address\\"]\n filter by {\n parsed jetton owner code hash \\"12d793f9c449bef45c7bb43685de21d4e03c7118b5d38f0bf3c7b9beb497900d\\" # all jettons with lock smart contract owner\n }\n aggregations \[\n {field \\"parsed jetton wallet balance\\", operation \\"sum\\"}, # sum of locked balances \n {operation \\"count\\"} # count of lock contracts\n ]\n order by \\"parsed jetton wallet balance sum\\"\n order desc true\n ) {\n parsed jetton wallet jetton address workchain\n parsed jetton wallet jetton address address\n count\n parsed jetton wallet balance sum\n }\n}" } top jettons by holders count this example is available only for authorized users because of long request time { "endpoint" "https //dton io/graphql/", "query" "{\n wall locks groupaccountstates(\n by \[\\"parsed jetton wallet jetton address workchain\\", \\"parsed jetton wallet jetton address address\\"]\n filter by {\n parsed jetton owner code hash \\"12d793f9c449bef45c7bb43685de21d4e03c7118b5d38f0bf3c7b9beb497900d\\" # all jettons with lock smart contract owner\n }\n aggregations \[\n {field \\"parsed jetton wallet balance\\", operation \\"sum\\"}, # sum of locked balances \n {operation \\"count\\"} # count of lock contracts\n ]\n order by \\"parsed jetton wallet balance sum\\"\n order desc true\n ) {\n parsed jetton wallet jetton address workchain\n parsed jetton wallet jetton address address\n count\n parsed jetton wallet balance sum\n }\n}" } jetton wallet trend balance by day { "endpoint" "https //dton io/graphql/", "query" "{\n raw account states(\n parsed jetton wallet owner address address friendly \\"uqdfmsdtwqp5d ykxx xlulvs4hivraky38ftt2hs5yaaima\\" # owner address\n account deleted 0 # account not deleted\n parsed jetton wallet data is approved 1 # wallet is real\n order by \\"parsed jetton wallet balance\\"\n order desc true\n ){\n # jetton address (concat workcahin\ address for raw form)\n parsed jetton wallet jetton address address\n parsed jetton wallet jetton address workchain\n \n # balance of jetton\n parsed jetton wallet balance\n }\n}" } find jetton wallets count for jetton (count of actual accounts by filters) this example is available only for authorized users because of long request time { "endpoint" "https //dton io/graphql/", "query" "{\n groupaccountstates(\n by \[\\"parsed jetton wallet jetton address workchain\\", \\"parsed jetton wallet jetton address address\\"]\n filter by {\n parsed jetton wallet data is approved 1, # account wallet data is approved by jetton\n account deleted 0, # account is not deleted\n parsed jetton wallet jetton address address friendly \\"eqalfk9nvsbhxd41smfo3am3r51cinsps zutao2fz7bijb8\\"} # master jetton address\n aggregations \[{operation \\"count\\"}]\n ) {\n count\n }\n}" }