shreyash-5873Anchor Redemptions: Block >= 4000000
    Updated 2022-07-07
    select
    m.block_id,
    m.tx_id,
    m.event_attributes:"0_from"::string as redeemer,
    m.event_attributes:redeem_amount as uust_redeemend,
    m.event_attributes:redeem_amount / pow(10, 6) as ust_redeemed,
    m.event_attributes:burn_amount as uaust_burnt,
    m.event_attributes:burn_amount / pow(10, 6) as aust_burnt
    from terra.msg_events m
    where m.event_attributes:redeem_amount is not null
    and m.event_attributes:burn_amount is not null
    and m.event_attributes:"1_contract_address"::string = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
    and m.tx_status = 'SUCCEEDED'
    and m.block_id >= 4000000
    order by 1;

    Run a query to Download Data