Quiz #21 February 7:00 AM

1. What was the sales volume in $ for Lil Pudgys for the last 7 days using Increment?

   1. as a hint, you can tell them to use the JPEG analysis no code solution.
   2. they need to find the lil pudgys smart contract address
   3. they need to go to the revenue tab on the JPEG analysis
   4. They need to change the param to ETH, to the last 7 days and input the collection address
   5. The result should be something like this (the number will change)

   

2. Name 5 different regions Covalent team members

Quiz #20 Friyay February 02 5:00 PM

Quiz #19 January 31 7:00 AM

Increment questions:

1. What’s the name of the no-code analytic solution for NFT on Increment?

   1. JPEG Analysis

2. What is the aggregate function on Increment to find the first unique value encountered? https://www.covalenthq.com/docs/increment/sql-functions/clickhouse-aggregate-functions/

   1. count

3. What’s Covalent’s 4 Core values? Which one resonates with you the most and why?

   1. Urgency, Relentless, First Principles, Ownership

4. What is the total DEX volume in the last week on Avalanche using Increment?

   1. as a hint, you can tell them to use the Chain GDP no code solution.
   2. as a second hint, you can tell them that it is on the revenue tab
   3. they need to change the parameters to Avalanche and the correct date
   4. The result should be something like this (the number will change)

   

5. https://www.covalenthq.com/docs/api/transactions/get-all-transactions-in-a-block/

   1. How many transactions occurred in this Block: 19124154 224

6. https://www.covalenthq.com/docs/api/security/get-token-approvals-for-address/

   1. How many token approvals does this wallet: 0x7D36dfC0449861D1D19BDE7146baCC04BC32bEeA have under Matic-mainnet?
      1. 1
      2. What is the token/ticker symbol? USDT

7. What is this contracts name for this pool-address for Aave 0x683923db55fead99a79fa01a27eec3cb19679cc3?

   1. Fei USD

8. https://www.covalenthq.com/docs/increment/data-models/swap-land/

   1. What is Increment’s Swap Land Data Model and what data metrics can you analyze? data such as swap count, swap volume, buying and selling pressure, liquidity flows and much more

9. Describe Danksharding like I’m 5 years old. (Complicated answers -10 Coval)

   1. Danksharding is a sharding design that implements the concept of a merged market fee; unlike regular sharding, in which shards have both different block and block proposers, only one proposer exists in danksharding.

   The block builders have the duty of choosing the data and transactions that go into each slot of a block.

   Danksharding and sharding are interrelated, but they are different. While sharding is the overall design for the splitting of networks in an effort to scale Ethereum, danksharding is a step towards the actualization of this goal.

   Tim Beiko—one of the foremost Ethereum researchers—explained on the Bankless podcast the origin of the name Danksharding, which was named after another veteran Ethereum researcher, Dankrad Feist.

10. last question to a newbie