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

jxboi