John_GaltTotal SOLID
    Updated 2023-04-13
    select
    block_timestamp as date,
    message_value:msg:borrow_stable:borrow_amount / pow(10, 6) as borrow,
    message_value:sender as sender
    from terra.core.ez_messages
    where date(block_timestamp) > '2023-03-01'
    and message_value:contract = 'terra1h4cknjl5k0aysdhv0h4eqcaka620g8h69k8h0pjjccxvf9esfhws3cyqnc'
    and SPLIT_PART(message_value:msg, '"', 2) = 'borrow_stable'




    Run a query to Download Data