select

date(block_timestamp) as date,

count(tx_hash) as transactions,

count(distinct from_address) as addresses

from

bsc.core.fact_transactions

where date >= current_date - interval '{{Days}} days'

group by 1

),

contracts as (

select

distinct el.contract_address as contract,

case

when dl.project_name is not null then dl.project_name

when el.contract_address is null then 'transfer'

when el.contract_address in ('0x52e75d318cfb31f9a2edfa2dfee26b161255b233','0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed','0x2297aebd383787a160dd0d9f71508148769342e3') then 'layer zero' --original token bridge, LZ bridge agEUR, btc.b (LZ)

--0xe9ad444cf80e1d6ba062a2dd6f53b740b5f0aa14 polyhedra

end as dapp,

dl.address_name as contract_name

from

bsc.core.fact_decoded_event_logs el

left join

bsc.core.dim_labels dl

on el.contract_address = dl.address

OR (el.contract_address IS NULL AND dl.address IS NULL)

where date(el.block_timestamp) >= current_date - interval '{{Days}} days'

),

lz_totals as (

select

date(ft.block_timestamp) as date,

count(distinct ft.tx_hash) as transactions,

count(distinct ft.from_address) as addresses

from

bsc.core.fact_transactions ft

left join