WITH firstWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-04-20' AND date(BLOCK_TIMESTAMP) < '2022-04-27' ), secondWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-04-27' AND date(BLOCK_TIMESTAMP) < '2022-05-04' ), thirdWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-05-04' AND date(BLOCK_TIMESTAMP) < '2022-05-11' ), fourthWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-05-11' AND date(BLOCK_TIMESTAMP) < '2022-05-18' ), fifthWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-05-18' AND date(BLOCK_TIMESTAMP) < '2022-05-25' ), sixththWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-05-25' AND date(BLOCK_TIMESTAMP) < '2022-06-01' ), seventhWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-06-01' AND date(BLOCK_TIMESTAMP) < '2022-06-08' ), eightthWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-06-08' AND date(BLOCK_TIMESTAMP) < '2022-06-15' ), ninethWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-06-15' AND date(BLOCK_TIMESTAMP) < '2022-06-22' ), tenthWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-06-22' AND date(BLOCK_TIMESTAMP) < '2022-06-29' ), eleventhWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-06-29' AND date(BLOCK_TIMESTAMP) < '2022-07-05' ), twelvethWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-07-05' AND date(BLOCK_TIMESTAMP) < '2022-07-12' ), thirteenthWeekUsers AS( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as WeekUsers FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-07-12' AND date(BLOCK_TIMESTAMP) < '2022-07-19' ), allUsers AS( SELECT WeekUsers, 'Week 01' as week FROM firstWeekUsers UNION SELECT WeekUsers, 'Week 02' as week FROM secondWeekUsers UNION SELECT WeekUsers, 'Week 03' as week FROM thirdWeekUsers UNION SELECT WeekUsers, 'Week 04' as week FROM fourthWeekUsers UNION SELECT WeekUsers, 'Week 05' as week FROM fifthWeekUsers UNION SELECT WeekUsers, 'Week 06' as week FROM sixththWeekUsers UNION SELECT WeekUsers, 'Week 07' as week FROM seventhWeekUsers UNION SELECT WeekUsers, 'Week 08' as week FROM eightthWeekUsers UNION SELECT WeekUsers, 'Week 09' as week FROM ninethWeekUsers UNION SELECT WeekUsers, 'Week 10' as week FROM tenthWeekUsers UNION SELECT WeekUsers, 'Week 11' as week FROM eleventhWeekUsers UNION SELECT WeekUsers, 'Week 12' as week FROM twelvethWeekUsers UNION SELECT WeekUsers, 'Week 13' as week FROM thirteenthWeekUsers ), allActiveETHUsers AS ( SELECT COUNT(DISTINCT(FROM_ADDRESS)) as ETHActive FROM ethereum.core.fact_transactions WHERE date(BLOCK_TIMESTAMP) >= '2022-04-20' ) SELECT week, WeekUsers, (WeekUsers/ETHActive)*100 AS UserActivity FROM allUsers,allActiveETHUsers ORDER BY 1

Query	Creator	Created
Ethereum Weakly Users Retention ethereum evm	abdollahkazemi	Jul 17, 2022
Failed Percentage ethereum solana evm	abdollahkazemi	Jul 18, 2022
Compare Transactions Per Minute ethereum solana evm	abdollahkazemi	Jul 18, 2022
Ethereum Blocks Per Day ethereum evm	abdollahkazemi	Jul 19, 2022
Daily TPM Ethereum ethereum evm	abdollahkazemi	Jul 19, 2022

abdollahkazemi