princefarzamStaked Luna per month
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- AVG staked Luna per month
SELECT
date_trunc('MONTH', date) AS month,
MAX(DAY(date)) AS days_per_month,
SUM(balance)/days_per_month AS avg_staked_luna_per_month
FROM terra.daily_balances
WHERE currency = 'LUNA'
AND balance_type = 'staked'
AND balance > '0'
AND address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
AND date BETWEEN '2021-08-01' AND CURRENT_DATE
GROUP BY month
Run a query to Download Data