, 'Selling' as "Action"

from terra.core.ez_swaps

where from_currency='uluna' and block_timestamp::date>='2023-01-01' and tx_succeeded='TRUE'

group by 1

order by 1),

tab2 as (select date_trunc('day',block_timestamp) as "Date", sum(to_amount)/pow(10,6) as "Volume", count(distinct tx_id) as "Transactions Count"

, 'Buying' as "Action"

from terra.core.ez_swaps

where to_currency='uluna' and block_timestamp::date>='2023-01-01' and tx_succeeded='TRUE'

group by 1

order by 1)

select * from tab1 union ALL

select * from tab2)

select "Date", "Volume", "Transactions Count", "Action"

from table1

order by 1