Kruys-Collinsvicious-pink
Updated 2024-09-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH CurrentPrice AS (
SELECT
price
FROM crosschain.price.ez_prices_hourly
WHERE symbol = 'AXL'
ORDER BY hour DESC
LIMIT 1
)
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
SUM(amount / 1e6) AS total_rewards,
SUM(amount * cp.price / 1e6) AS total_rewards_usd
FROM
axelar.gov.fact_staking_rewards
JOIN
CurrentPrice cp ON 1=1
WHERE
tx_succeeded = TRUE
GROUP BY
DATE_TRUNC('week', block_timestamp), cp.price
ORDER BY
week;
QueryRunArchived: QueryRun has been archived