John_Galtosmo to binance
Updated 2023-08-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
block_timestamp,
msg:from_address as address,
hi.value:amount::number / pow(10, 6) as osmo,
tx_id
from osmosis.core.fact_tx_body_msgs,
lateral flatten ( input => msg:amount ) hi
where block_timestamp > '2022-10-01'
and msg_type = '/cosmos.bank.v1beta1.MsgSend'
and msg:to_address = 'osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575'
and hi.value:denom::string = 'uosmo'
and osmo > 200000
order by osmo desc
limit 1000
--osmo1p3ucd3ptpw902fluyjzhq3ffgq4ntddas7rd8z - staking address
--osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu - withdrawal address
--osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575 - deposit address