(SELECT block_timestamp, tx_id,message_type, message_index, receiver as address, (amount::real/1e6) AS amount

FROM terra.core.ez_transfers

WHERE currency = 'uluna'

AND tx_succeeded = TRUE

),

-- AND message_type = '/cosmos.bank.v1beta1.MsgSend'),

send_data AS

(SELECT block_timestamp, tx_id,message_type, message_index,sender as address, -1*(amount::real/1e6) AS amount

FROM terra.core.ez_transfers

WHERE currency = 'uluna'

AND tx_succeeded = TRUE

),

-- AND message_type = '/cosmos.bank.v1beta1.MsgSend'),

joined_data AS

(SELECT *

FROM receive_data

UNION ALL

SELECT *

FROM send_data),

top10 AS

(SELECT address AS "Wallets", SUM(amount) AS "Total Balance in Luna"

FROM joined_data

GROUP BY "Wallets"

ORDER BY "Total Balance in Luna" DESC

LIMIT 100),

merged_table AS

(SELECT top.*, dims.label, dims.project_name