c2ctraderLUNA Market Cap - last year
    Updated 2022-07-07
    --Evaluate average daily price of LUNA in USD
    WITH luna_price as (
    SELECT date_trunc('day',block_timestamp) day, avg(price_usd) luna_price_usd from terra.oracle_prices
    WHERE (symbol = 'LUNA' and day >= DATEADD(day, -365, getdate()))
    GROUP BY DAY
    ORDER BY DAY
    ),

    --Evaluate of daily LUNA market cap in LUNA and USD
    market_cap as (
    SELECT date_trunc('day',DATE) day, sum(balance_usd) market_cap_usd from terra.daily_balances
    WHERE (currency = 'LUNA' and day >= DATEADD(day, -365, getdate()))
    GROUP BY DAY
    ORDER BY DAY
    )

    --Join tables
    SELECT luna_price.day, luna_price.luna_price_usd, market_cap.market_cap_usd
    FROM luna_price
    JOIN market_cap on luna_price.day = market_cap.day

    Run a query to Download Data