(

SELECT

origin_from_address as bridgers,

min(BLOCK_TIMESTAMP) as first_day

from arbitrum.core.fact_token_transfers a

join arbitrum.core.dim_contracts b on b.address like a.contract_address

where to_address = '0x1619de6b6b20ed217a58d00f37b9d47c7663feca'

AND not tx_hash in (select tx_hash from arbitrum.core.ez_eth_transfers

where eth_to_address = '0x1619de6b6b20ed217a58d00f37b9d47c7663feca')

group by 1

union

select

origin_from_address as bridgers,

min(BLOCK_TIMESTAMP) as first_day

from arbitrum.core.ez_eth_transfers

where eth_to_address = '0x1619de6b6b20ed217a58d00f37b9d47c7663feca'

group by 1)

select

date_trunc('day',first_day::date) as daily,

count(distinct bridgers) as bridgers_count_per_day,

sum(bridgers_count_per_day) over (order by daily) as cumulative_new_bridgers

from tab1

where first_day >= CURRENT_DATE - {{period}}

group by 1

order by 1