binhachon101. [Elite] Crypto-Cosmology, Part 1: Wormhole - Adoption rate
    Updated 2021-12-16
    with shuttle_bridge_contract as(
    (
    select
    'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2' as contract_address,
    'Account | Terra Bridge BSC' as contract_name
    )
    union
    (
    select
    'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' as contract_address,
    'Account | Terra Bridge ETH' as contract_name
    )
    ),
    shuttle_bridge_activity_list as(
    (
    select
    block_timestamp,
    tx_id,
    msg_value : execute_msg : transfer : recipient :: string as address
    from
    terra.msgs
    where
    msg_value : sender :: string in (
    select
    contract_address
    from
    shuttle_bridge_contract
    )
    )
    union all
    (
    select
    block_timestamp,
    tx_id,
    msg_value : sender :: string as address
    from
    Run a query to Download Data