Ethereum is a decentralized, open-source blockchain with smart contract functionality. Ether (Abbreviation: ETH;[a] sign: Ξ) is the native cryptocurrency of the platform. Among cryptocurrencies, ether is second only to bitcoin in market capitalization.

ethereum is a decentralized, open-source blockchain with smart contract functionality. Ether (Abbreviation: ETH;[a] sign: Ξ) is the native cryptocurrency of the platform. Among cryptocurrencies, ether is second only to bitcoin in market capitalization. Ethereum was conceived in 2013 by programmer Vitalik Buterin.In 2014, development work began and was crowdfunded, and the network went live on 30 July 2015. Ethereum allows anyone to deploy permanent and immutable decentralized applications onto it, with which users can interact.Decentralized finance (DeFi) applications provide a broad array of financial services without the need for typical financial intermediaries like brokerages, exchanges, or banks, such as allowing cryptocurrency users to borrow against their holdings or lend them out for interest. Ethereum also allows users to create and exchange NFTs, which are unique tokens representing ownership of an associated asset or privilege, as recognized by any number of institutions.

Ethereum

Ether(ETH)

Ether (ETH) is the cryptocurrency generated in accordance with the Ethereum protocol as a reward to miners in a proof-of-work system for adding blocks to the blockchain. Ether is represented in the state as an unsigned integer associated with each account, this being the account's ETH balance denominated in wei (1018 wei = 1 ether).[49] Each block, new ETH is generated by the addition of a protocol-specified amount, currently 2 × 1018 wei (equal to 2 ETH), to the balance of any account of the miner's choosing. This is known as the block reward. Additionally, ether is the only currency accepted by the protocol as payment for a transaction fee, which also goes to the miner. The block reward together with the transaction fees provide the incentive to miners to keep the blockchain growing (i.e. to keep processing new transactions). Therefore, ETH is fundamental to the operation of the network. Ether may be "sent" from one account to another via a transaction, which simply entails subtracting the amount to be sent from the sender's balance and adding the same amount to the recipient's balance.

Ether is often erroneously referred to as "Ethereum".

Addresses

Ethereum addresses are composed of the prefix "0x" (a common identifier for hexadecimal) concatenated with the rightmost 20 bytes of the Keccak-256 hash of the ECDSA public key (the curve used is the so-called secp256k1). In hexadecimal, two digits represent a byte, and so addresses contain 40 hexadecimal digits, e.g. 0xb794f5ea0ba39494ce839613fffba74279579268. Contract addresses are in the same format, however, they are determined by sender and creation transaction nonce

Accounts

There are two types of accounts on Ethereum: user accounts (also known as externally-owned accounts) and contracts. Both types have an ETH balance, may send ETH to any account, may call any public function of a contract or create a new contract, and are identified on the blockchain and in the state by an account address.

SWAP

A swap is a derivative contract through which two parties exchange the cash flows or liabilities from two different financial instruments. Most swaps involve cash flows based on a notional principal amount such as a loan or bond, although the instrument can be almost anything.

Gas

Gas is a unit of account within the EVM used in the calculation of a transaction fee, which is the amount of ETH a transaction's sender must pay to the miner who includes the transaction in the blockchain. In user interfaces, gas prices are typically denominated in gigawei (gwei), a subunit of ETH equal to 10−9 ETH.

Ethereum_Core Table Walkthough: Swaps

This particular SQL guide focuses on the new ethereum_core tables. We take you on a step by step journey to look at the number of swaps and volume of swaps for the USDC-WETH pool on Sushiswap.

Visualize the amount of USDC swapped and count of swaps in the USDC-WETH SushiSwap pool by day in the past 7 days using the fact_event_logs table. In this walk through, we are going to analyze emitted swap events from the SushiSwap USDC-WETH pool.

USDC-WETH Pool:

In order to complete this task using the event logs, we will need to explore a few concepts:

1. Finding swap events for the relevant pool
2. Finding token details for relevant tokens
3. Working with JSON object columns
4. Aggregating the data
5. Visualizing our findings

Conclusion

According to the breakdown chart above, we had the highest volume of USDC and the highest number of swaps on November 8, although we had the lowest volume of USDC on November 5 and the lowest number of swaps on November 6.

MAX USDC_VOL in 8 November = 27.54678

MAX SWAP_COUNT in 8 November = 2389

MIN USDC_VOL in 5 November = 1.75422

MIN SWAP_COUNT in 6 November = 613

According to the combined chart above, whenever we had more number of swaps, we also had more volume of USDC. There is a close relationship between these two graphs

Conclusion

According to the chart, swap volume in WETH-USDC is more than the number of swaps in WBTC-WETH

Discord: Sagharkari#0109

Twitter: @sagharkflipsid1

Tweet Link For This Dashboard: