forgashbonded luna out of total [T46]
Updated 2021-08-18
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
›
⌄
WITH gross AS (
SELECT
date,
sum(balance) as luna_balance
FROM terra.daily_balances
WHERE currency = 'LUNA'
AND date > '2021-03-16T00:00:00Z'
GROUP BY 1
ORDER BY 1),
bluna AS (
SELECT
date,
balance as bluna_balance
FROM terra.daily_balances
WHERE address = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'
AND currency = 'LUNA'
AND date > '2021-03-16T00:00:00Z'
ORDER BY 1
)
SELECT
gross.date,
luna_balance,
bluna_balance,
luna_balance - bluna_balance as total_less_bluna
FROM gross
JOIN bluna ON bluna.date = gross.date
Run a query to Download Data