(TX:body:messages[0]:from_address) as "user address",

count(distinct tx_id) as "transactions",

sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) as "LUNA volume",

sum(fee) as "fees",

count(distinct TX:body:messages[0]:from_address) as "unique senders",

count(distinct TX:body:messages[0]:to_address) as "unique receivers",

("LUNA volume" / "transactions") as "average amount per txn"

from terra.core.fact_transactions

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

and block_timestamp > '2022-05-27'

and tx_succeeded = true

group by "user address" order by "LUNA volume" desc

limit 20)

select

date_trunc('day',block_timestamp)as date,

(TX:body:messages[0]:from_address) as "user address",

count(distinct tx_id) as "transactions",

sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) as "LUNA volume",

sum(fee) as "fees",

count(distinct TX:body:messages[0]:from_address) as "unique senders",

count(distinct TX:body:messages[0]:to_address) as "unique receivers"

from terra.core.fact_transactions

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

and block_timestamp > '2022-05-27'

and tx_succeeded = true

and "user address" in (select "user address" from tab1)

group by date,"user address" order by date asc