nitsOutflows from Secret
Updated 2022-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT date(block_timestamp) as date_, event_attributes:amount[0]:denom as denomination,sum(event_attributes:amount[0]:amount/pow(10,6)) as amt_
from terra.msg_events
-- where event_from = 'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2'
-- where EVENT_FROM_LABEL_SUBTYPE = 'bridge'
-- where tx_id ilike '3129A03338CA66C0659F45A6E0B7CB382D854DD57537C12F32F93F012DEBC5D7'
where event_attributes:receiver = 'terra1v0zuhlzznmz8r5csel3dtrm0pst0dmett62j6z'
and block_timestamp > CURRENT_DATE -7
-- where msg_value:receiver like '%secret%'
GROUP by 1,2
-- applications
-- applications/transfer.v1.MsgTransfer
-- {"@type":"/ibc.applications.transfer.v1.MsgTransfer","token":{"denom":"uluna","amount":"3700000"},"sender":"terra17wal98e8ptzq4fs3q0vpsl2ncah7qeh7tl4wl7","receiver":"secret16l6cnhn0n8067gv0hpvrqa3gvxuk5n7y2lhyfh","source_port":"transfer","source_channel":"channel-16","timeout_height":{"revision_height":"0","revision_number":"0"},"timeout_timestamp":"1637874277000000000"}
Run a query to Download Data