date(block_timestamp) as date,

msg_value:contract::string as contract,

msg_value:sender::string as sender,

case

when sender = 'terra163z6npkjtuk7xf6jhm5ztdrwa4tgve94gxpqt3' then 'liq_1'

when sender = 'terra1dqagasltszjaw95l28uuzt4dh9ye6llcru7rsz' then 'liq_2'

when sender = 'terra1dxpyhvtq88f8j8nekdtu9706vxf59d0vndddx8' then 'liq_3'

when sender = 'terra1gkchs6p8wqaz9rutfnqc3hx0qnh2mwkra6tzfz' then 'liq_4'

when sender = 'terra14l56n89zmf4km5m3xj7tq7p9f2w7zq6v2ly0xq' then 'liq_5'

else 'nil' end as liquidators,

msg_value:execute_msg:send:amount/1e6

FROM terra.msgs

WHERE msg_value:execute_msg:send:msg:deposit_collateral IS NOT NULL

and block_timestamp between '2021-07-14' and CURRENT_DATE

and sender in ('terra163z6npkjtuk7xf6jhm5ztdrwa4tgve94gxpqt3', 'terra1dqagasltszjaw95l28uuzt4dh9ye6llcru7rsz','terra1dxpyhvtq88f8j8nekdtu9706vxf59d0vndddx8','terra1gkchs6p8wqaz9rutfnqc3hx0qnh2mwkra6tzfz','terra14l56n89zmf4km5m3xj7tq7p9f2w7zq6v2ly0xq')