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
Arbitrum vs Optimism Transaction Volume arbitrum optimism polygon l2 evm	jxboi	Aug 28, 2022
Hourly EURS Supplied vs Borrowed on AAVE v3 (Polygon) between 10th - 18th July polygon evm	jxboi	Jul 29, 2022

jxboi