Eman-RazTVL Change (30D)
    Updated 2024-11-22
    with tab1 as (select tvl_usd as tvl2
    from external.defillama.fact_chain_tvl
    where chain='CORE'
    and date = current_date - 1),

    tab2 as (select tvl_usd as tvl1
    from external.defillama.fact_chain_tvl
    where chain='CORE'
    and date = current_date - 31)

    select ((tvl2-tvl1)/tvl1)*100 as tvl_change
    from tab1 , tab2

    QueryRunArchived: QueryRun has been archived