block_id,

block_timestamp,

tx_hash,

null as action_id,

tx_signer as from_address,

tx_receiver as to_address,

-transaction_fee :: DOUBLE as amount_signed_yocto,

(-transaction_fee / pow(10, 24)) :: DOUBLE as amount_signed_near

from near.core.fact_transactions

where tx_signer = 'kitty.near'

order by 1