PapasotClaimed bids Terra
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with claimed_bids as (
select
f.value as claimed_id
from terra.msgs
left join table(flatten(input => msg_value:execute_msg:claim_liquidations:bids_idx)) f
where block_timestamp >= '2021-11-11'
and msg_value:contract = 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u'
and msg_value:execute_msg:claim_liquidations is not null
and tx_status = 'SUCCEEDED')
Run a query to Download Data