shreexPayment Info About Terra: Terradash p3
Updated 2023-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
case
when message_value:msg:propose:msgs[0]:bank:send:to_address='S3B14- Terra: Terradash p3' then message_value
else message_value:msg:propose:msgs[0]:bank:send:to_address end as hunter,
tx_id,
-- message_value:msg:propose:msgs[0]:bank:send:to_address as hunter,
message_value:msg:propose:msgs[0]:bank:send:amount[0]:amount as payment_amount,
message_value:msg:propose:title as bounty_name,
block_timestamp::date as date
from terra.core.ez_messages where
message_value:contract='terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr' -- Metrics DAO Wallet
AND message_value:sender='terra1sf6cj4gd6khtne5767ulfj95hpmrxh75ale05j' -- dispenser
HAVING bounty_name = 'S3B14- Terra: Terradash p3'
order by block_timestamp DESC
Run a query to Download Data