zakkisyedBlast TVL Change
    Updated 2024-03-01
    with blast_tvl as (
    SELECT
    LiveQuery.live.udf_Api('https://api.llama.fi/v2/historicalChainTvl/Blast') :data as repsonse
    )

    SELECT
    to_timestamp(value:date) AS block_timestamp,
    value:totalLiquidityUSD as TVL
    FROM
    blast_tvl,
    LATERAL FLATTEN (input => repsonse:tvl)
    ORDER by 1 desc
    limit 60
    QueryRunArchived: QueryRun has been archived