faraz-Lvyyy8Untitled Query
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with eth as (
select avg(TxPS),
avg(transaction_count) as average_transaction_per_block,
avg(block_time) as average_block_time
from
(
select t1.HASH,
t1.TX_COUNT as transaction_count,
iff(TIMESTAMPDIFF(milliseconds,t1.BLOCK_TIMESTAMP,t2.BLOCK_TIMESTAMP)!=0,TIMESTAMPDIFF(milliseconds,t1.BLOCK_TIMESTAMP,t2.BLOCK_TIMESTAMP),1)/1000 as block_time,
(transaction_count/block_time) as TxPS
from ethereum.core.fact_blocks as t1
join ethereum.core.fact_blocks as t2
on t1.HASH=t2.PARENT_HASH
where t1.block_timestamp >= '2022-08-13')
),
solana as (
select avg(TxPS),
avg(transaction_count) as average_transaction_per_block,
avg(block_time) as average_block_time
from
(
select t1.TX_COUNT as transaction_count,
iff(TIMESTAMPDIFF(milliseconds,t1.BLOCK_TIMESTAMP,t2.BLOCK_TIMESTAMP)!=0,TIMESTAMPDIFF(milliseconds,t1.BLOCK_TIMESTAMP,t2.BLOCK_TIMESTAMP),1)/1000 as block_time,
(transaction_count/block_time) as TxPS
from solana.core.fact_blocks as t1
join solana.core.fact_blocks as t2
on t1.BLOCK_HASH=t2.PREVIOUS_BLOCK_HASH
where t1.block_timestamp >= '2022-08-13')
)
select 'eth' as blockchain,* from eth
UNION
select 'solana' as blockchain,* from solana
Run a query to Download Data