flipside

    Untitled Query
    boomer77Untitled Query
    Updated 2022-03-13
    with raw as (select date(block_timestamp) as dt, msg_value:sender::string as sender, msg_value:receiver::string as receiver,
    msg_value:source_channel::string as channel,
    msg_value:token:denom::string as denom, msg_value:token:amount/1e6 as amount, msg_module, msg_type, tx_type
    from terra.msgs
    where msg_type = 'applications/transfer.v1.MsgTransfer' and tx_status = 'SUCCEEDED')

    select *
    from raw
    where channel = 'channel-19'
    Run a query to Download Data