SELECT

DATE_TRUNC('week', block_timestamp) AS week_start,

COUNT(DISTINCT from_address) AS weekly_active_users

FROM avalanche.core.fact_transactions

GROUP BY 1

),

Users AS (

SELECT 'Solo Leveling L1 Space' AS chain_name, '8227' AS chain_id, live.udf_api('https://metrics.avax.network/v1/active_addresses/8227?timeInterval=day') AS response

UNION ALL

SELECT 'DFK (DeFi Kingdoms)', '53935', live.udf_api('https://metrics.avax.network/v1/active_addresses/53935?timeInterval=day')

UNION ALL

SELECT 'Blitz', '1344', live.udf_api('https://metrics.avax.network/v1/active_addresses/1344?timeInterval=day')

UNION ALL

SELECT 'PLAYA3ULL GAMES', '3011', live.udf_api('https://metrics.avax.network/v1/active_addresses/3011?timeInterval=day')

UNION ALL

SELECT 'Playdapp Network', '504441', live.udf_api('https://metrics.avax.network/v1/active_addresses/504441?timeInterval=day')

UNION ALL

SELECT 'Pulsar', '357', live.udf_api('https://metrics.avax.network/v1/active_addresses/357?timeInterval=day')

UNION ALL

SELECT 'Shrapnel', '2044', live.udf_api('https://metrics.avax.network/v1/active_addresses/2044?timeInterval=day')

UNION ALL

SELECT 'Solert Games', '9899', live.udf_api('https://metrics.avax.network/v1/active_addresses/9899?timeInterval=day')

UNION ALL

SELECT 'Swimmer Network', '73772', live.udf_api('https://metrics.avax.network/v1/active_addresses/73772?timeInterval=day')

UNION ALL

SELECT 'Tiltyard', '710420', live.udf_api('https://metrics.avax.network/v1/active_addresses/710420?timeInterval=day')

UNION ALL

SELECT 'Xana', '8888', live.udf_api('https://metrics.avax.network/v1/active_addresses/8888?timeInterval=day')

UNION ALL

SELECT 'MUGEN', '29111', live.udf_api('https://metrics.avax.network/v1/active_addresses/29111?timeInterval=day')

UNION ALL

SELECT 'OMOCHI', '5041', live.udf_api('https://metrics.avax.network/v1/active_addresses/5041?timeInterval=day')

UNION ALL

SELECT 'ONIGIRI', '5040', live.udf_api('https://metrics.avax.network/v1/active_addresses/5040?timeInterval=day')