with bsc as ( select block_timestamp::date as date, count(distinct from_address) as addr from bsc.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), arb as ( select block_timestamp::date as date, count(distinct from_address) as addr from arbitrum.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), eth as ( select block_timestamp::date as date, count(distinct from_address) as addr from ethereum.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), pol as ( select block_timestamp::date as date, count(distinct from_address) as addr from polygon.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), opt as ( select block_timestamp::date as date, count(distinct from_address) as addr from optimism.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), ava as ( select block_timestamp::date as date, count(distinct from_address) as addr from avalanche.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), sol as ( select block_timestamp::date as date, count(distinct signers[0]) as addr from solana.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), near as ( select block_timestamp::date as date, count(distinct TX_SIGNER) as addr from near.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), flow as ( select block_timestamp::date as date, count(distinct PROPOSER) as addr from flow.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), osm as ( select block_timestamp::date as date, count(distinct tx_from) as addr from osmosis.core.fact_transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ), algo as ( select block_timestamp::date as date, count(distinct sender) as addr from flipside_prod_db.algorand.transactions where block_timestamp::date >= CURRENT_DATE - {{past_days}} and block_timestamp::date < CURRENT_DATE group by 1 ) select *, 'bsc' as type from bsc UNION select *, 'arbitrum' as type from arb UNION select *, 'ethereum' as type from eth UNION select *, 'optimism' as type from opt UNION select *, 'polygon' as type from pol UNION select *, 'avalanche' as type from ava UNION select *, 'solana' as type from sol UNION select *, 'near' as type from near UNION select *, 'flow' as type from flow UNION select *, 'osmosis' as type from osm UNION select *, 'algorand' as type from algo

Query	Creator	Created
All Chains: Active Users flow near bsc arbitrum osmosis	jxboi	Sep 12, 2022
My Osmosis Scavenger Hunt osmosis ibc	jxboi	Jul 7, 2022
Daily Stake copy terra osmosis prices staking ibc	jxboi	Jul 5, 2023

jxboi