WITH weekly_metrics AS (

SELECT

date_trunc('week', BLOCK_TIMESTAMP_HOUR) as Week,

CASE

WHEN BLOCKCHAIN IN (

'bsc',

'cosmos',

'terra',

'osmosis',

'axelar',

'solana',

'ethereum',

'bitcoin',

'near',

'avalanche',

'sei',

'aptos',

'fantom',

'mina',

'ton',

'atom'

) THEN 'L1'

WHEN BLOCKCHAIN IN (

'polygon',

'blast',

'mode',

'base',

'optimism',

'arbitrum',

'gnosis',

'aurora',

'flow',

'zksync era',

'mantle',

'starknet',