theericstoneAnchor Withdrawals copy
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('hour',block_timestamp) as block_hour,
sum(msg_value:execute_msg:withdraw_collateral:amount) / pow(10,6) as amount,
'beth_collateral_anchor' as from_group,
'beth_holders_terra' as to_group
from terra.msgs where block_timestamp > '2021-08-12'
and msg_value:contract = 'terra10cxuzggyvvv44magvrh3thpdnk9cmlgk93gmx2' -- anchor beth vault
and msg_value:execute_msg:withdraw_collateral:amount IS NOT NULL
group by 1;
Run a query to Download Data