maybeyonasstader_daily_hodl
    Updated 2021-12-17
    with
    buy as (
    select
    block_timestamp,
    tx_id,
    event_attributes:to::string as user,
    event_attributes:return_amount/pow(10,6) as amt
    from terra.msg_events
    where tx_status='SUCCEEDED'
    and event_type = 'from_contract'
    and event_attributes:ask_asset = 'terra17y9qkl8dfkeg4py7n0g5407emqnemc3yqk5rup'
    ),
    sell as (
    select
    block_timestamp,
    tx_id,
    event_attributes:from::string as user,
    - (event_attributes:offer_amount/pow(10,6)) as amt
    from terra.msg_events
    where tx_status='SUCCEEDED'
    and event_type = 'from_contract'
    and event_attributes:offer_asset = 'terra17y9qkl8dfkeg4py7n0g5407emqnemc3yqk5rup'
    ),
    unstake as (
    select
    block_timestamp,
    tx_id,
    msg_value:sender::string as user,
    - (msg_value:execute_msg:send:amount::string/pow(10,6)) as amt
    from terra.msgs
    where tx_status = 'SUCCEEDED'
    and msg_value:contract = 'terra17y9qkl8dfkeg4py7n0g5407emqnemc3yqk5rup'
    and msg_value:execute_msg:send:contract = 'terra1xacqx447msqp46qmv8k2sq6v5jh9fdj37az898'
    ),
    stake as (
    select
    Run a query to Download Data