PlaywoUntitled Query
Updated 2022-11-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
WITH timeframe AS (
SELECT date_hour AS hour
FROM crosschain.core.dim_date_hours
WHERE hour >= TO_DATE('{{start_date}}') AND hour <= TO_DATE('{{end_date}}') AND hour < CURRENT_TIMESTAMP
)
SELECT hour,
COALESCE(
(SELECT sum(CASE WHEN action = 'withdraw' THEN -amount ELSE amount END) FROM solana.core.fact_stake_pool_actions WHERE block_timestamp <= hour AND block_timestamp >= TO_DATE('{{start_date}}'))
, 0) AS net_change
FROM timeframe
Run a query to Download Data