select distinct block_timestamp,

tx_id,

CASE WHEN event_attributes:ask_asset::string = 'uusd' THEN

event_attributes:return_amount::float / 1e6

WHEN event_attributes:offer_asset::string = 'uusd' THEN

event_attributes:offer_amount::float / 1e6 ELSE 0 END as UST_traded,

CASE WHEN event_attributes:ask_asset::string = 'uluna' THEN

event_attributes:return_amount::float / 1e6

WHEN event_attributes:offer_asset::string = 'uluna' THEN

event_attributes:offer_amount::float / 1e6 ELSE 0 END as LUNA_traded

from terra.msg_events

where event_attributes:contract_address::string = 'terra1m6ywlgn6wrjuagcmmezzz2a029gtldhey5k552'

and event_type = 'from_contract'

and tx_status = 'SUCCEEDED'

and block_timestamp > getdate() - interval'180 days'

,

advanced as (

select distinct block_timestamp,

tx_id,

CASE WHEN event_attributes:"0_ask_asset"::string = 'uusd' THEN

event_attributes:"0_return_amount"::float / 1e6

WHEN event_attributes:"1_ask_asset"::string = 'uusd' THEN

event_attributes:"1_return_amount"::float / 1e6

WHEN event_attributes:"2_ask_asset"::string = 'uusd' THEN

event_attributes:"2_return_amount"::float / 1e6

WHEN event_attributes:"3_ask_asset"::string = 'uusd' THEN

event_attributes:"3_return_amount"::float / 1e6

WHEN event_attributes:"0_offer_asset"::string = 'uusd' THEN

event_attributes:"0_offer_amount"::float / 1e6

WHEN event_attributes:"1_offer_asset"::string = 'uusd' THEN

event_attributes:"1_offer_amount"::float / 1e6

WHEN event_attributes:"2_offer_asset"::string = 'uusd' THEN