zakkisyedUntitled Query
    SELECT
    SUM(event_amount_usd) AS Total_USD,
    SUM(event_amount) AS Total_LUNA,
    DATE_TRUNC('week', block_timestamp) AS Week,
    sum(when action is 'undelegated') as outflows,
    sum(when action is not 'undelegated') as inflows,
    action
    FROM terra.staking
    WHERE validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
    --AND Action != 'undelegate'
    AND Week >= '2021-05-30'
    GROUP BY WEEK, action

    ORDER BY WEEK ASC



    Run a query to Download Data