wrenflowerfieldsQuery large luna contract interactions
    Updated 2022-10-24
    WITH transfers as (
    SELECT
    block_timestamp,
    tx_id,
    MESSAGE_VALUE:sender as sender,
    MESSAGE_VALUE['funds'][0]['amount'] / power(10, 6) as val,*
    FROM terra.core.fact_messages
    LEFT outer JOIN terra.core.dim_address_labels
    ON message_value:contract = address
    WHERE MESSAGE_VALUE:funds[0]['denom'] LIKE 'uluna'
    )


    SELECT *
    FROM transfers
    WHERE val>5000
    Run a query to Download Data