mariyabLUNA/LUNA (TVL astroport vs terraswap overtime)
Updated 2022-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with daily_balance_astro_bluna_luna as (
select date_trunc('day',terra.daily_balances.date) as date ,sum(balance_usd) as amount
from terra.daily_balances
where address = 'terra1j66jatn3k50hjtg2xemnjm8s7y8dws9xqa5y8w'
and terra.daily_balances.date >='2021-12-27'
GROUP by 1
),
daily_balance_terraswap_bluna_luna as (
select date_trunc('day',terra.daily_balances.date) as date ,sum(balance_usd) as amount
from terra.daily_balances
where address = 'terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p'
and terra.daily_balances.date >='2021-12-27'
GROUP by 1
)
select daily_balance_terraswap_bluna_luna.date as daily ,daily_balance_terraswap_bluna_luna.amount as terraswap_bluna_luna_tvl ,daily_balance_astro_bluna_luna.amount
as astroport_bluna_luna_tvl
from daily_balance_astro_bluna_luna INNER join daily_balance_terraswap_bluna_luna
on daily_balance_astro_bluna_luna.date = daily_balance_terraswap_bluna_luna.DATE
GROUP by 1,2,3