from external.defillama.fact_chain_tvl

where chain='CORE' and date between '{{Start_Date}}' and '{{End_Date}}'),

tab2 as (select block_timestamp::date as date, count(distinct tx_hash) as tx_count

from core.core.fact_transactions

where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

group by 1)

select tab1.date as "Date", tvl_usd as "TVL", tx_count AS "Txns Count"

from tab1 left join tab2 on tab1.date = tab2.date

where tab1.date>='2024-05-01'

order by 1