nitsUntitled Query
Updated 2022-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
with transactions_on_wormhole as (select *,SUBSTRING(msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom,0,LEN(msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom)) as denominations ,
(msg_value:execute_msg:initiate_transfer:asset:amount)/pow(10,6) as amount ,
msg_value:sender as sender_address ,
msg_value:execute_msg:initiate_transfer:recipient_chain as chain_number ,
msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr as contract_address,
len(denominations) as length_
from terra.msgs
where msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf' and amount> '0' and tx_status = 'SUCCEEDED'),
prices as (select date(block_timestamp) as day,currency, avg(price_usd) as avg_price from terra.oracle_prices
group by day, currency ),
received_from_eth as (
select block_timestamp as deposit_time,
msg_value:to_address as sender
from terra.msgs
where msg_value:from_address::string = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc'
and tx_status = 'SUCCEEDED'
group by 1, 2
),
received_from_bsc as (
select block_timestamp as deposit_time,
msg_value:to_address as sender
from terra.msgs m
where msg_value:from_address::string = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc'
and tx_status = 'SUCCEEDED'
group by 1, 2
)
SELECT * from(
SELECT tx_id as transaction_id , block_timestamp as time_ from transactions_on_wormhole
)
inner join
limit 100
Run a query to Download Data