Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
0 answers
16 views

Return transactions for a specific pair - TheGraph

I am trying to return the latest 1000 transactions for a specific pair in Uniswap V2 using The Graph playground. The pair I am using is for USDC/WETH and its id is: ...
user avatar
  • 220
0 votes
1 answer
79 views

Is there a multi-call equivalent for calls that aren't made to a smart contract?

I have an array with a bunch of events. I get the block number from these events but I also need the block.timestamp which isnt returned in the event object, its returned by getting the block. So I am ...
user avatar
0 votes
1 answer
127 views

Decode input data in bigquery on polygon

I have a problem in developing a program to decode the input data of transactions created by a smart contract on the polygon blockchain. The smart contract: https://polygonscan.com/address/...
user avatar
1 vote
0 answers
43 views

convert time to utc in Dune Query

I can create a query on the DuneAnalytics site, but the default date format for a field is "2022-02-08 02:44", which downloads to csv as "2022-02-08T02:44:46+00:00". Does anyone ...
user avatar
0 votes
0 answers
65 views

Smart contract storage and querying with for loop for large number of data

I saw a lot of similar questions in this site but all of them have answers that relates to a workaround for a small number of data. I have a smart contract where I store a list of contract addresses ...
user avatar
  • 62
2 votes
1 answer
393 views

How to gather historical events emitted by any contract

I am trying to gather all events of a specific type on the entire chain, regardless of what contract emitted them. When trying to find solutions online, I came across code like the following (source): ...
user avatar
  • 386
1 vote
1 answer
754 views

How to query my Polygon NFTs created on Opensea?

sadly I realized, that while querying my assets on Opensea, as well as collections, is feasible through OpenSea Api for Ethereum NFTs, the same is not true for Polygon Collections and NFTs in my ...
user avatar
2 votes
1 answer
167 views

Fetching InternalType data from another contract

basically I have this ABI for a contract {"internalType":"bytes","name":"_DATA","type":"bytes"}],"name":"function","...
user avatar
0 votes
0 answers
21 views

Why there are multiple contract creation record from same address on crypto_ethereum.contracts from Google BigQuery

I just start using Google BigQuery to analyze the Ethereum Network. When I execute the following query: SELECT * FROM `bigquery-public-data.crypto_ethereum.contracts` WHERE address='...
user avatar
1 vote
0 answers
49 views

The graph, filter query by relationship non id value

I have these types: type Poll @entity { id: ID! hash: String! contributions: [Contribution!]! @derivedFrom(field: "poll") } type Contribution @entity { ...
user avatar
  • 33
0 votes
0 answers
536 views

How to display the NFT of my project on React?

I made a project where people can mint my NFT and now I would like to create a webpage on react where the users can see the NFTs that they had minted. Basically, I would like to take the address of ...
user avatar
  • 11
0 votes
1 answer
387 views

How to query contract input (address) using Etherscan's API?

How would I query using their API? Below doesn't seem to want to work, I'm querying for canMint() where it takes in address[] and returns a Boolean. https://api-rinkeby.etherscan.io/api?module=proxy&...
user avatar
  • 3
0 votes
0 answers
415 views

Using a full archival node like Parity or Geth, how to query which is the last transaction which changed the value of a particular storage address

I tried various third party services like Infura, and there support all told me that this was unsupported and that I would have to run my own Parity full archival node for this. But even if I would ...
user avatar
1 vote
0 answers
121 views

How to get total tether supply on Ethereum from BigQuery dataset

I've noticed that the numbers for Totaly supply of Tethers seem to diverge on the official Tether transparency page and the Etherscan block explorer, and I want to find a way to get the correct number....
user avatar
  • 11
0 votes
1 answer
40 views

Mappings inside functions to filter query

I have a struct and several boolean mappings that are used to keep track of struct's properties struct Animal { string species; bytes32 ID; } mapping (bytes32 => Animal) public Animals; ...
user avatar
0 votes
1 answer
574 views

Query Ethereum Blockchain for functions return value of a Specified Smart Contract

I want to get smart contract functions return value sent by a specified smart contract within a range of blocks. I found a [manual] working method to achieve this: async function getTxsByAccount(...
user avatar
  • 318
1 vote
0 answers
112 views

How to open Parity database from javascript (how to open column families)?

I am trying to connect to Parity database at var dbPath = 'C:\\Users\\username\\AppData\\Local\\Parity\\Ethereum\\chains\\ethereum\\db\\906a34e69aec8c0d\\overlayrecent\\db' form javascript using npm ...
user avatar
  • 221
0 votes
1 answer
99 views

How does CryptoKitties query price data? (To make filters)

so I was just wondering on how CryptoKitties work. Like in order to query the price of each Kitty, do they querry like every single Kitty's price and then sort it out. Or is there a function or a ...
user avatar
2 votes
2 answers
1k views

Error: Couldn't decode bytes32 from ABI: 0x The size doesn't match

I am querying a mapping via a web3 call like this: var Web3 = require('web3'); const web3 = new Web3(new Web3.providers.HttpProvider('https://kovan.infura.io/key...')); var contractABI = new web3....
user avatar
4 votes
2 answers
19k views

How to get metadata from ERC721

I'm trying to get Metadata from ERC721 token. Actually I'm trying to do it via ETHERSCAN and blockcypher APIs but I can't find the metadata in the response (like the Picture URL or the IPFS ID) Can ...
user avatar
  • 183
3 votes
0 answers
168 views

Ethereum block chain extracter and parser like blocksci

I'm new to ethereum and I would like to develop an analyzing framework for ethereum. Is there a blockchain extractor and a parser to similar to blocksci available for ethereum and support analyzing of ...
user avatar
  • 61
4 votes
2 answers
2k views

Index and query blockchain data and levelDB

Would it be more performant to query the blockchain data directly through the underlying database levelDB instead of using the provided geth api? How would it be possible? Can I just index the ...
user avatar
  • 563
3 votes
1 answer
1k views

Querying the blockchain: Search transaction by data

Is it possible to perform queries on the blockchain, based on transaction properties (other then hash), such as its data/sender/value/etc fields? For example, is it possible to "ask the blockchain" to ...
user avatar
3 votes
1 answer
389 views

API to enumerate the blocks from a specific day

I'm trying to find an API that lists all the blocks from a specific day, as we can do with bitcoin: https://blockchain.info/pt/blocks/1515628800000?format=json I've searched etherscan.io and ...
user avatar
2 votes
2 answers
140 views

ETH blockchain reading scalability

Quick premise, I'm super new to blockchain and Solidity. I've tried to figure out scalability implication of reading data from the blockchain. I understand that reading operations are free, but how ...
user avatar
  • 149
1 vote
0 answers
37 views

Is it possible to query blockchain using wallet extra-infos?

I read here how to add extra fields to a wallet address, is it possible to query the ethereum blockchain and find all wallets with the same extra-filed? For example: all wallets with the same user ...
user avatar
  • 65
11 votes
3 answers
9k views

Solidity error when encoding arguments to query public mapping

While developing a Smart Contract with Solidity on Remix , after creating the contract I'm trying to query a public mapping: mapping (address => uint256) public balanceOf; but when I call ...
user avatar
2 votes
1 answer
1k views

Asynchronously querying the block chain

This question is related to this one or this one. There is a tutorial here that shows some filtering examples but it doesn't get into transaction level granularity. Can we query the block chain by ...
user avatar
  • 5,154
6 votes
1 answer
2k views

How run queries on the block chain?

since I am quite new to Eth I have the following question : there are some transactions made between two parties which are saved in the block chain. On window.onload() prior to rendering my components,...
user avatar
5 votes
1 answer
3k views

Listing transactions in a private blockchain?

In a private blockchain, is it possible to list the transactions based on from and to parameters in a transaction. Is it possible to check the latest transaction from or to an address? Also, is it ...
user avatar
  • 3,855
4 votes
2 answers
7k views

How to query local Ethereum blockchain for a specified transaction?

I want to find specified transaction. How can I query my local Ethereum blockchain from the console?
user avatar
  • 733
6 votes
2 answers
753 views

How does etherchain access and query Ethereum blockchain transaction data?

Can whatever method that etherchain are using to access and query the blockchain data also be leveraged by the average web developer in a garden variety web app using a remote call? Or, are etherchain ...
user avatar