Updated 2021-07-21
    SELECT
    tx_id,
    event_currency,
    event_amount_usd,
    CASE
    WHEN event_from_address_name LIKE 'ETH shuttle' THEN 'in'
    WHEN event_to_address_name LIKE 'ETH shuttle' THEN 'out'
    ELSE NULL
    END as direction
    FROM terra.transfers
    WHERE (event_from_address_name LIKE 'ETH shuttle'
    OR event_to_address_name LIKE 'ETH shuttle')
    AND block_timestamp >= getdate() - interval '90 days'
    AND (event_currency LIKE 'LUNA'
    OR event_currency LIKE 'UST')