SELECT

block_id,

block_timestamp as time_

FROM

algorand.block

),

cex_info AS (

SELECT

block_timestamp,

ROUND(SUM(amount)) as total,

block_id,

sender,

receiver

FROM

algorand.payment_transaction

WHERE

block_timestamp :: date >= '2021-11-10'

and block_timestamp :: date < '2022-01-01'

),

cex_label AS (

SELECT

label AS cex,

address

FROM

algorand.labels

WHERE

label_type = 'cex' AND label_subtype = 'hot_wallet'

)

SELECT

cex_label.cex,

cex_label.address,