flipside

    THORChain Lending 3 copy copy copy
    winnie-fsTHORChain Lending 3 copy copy copy
    Updated 2023-10-19
    -- forked from THORChain Lending 3 copy copy @ https://staging.flipsidecrypto.xyz/edit/queries/500079fc-1f8a-455b-a355-c22116968135

    -- forked from THORChain Lending 3 copy @ https://staging.flipsidecrypto.xyz/edit/queries/3afba626-fe53-4c0c-a857-07edc681978b

    -- 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