基于区块链的毕业设计query_ethereum – 查询以太坊

本文提供基于区块链的毕业设计国外最新区块链项目源码下载,包括solidity,eth,fabric等blockchain区块链,基于区块链的毕业设计query_ethereum – 查询以太坊 是一篇很好的国外资料

query_ethereum

A project to create a tutorial for querying Ethereum with SQL using Dune Analytics. In the process, a dashboard for the Dune community will be created.

Motivation

Code & Resources Used

  • Query Ethereum with SQL by Sascha Gobel from AnyBlock Analytics blog

  • Block explorers: Etherscan, Blockscout, Etherchain, Ethplorer, Blockchair

  • YazzyYaz-Ether-Queries

Documenting Progress

4/12/2021

  • Set-up project structure, gather resources.

  • Starting Point: ethereum.org Block-Explorers

  • AnyBlock Analytics post • Things to note: • Data model for Ethereum SQL index • SQL tables and data sources • AnyBlock SQL Documentation • Google Spreadsheet: Data Model for Ethereum SQL Index

4/21/2021

  • Create queries for ethereum.”blocks”, covering block size, timestamp, miner addresses, network difficulty, daily gas limit and use.
  • Next step: Hash Rate, parent hash and nonce
  • Create Queries for Transactions

4/23/2021

  • Create Network Hashrate Query (inspired by YazzyYaz)
  • Create Hashrate to match early Ethereum Classic, but eventually run into “Error: Division by 0”
  • Next step: hashrate_by_day.sql, hashrate_by_hour.sql, hashrate_daily_average.sql link

4/25 – 4/26

  • Create Daily Network Hashrate Query
  • Next step: create Ethereum Block dashboard

4/28

  • Read article listing policy on ethereum.org

  • Up to date?: Yes.

  • Information accurate? (Factual or Opinion-based) How-To, SQL Queries, Factual

  • Author credible? (Reference sources) Will sync with content from Block Explorers and Intro to Ethereum and Blocks

  • Related topics: Accounts, Transactions and Introduction to Ethereum

  • Brings something new to the table? (i.e., see tutorial with same tags, is it redundant?): Yes, existing ‘query’ articles focus on the developer side. This article caters to data analyst. This article focuses on SQL to query the data on the UI made by Dune Analytics.

  • Which user persona does this serve?: Beginner / Enthusiast / Data Analyst (not necessarily developer)

  • Submit an [Issue: Suggest a Tutorial] , things to include for a tutorial:

  • Tags: [tentative] QUERYING, ANALYTICS, DUNE ANALYTICS, SQL, POSTGRESQL

  • Title: [tentative] Understanding Ethereum fundamentals with SQL

  • Description: [tentative] To compliment relying on APIs provided by Block Explorers (i.e., Etherscan), this tutorial shows readers how to query that data themselves using Dune Analytics.

  • Published elsewhere: TBD

  • Skill Level: Beginner – Intermediate

  • Actual Tutorial

  1. Create a Dashboard on Dune, write descriptions/walk-through to help readers understand Ethereum Blocks
  2. Next step: Curate materials on what people need to understand about ‘blocks’, then create queries
  • block rewards daily by miner
  • Average Blocks produced per second (shouldn’t be less than zero)
  • Blocks Per Day (done)
  • Number of Transactions / Block
  • Add more…

Key Metrics from the Block Explorer

  • Starting Point: ethereum.org Block-Explorers, things to query within Dune

note: Focus on current Ethereum chain, not Eth2 (date: 12/4/2021)

Blocks, standard data

  • Block height ?
  • Timestamp: time at which a miner mined the block.
  • Transactions: The number of transactions included within the block. ( COUNT(*) in ethereum.”transactions”)
  • Miner: Address of the miner who mined the block.
  • Reward ?
  • Difficulty: The difficulty associated with mining the block.
  • Size: The size of the data within the block (measured in bytes). ?? (block size vs size of data within block)
  • Gas used: The total units of gas used by the transactions in the block.
  • Gas limit: The total gas limits set by the transactions in the block.
  • Extra data ?

Blocks, advanced data

  • Hash: The cryptographic hash that represents the block header (the unique identifier of the block). (Hash and Hash Rate are not the same) ??
  • Parent hash: The hash of hte block that came before the current block.
  • Sha3Uncles ?
  • StateRoot ?
  • Nonce: A value used to demonstrate proof-of-work for a block by the miner.

Uncle blocks ? Gas ?

Transactions, standard data

  • Transaction hash: A hash generated when the transaction is submitted.
  • Status: An indication of whether the transaction is pending, failed or a success (see: ethereum.”transactions” success (bool))
  • Block: The block in which the transaction has been included. (ethereum.”blocks” number, ethereum.”transactions” block_number?)
  • Timestamp: The time at which a miner mined the transaction (see: block_time?)
  • From: The address of the account that submitted the transaction.
  • To: The address of the recipient or smart contract that the transaction interacts with.
  • Tokens transferred ?
  • Value: The total ETH value being transferred.
  • Transaction fee ?

Transactions, advanced data

  • Gas limit: The maximum numbers of gas units this transaction can consume.
  • Gas used: The actual amount of gas units the transaction consumed.
  • Gas price: The price set per gas unit.
  • Nonce: The transaction number for the from address (starts at 0 so a nonce of 100 would actually be the 101st transaction submitted by this account)
  • Input data: Any extra information required by the transaction (see: data?)

Accounts, user ?

Accounts, smart contracts

  • Contract creator ?
  • Creation transaction ?
  • Source code ?
  • Contract ABI: The Application Binary Interface of the contract – the calls the contract makes and data received (see: abi?)
  • Contract creation code ?
  • Contract events ?

Tokens (see specific Tokens)

Network

  • Difficulty: The current mining difficulty (see: ethereum.”blocks” difficulty?)

  • Hash rate ?

  • Total transactions ?

  • Transactions per second ?

  • ETH price ?

  • Total ETH Supply ?

  • Market cap ?

  • For later:

  • Blocks, advanced data

Available Ethereum Tables in Dune Analytics

  1. Blocks: difficulty*, gas_limit*, gas_used*, hash*, miner*, nonce*, number*, parent_hash*, size*, time*, total_difficulty
  2. Contracts: abi*, address, base, code*, created_at, dynamic, name, namespace, updated_at
  3. Logs: block_hash, block_number, block_time, contract_address, data, index, topic1, topic2, topic3, topic4, tx_hash, tx_index
  4. Signatures: abi, id, signature
  5. Traces: address, block_hash, block_number, block_time, call_type, code, error, from, gas, gas_used, input, output, refund_address, sub_traces, success, to, trace_address, tx_hash, tx_index, tx_success, type, value
  6. Transactions: block_hash, block_number*, block_time*, data*, from*, gas_limit*, gas_price*, gas_used*, hash*, index, nonce*, success*, to*, value*

Key SQL Queries

Tutorial

Querying Ethereum with SQL on Dune Analytics


查询以太坊eth

创建使用Dune Analytics使用SQL查询以太坊eth的教程的项目。在此过程中,将创建沙丘社区的仪表板

动机

代码&使用的资源

  • 通过任何块分析博客的Sascha Gobel查询以太坊eth
  • 区块探索者:Etherscan、Blockscout、Etherchain、Ethplorer、Blockchair、YazzyYaz Ether查询建立项目结构,收集资源
  • 起点:ethereum.org Block Explorers

记录进度

设置项目结构,收集资源

  • AnyBlock Analytics post•注意事项:•ethereum SQL index的数据模型•SQL表和数据源•AnyBlock SQL文档•Google电子表格:ethereum SQL index的数据模型
  • 为ethereum创建查询。“blocks”,包括块大小,时间戳,矿工地址,网络难度,每日瓦斯限额和使用
  • 下一步:Hash Rate、parent Hash和nonce创建事务查询,hashrate_daily_average.sql链接

提交一个[问题:建议一个教程],教程要包括的内容:

  • 创建每日网络hashrate查询
  • 下一步:创建以太坊eth块仪表板
  • 阅读以太坊eth.org上的文章列表策略

标签:[暂定]查询,分析,沙丘分析,SQL,POSTGRESQL

  • 最新?:是
  • 这个服务于哪个用户角色?:初学者/爱好者/数据分析师(不一定是开发人员)
  • 提交一个[问题:建议一个教程],教程要包括的内容:

标题:[暂定]了解以太坊eth基础知识与SQL

  • 标签:[暂定]查询,分析,沙丘分析,SQL,POSTGRESQL标题:[暂定]使用SQL了解以太坊eth基础知识描述:[暂定]为了补充对块探索者(即Etherscan)提供的API的依赖,本教程向读者展示如何使用Dune Analytics自己查询数据
  • 其他地方出版:待定

描述:[暂定]为了补充对块探索者(即Etherscan)提供的api的依赖,本教程向读者展示了如何使用Dune Analytics查询数据本身

  • 技能水平:初学者-中级
  • 实际教程
  • 在Dune上创建一个仪表板,写下描述/走查以帮助读者理解以太坊eth积木
  • 下一步:收集人们需要了解的关于“积木”的资料,然后创建查询
  • 矿工每天的区块奖励
  • 平均每秒生成的区块(不应小于零)
  • 每天的区块(完成)
  • 事务数/block
  • 添加更多
  • 出发点:ethereum.org Block Explorers,在沙丘中查询的东西
  • Block height以太坊eth。“交易”)
  • 矿工:开采区块的矿工的地址
  • 大小:块内数据的大小(以字节为单位)(块大小与块内数据的大小)
  • 使用的气体:块中事务使用的气体的总单位
  1. 气体限值:区块中事务设置的总气体限值
  2. 额外数据
  • 父哈希:位于当前块之前的块的哈希
  • Nonce:矿工用于证明区块工作的值
  • 事务哈希:提交事务时生成的哈希
  • 状态:指示事务是挂起、失败还是成功(请参阅:以太坊eth。“事务”成功(bool))
  • 块:包含事务的块(以太坊eth。“区块”编号,以太坊eth。“交易”区块编号?

来自块资源管理器的关键指标

  • 时间戳:矿工开采交易的时间(请参阅:区块时间?

ETH价格

总供应量

  • 发件人:提交交易的帐户的地址
  • 收件人:与交易交互的收件人或智能合约的地址
  • 代币转移
  • 值:正在转移的ETH总值
  • 气体限制:此交易可消耗的最大气体单位数
  • 天然气价格:每单位天然气的价格
  • Nonce:from地址的事务编号(从0开始,因此100的Nonce实际上是此帐户提交的第101个事务)
  • 输入数据:事务所需的任何额外信息(请参见:数据?
  • 合同创建者
  • 源代码

市值

  • 合同ABI:合同的应用程序二进制接口-合同发出的调用和接收的数据(参见:ABI?
  • 合同创建代码
  • 难度:当前挖掘难度(请参阅:以太坊eth。“块”难度?
  • 哈希率
  • 对于以后:

以后:

块,高级数据

  • 块,高级数据
  • 块:难度*,气体限制*,气体使用*,哈希*,矿工*,nonce*,数字*,父u哈希*,大小*,时间*,总u难度
  • 契约:abi*,地址,基,代码*,创建的u at,动态,名称,命名空间,更新的u at
  • 日志:block u哈希,block u数字,block u时间,合同地址、数据、索引、主题1、主题2、主题3、主题4、发送哈希、发送索引
  • 签名:abi、id、签名
  • 跟踪:地址、块哈希、块哈希号、块时间、呼叫类型、代码、错误、发件人、气体、气体使用的气体、输入、输出、退款地址、子u跟踪、成功、收件人、跟踪u地址、发送哈希、发送索引、发送成功、类型,value事务:blocku hash,blocku number*,blocku time*,data*,from*,gasu limit*,gasu price*,gasu used*,hash*,index,nonce*,success*,to*,value*
  • Tokens transferred ?
  • Value: The total ETH value being transferred.
  • Transaction fee ?

Transactions, advanced data

  • Gas limit: The maximum numbers of gas units this transaction can consume.
  • Gas used: The actual amount of gas units the transaction consumed.
  • Gas price: The price set per gas unit.
  • Nonce: The transaction number for the from address (starts at 0 so a nonce of 100 would actually be the 101st transaction submitted by this account)
  • Input data: Any extra information required by the transaction (see: data?)

Accounts, user ?

Accounts, smart contracts

  • Contract creator ?
  • Creation transaction ?
  • Source code ?
  • Contract ABI: The Application Binary Interface of the contract – the calls the contract makes and data received (see: abi?)
  • Contract creation code ?
  • Contract events ?

Tokens (see specific Tokens)

Network

  • Difficulty: The current mining difficulty (see: ethereum.”blocks” difficulty?)

  • Hash rate ?

  • Total transactions ?

  • Transactions per second ?

  • ETH price ?

  • Total ETH Supply ?

  • Market cap ?

  • For later:

  • Blocks, advanced data

沙丘分析中可用的以太坊eth

  1. Blocks: difficulty*, gas_limit*, gas_used*, hash*, miner*, nonce*, number*, parent_hash*, size*, time*, total_difficulty
  2. Contracts: abi*, address, base, code*, created_at, dynamic, name, namespace, updated_at
  3. Logs: block_hash, block_number, block_time, contract_address, data, index, topic1, topic2, topic3, topic4, tx_hash, tx_index
  4. Signatures: abi, id, signature
  5. Traces: address, block_hash, block_number, block_time, call_type, code, error, from, gas, gas_used, input, output, refund_address, sub_traces, success, to, trace_address, tx_hash, tx_index, tx_success, type, value
  6. Transactions: block_hash, block_number*, block_time*, data*, from*, gas_limit*, gas_price*, gas_used*, hash*, index, nonce*, success*, to*, value*

关键SQL查询

教程

使用沙丘分析中的SQL查询以太坊eth

部分转自网络,侵权联系删除区块链源码网

www.interchains.cc

https://www.interchains.cc/22042.html

区块链毕设网(www.interchains.cc)全网最靠谱的原创区块链毕设代做网站 部分资料来自网络,侵权联系删除! 最全最大的区块链源码站 ! QQ3039046426
区块链知识分享网, 以太坊dapp资源网, 区块链教程, fabric教程下载, 区块链书籍下载, 区块链资料下载, 区块链视频教程下载, 区块链基础教程, 区块链入门教程, 区块链资源 » 基于区块链的毕业设计query_ethereum – 查询以太坊

提供最优质的资源集合

立即查看 了解详情