select tx_id, msg_value, block_timestamp AS DATE

from terra.msgs

where msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and msg_value:execute_msg:initiate_transfer is not null

and TX_STATUS = 'SUCCEEDED'

AND DATE > '2020-01-01'

),

wh_source2 AS(

SELECT date_trunc('day',block_timestamp) AS DATE, COUNT(tx_id), fee, block_timestamp

FROM terra.transactions

WHERE block_timestamp > '2020-01-01'

GROUP BY DATE

SELECT wh_source1.tx_id,'Wormhole' AS bridge_label, wh_source2.fee[0]:amount[0]:amount/1000000 AS Fee_Pay,

wh_source2.fee[0]:amount[0]:denom AS Fee_Token, block_timestamp

FROM wh_source1

LEFT JOIN wh_source2 ON wh_source1.tx_id = wh_source2.tx_id

WHERE wh_source2.fee[0]:amount[1]:amount IS NULL

AND block_timestamp > '2020-01-01'

LIMIT 999