JonasoOLAS staking (1)
    Updated 2024-10-21
    with

    A as(
    select date_trunc('week',block_timestamp) as time,
    sum(case when event_name = 'Deposit' then amount else 0 - amount end) as amount,
    sum(case when event_name = 'Deposit' then amount_usd else 0 - amount_usd end) as value
    from crosschain.olas.ez_olas_staking
    group by 1)

    select time,
    amount as "OLAS (Δ)",
    value as "OLAS (Δ) $",
    sum(amount) over(order by time) as "OLAS (Σ)",
    sum(value) over(order by time) as "OLAS (Σ) $"
    from A
    order by 1 desc
    QueryRunArchived: QueryRun has been archived