Questions tagged [query]
The query tag has no usage guidance.
32
questions
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: ...
- 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 ...
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/...
- 1
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 ...
- 555
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 ...
- 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):
...
- 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 ...
- 111
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","...
- 21
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='...
- 1
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 {
...
- 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 ...
- 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&...
- 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 ...
- 889
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....
- 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;
...
- 321
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(...
- 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 ...
- 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 ...
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....
- 740
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 ...
- 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 ...
- 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 ...
- 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 ...
- 131
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 ...
- 98
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 ...
- 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 ...
- 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 ...
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 ...
- 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,...
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 ...
- 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?
- 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 ...
- 1,903