with daily_transactions AS (

SELECT

DATE_TRUNC('d', BLOCK_TIMESTAMP) AS day,

MULTISIG_ADDRESS AS service_multisig_address,

'ethereum' AS chain

FROM

crosschain.olas.fact_service_events

where

BLOCKCHAIN = 'ethereum'

UNION

ALL

SELECT

DATE_TRUNC('d', BLOCK_TIMESTAMP) AS day,

MULTISIG_ADDRESS AS service_multisig_address,

'polygon' AS chain

FROM

crosschain.olas.fact_service_events

where

BLOCKCHAIN = 'polygon'

UNION

ALL

SELECT

DATE_TRUNC('d', BLOCK_TIMESTAMP) AS day,

MULTISIG_ADDRESS AS service_multisig_address,

'gnosis' AS chain

FROM

crosschain.olas.fact_service_events

where

BLOCKCHAIN = 'gnosis'

UNION

ALL

SELECT

DATE_TRUNC('d', BLOCK_TIMESTAMP) AS day,

MULTISIG_ADDRESS AS service_multisig_address,