maybeyonasmars_daily_users
    Updated 2022-04-02
    with
    deposits as (
    select
    'deposit' as event,
    block_timestamp,
    tx_id,
    msg_value:sender::string as user,
    msg_value:coins[0]:denom::string as denom,
    msg_value:coins[0]:amount/pow(10,6) as amt
    from terra.msgs
    where msg_value:contract::string = 'terra19dtgj9j5j7kyf3pmejqv8vzfpxtejaypgzkz5u'
    and msg_value:execute_msg:deposit_native is not null
    ),
    withdraws as (
    select
    'withdraw' as event,
    block_timestamp,
    tx_id,
    event_attributes:recipient::string as user,
    event_attributes:amount[0]:denom::string as denom,
    event_attributes:amount[0]:amount/pow(10,6) as amt
    from terra.msg_events
    where event_type = 'transfer'
    and tx_id in (
    select tx_id
    from terra.msgs
    where msg_value:contract::string = 'terra19dtgj9j5j7kyf3pmejqv8vzfpxtejaypgzkz5u'
    and msg_value:execute_msg:withdraw:asset is not null
    )
    ),
    borrows as (
    select
    'borrow' as event,
    block_timestamp,
    tx_id,
    msg_value:sender::string as user,
    Run a query to Download Data