count(distinct sender) as "Sender Addresses"

from terra.core.ez_transfers

where block_timestamp::date='2023-01-09' and currency='uluna'

group by 1

order by 2 DESC

limit 10),

tab2 as (select date_trunc('hour',block_timestamp) as hour_, receiver, count(distinct tx_id) as receiving_Count, sum(amount)/pow(10,6) as LUNA_Volume

from terra.core.ez_transfers

where block_timestamp::date='2023-01-09' and currency='uluna'

group by 1,2)

select hour_ as "Hour", tab1.receiver as "Receiver", receiving_Count as "Receiving Count"

from tab1 left join tab2 on tab1.receiver=tab2.receiver

order by 1