with final_data as (
select
to_date(block_timestamp) as date,
count(*) as total_count, sum(AMOUNT/1e6) as volume, 'Before Week Situation'
from terra.core.ez_transfers
where CURRENCY='uluna' and year(block_timestamp)=2023 and
date >='2023-01-07' and
date <='2023-01-13'
group by date
UNION
select
to_date(block_timestamp) as date,
count(*) as total_count, sum(AMOUNT/1e6) as volume, 'after Week Situation'
from terra.core.ez_transfers
where CURRENCY='uluna' and year(block_timestamp)=2023 and
date >='2023-01-15' and
date <='2023-01-21'
group by date
)
select * from final_data