with f as (SELECT payer as p , block_timestamp as bt , row_number() over (partition by payer order by block_timestamp) as rn from flow.core.fact_transactions ), e as (SELECT from_address as p , block_timestamp as bt , row_number() over (partition by p order by block_timestamp) as rn from ethereum.core.fact_transactions ), s as (SELECT signers[0] as p , block_timestamp as bt , row_number() over (partition by p order by block_timestamp) as rn from solana.core.fact_transactions ), av as (SELECT from_address as p , block_timestamp as bt , row_number() over (partition by p order by block_timestamp) as rn from avalanche.core.fact_transactions ), b as (SELECT from_address as p , block_timestamp as bt , row_number() over (partition by p order by block_timestamp) as rn from bsc.core.fact_transactions ), al as (SELECT sender as p , block_timestamp as bt , row_number() over (partition by p order by block_timestamp) as rn from algorand.transactions ), flow_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'flow' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT payer , block_timestamp , row_number() over (partition by payer order by block_timestamp) as rn1 from flow.core.fact_transactions ) left join f on rn = rn1+1 and p = payer ) where rn1 = 1)), eth_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'ethereum' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT from_address , block_timestamp , row_number() over (partition by from_address order by block_timestamp) as rn1 from ethereum.core.fact_transactions ) left join e on rn = rn1+1 and p = from_address ) where rn1 = 1)), sol_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'solana' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT signers[0] as s , block_timestamp , row_number() over (partition by s order by block_timestamp) as rn1 from solana.core.fact_transactions ) left join s on rn = rn1+1 and p = s ) where rn1 = 1)), avax_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'avalanche' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT from_address , block_timestamp , row_number() over (partition by from_address order by block_timestamp) as rn1 from avalanche.core.fact_transactions ) left join av on rn = rn1+1 and p = from_address ) where rn1 = 1)), bsc_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'bsc' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT from_address , block_timestamp , row_number() over (partition by from_address order by block_timestamp) as rn1 from bsc.core.fact_transactions ) left join b on rn = rn1+1 and p = from_address ) where rn1 = 1)), algo_users as (SELECT count(*) as total, sum(in_a_week) as total_in_a_week , sum(in_a_month) as total_in_a_month, total_in_a_week/total*100 as percent_in_a_week, total_in_a_month/total*100 as percent_in_a_month, 'algorand' as chain from (SELECT *, case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 7 then 1 else 0 end as in_a_week , case when TIMESTAMPDIFF(SQL_TSI_DAY, block_timestamp, bt) < 30 then 1 else 0 end as in_a_month from (SELECT * from (SELECT sender , block_timestamp , row_number() over (partition by sender order by block_timestamp) as rn1 from algorand.transactions ) left join al on rn = rn1+1 and p = sender ) where rn1 = 1)) SELECT * from bsc_users UNION ALL SELECT * FROM eth_users UNION ALL SELECT * FROM flow_users UNION ALL SELECT * FROM avax_users limit 100

Query	Creator	Created
Block Performance Chains Average Time taken in July flow bsc arbitrum osmosis ethereum	nits	Aug 11, 2022
Copy of Block Performance Chains flow bsc arbitrum osmosis ethereum	nits	Aug 11, 2022
TOP dex's on bsc bsc evm binance	nits	Jul 4, 2022
Untitled Query flow bsc ethereum avalanche solana	nits	Jul 18, 2022

nits