with amounts as

(SELECT

(event_attributes:"0_amount"[0]:amount::float + event_attributes:"1_amount"[0]:amount::float + event_attributes:"2_amount"[0]:amount::float) / 1e6 as "LUNA Traded"

FROM terra.msg_events

WHERE tx_status = 'SUCCEEDED'

AND tx_id IN (

SELECT tx_id FROM terra.msg_events

WHERE event_type = 'execute_contract'

AND event_attributes:"0_contract_address" = 'terra12v8vrgntasf37xpj282szqpdyad7dgmkgnq60j'

AND event_attributes:"1_contract_address" = 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2'

and block_timestamp < '2021-10-16T03:52:00Z'

)

AND event_type = 'transfer')

select SUM("LUNA Traded") from amounts