JonasoOLAS staking (1)
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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