-- forked from banbannard / THORChain Lending 3 @ https://flipsidecrypto.xyz/banbannard/q/u-s49i1SJACn/thorchain-lending-3
select
datediff('day', min(date_trunc('day', block_timestamp)), current_date) + 1 as "TC_lending"
FROM thorchain.core.fact_loan_open_events