mucryptoTop gainers/losers by 1 day change in TVL (%) 2024-01-30 12:49 AM
    Updated 2024-01-29
    with resps as
    (select defillama.get('/protocols', {}) as resp),

    positive as (
    select
    value:category as category,
    value:name as name,
    cast(value:change_1d as decimal(38,2)) as one_day_change,
    value:description::string as description
    from resps,
    lateral flatten (input => resp:data)
    where category = 'Restaking'
    and one_day_change > 0
    order by 3 desc
    limit 10),

    negative as (
    select
    value:category as category,
    value:name as name,
    cast(value:change_1d as decimal(38,2)) as one_day_change,
    value:description as description
    from resps,
    lateral flatten (input => resp:data)
    where category = 'Restaking'
    and one_day_change < 0
    order by 3
    limit 10)

    select
    name,
    concat(one_day_change, '%') as one_day_change,
    description,
    'Positive' as category
    from positive

    Last run: about 1 year ago
    NAME
    ONE_DAY_CHANGE
    DESCRIPTION
    CATEGORY
    1
    EigenLayer
    3.95%
    EigenLayer is a protocol built on Ethereum that introduces restaking, a ...
    Positive
    1
    214B
    7s