count(DISTINCT tx_id)AS transactions,

count(DISTINCT TX:body:messages[0]:from_address) AS senders,

count(DISTINCT TX:body:messages[0]:to_address) AS receivers,

sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) AS LUNA_volume,

sum(fee) AS fees

from terra.core.fact_transactions

where tx:body:messages[0]:amount[0]:denom = 'uluna'

and block_timestamp::date > '2022-05-15'

and tx_succeeded ilike 'true'