freemartianMost Popular Destinations from Terra
    Updated 2022-01-12
    WITH terra_source AS (
    select tx_id, msg_value, block_timestamp AS TX_TIME
    from terra.msgs
    where msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
    and msg_value:execute_msg:initiate_transfer is not null
    and TX_STATUS = 'SUCCEEDED'
    AND block_timestamp > '2021-09-01'
    )
    SELECT msg_value:execute_msg:initiate_transfer:recipient_chain AS recipient_chain, COUNT(tx_id) AS Number_of_Transactions FROM terra_source
    WHERE recipient_chain != 3
    GROUP BY recipient_chain ORDER BY recipient_chain ASC
    Run a query to Download Data