KARTODUST Transaction by pair
    Updated 2021-10-05
    select
    date(block_timestamp),
    l.address_name,
    count(tx_id)
    from terra.msgs m
    inner join terra.labels l
    on m.msg_value:contract = l.address
    where l.address_name like '%UST Pair'
    --and msg_value:execute_msg:open_position:collateral:info:native_token:denom::string = 'uusd'
    group by 1, 2
    order by 1 desc
    Run a query to Download Data