IncrementLiquid Staking 3 - Time series data
Updated 2024-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH Stake_flow AS (
SELECT
DATE_TRUNC('WEEK', block_timestamp :: date) as TIME,
SUM(EVENT_DATA:flowAmountIn) AS Staked
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.d6f80565193ad727.LiquidStaking'
AND EVENT_TYPE = 'Stake'
GROUP BY
TIME
),
Migrated_flow AS (
SELECT
DATE_TRUNC('WEEK', block_timestamp :: date) as TIME,
SUM(EVENT_DATA:migratedFlowIn) AS Migrated
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.d6f80565193ad727.LiquidStaking'
AND EVENT_TYPE = 'MigrateDelegator'
GROUP BY
TIME
),
Unstake_flow AS (
SELECT
DATE_TRUNC('WEEK', block_timestamp :: date) as TIME,
SUM(EVENT_DATA:lockedFlowAmount) * -1 AS Unstaked
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.d6f80565193ad727.LiquidStaking'
AND EVENT_TYPE = 'Unstake'
GROUP BY
TIME
)
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived