german(Terra->Solana Wormhole) UST Bridged Out
Updated 2022-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
/*Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow.
How many users are using the bridge on a daily basis?
How many transactions take place on a daily basis? */
SELECT
trunc(block_timestamp, 'day') as date,
count(distinct msg_value:sender) as num_users,
count(tx_id) as n_txs,
sum(round(msg_value:execute_msg:initiate_transfer:asset:amount / 1e6,2)) as amount_UST_bridged_out,
sum(amount_UST_bridged_out) OVER (ORDER BY date) as cumulative_UST_bridged
FROM terra.msgs
WHERE msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
AND msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string = 'uusd'
and date >= '2021-10-18'
AND msg_value:execute_msg:initiate_transfer is not null
AND msg_value:execute_msg:initiate_transfer:recipient_chain = '1' --'Solana'
GROUP BY date
ORDER BY date
Run a query to Download Data