ThatGuyStarkWare - Layer 2 Blocks - 1. daily block_count
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far?
-- How much fees have been paid(generated) to Ethereum network?
-- Has StarkNet contributed to saving in transaction fees for its users?
-- Hint: Each StarkNet block is registered on ethereum blockchain by means of a transaction emanating
-- from the StarkNet operator: 0x2C169DFe5fBbA12957Bdd0Ba47d9CEDbFE260CA7
-- to StarkNet core contract: 0xc662c410C0ECf747543f5bA90660f6ABeBD9C8c4
SELECT
block_timestamp::date as date,
count(*) as block_count
FROM ethereum.core.fact_transactions
WHERE FROM_ADDRESS = lower('0x2C169DFe5fBbA12957Bdd0Ba47d9CEDbFE260CA7')
and TO_ADDRESS = lower('0xc662c410C0ECf747543f5bA90660f6ABeBD9C8c4')
GROUP BY 1
ORDER by 1
Run a query to Download Data