Nige7777Voting on Oracle Prices
Updated 2021-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
blockchain,
chain_id,
tx_status,
block_id,
block_timestamp,
tx_id,
msg_type,
REGEXP_REPLACE(msg_value:denom,'\"','') as currency,
REGEXP_REPLACE(msg_value:exchange_rate,'\"','') as rate,
REGEXP_REPLACE(msg_value:feeder,'\"','') as feeder,
REGEXP_REPLACE(msg_value:salt,'\"','') as salt,
REGEXP_REPLACE(msg_value:validator,'\"','') as validator
FROM flipside_prod_db.silver.terra_msgs
WHERE msg_module = 'oracle'
AND msg_type = 'oracle/MsgExchangeRateVote'
AND tx_id = 'A66E89A8A924979A57B5B7158F6E7380EC36CC6B0C3F78E7F52C1D27FA2834F4'
Run a query to Download Data