mariyabLUNA/LUNA (TVL astroport vs terraswap overtime)
    Updated 2022-02-06

    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