0xaimanLargest LP Providers On Mir
    Updated 2021-11-20


    /*

    select msg_value:execute_msg:auto_stake:assets[0]:info:token:contract_addr::string as token_address ,msg_value:sender::string as provider_address,
    sum(msg_value:execute_msg:auto_stake:assets[0]:amount::string) as UST_provided, sum(msg_value:execute_msg:auto_stake:assets[1]:amount::string) as asset_provided
    from terra.msgs
    where --tx_id='DECCF7A354B0C515C92A795AF3DDDD7E4F26D23013F69BA6BA9B6B727A65CE6D' and
    msg_value:contract='terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5'
    and msg_value:execute_msg:auto_stake:assets[0]:amount::string is not null
    group by 1,2 order by 3 desc

    limit 5

    */

    select *
    from terra.msgs
    where tx_id='A8D8F408777FBB2CC5D59CFACF1AE8ED3D901E22725DACD7A8131950F7B328AE'
    limit 100


    Run a query to Download Data