SandeshUntitled Query
    Updated 2023-02-16
    select block_timestamp,
    tx_hash as tx_id,
    parse_json(actions):"receipt":"Action":"actions"[0]:"Transfer":"deposit" as amount,
    parse_json(actions):"receipt":"Action":"signer_id" as sender,
    parse_json(actions):"receiver_id" as reciever
    from near.core.fact_receipts
    where 1=1
    -- and tx_hash='BSudcmqufUaHRZcvPqdgexGHYBM7xrfDC9JF7uHy6wAy'
    and sender = '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'
    and amount is not null
    Run a query to Download Data