select

block_id, block_timestamp, tx_id,

amount, sender, receiver,

case when sender = 'terra1885dgdvn5u8sjfaefvr39arssaxgqmd29ht0aa' then 'OUTFLOW' else 'INFLOW' end "type",

amount/pow(10,6) normalized_amount

from terra.core.ez_transfers

where

(sender = 'terra1885dgdvn5u8sjfaefvr39arssaxgqmd29ht0aa'

or receiver = 'terra1885dgdvn5u8sjfaefvr39arssaxgqmd29ht0aa')

and currency = 'uluna'

and block_id > 10881082

and tx_succeeded = true)

select * from raw_data