date_trunc('h',block_timestamp) as "Date",

case when TRANSFER_TYPE = 'IBC_Transfer_Off' then 'Internal Terra Transfer' else 'IBC Bridge Transfer' end as "Transfer Type",

count(distinct tx_id) as "Transfers",

sum(amount/pow(10,6)) as "$LUNA",

count(distinct sender) as "Senders",

count (distinct receiver) as "Receivers"

from terra.core.ez_transfers

where block_timestamp between '2023-01-09' and '2023-01-10'

and Currency = 'uluna'

group by 1,2