nitsUntitled Query
    Updated 2022-01-11
    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