block_timestamp,

tx_hash,

concat('0x',SUBSTR(payload:arguments[2], -80, 64)) AS wallet,

livequery.utils.udf_hex_to_int(RIGHT(payload:arguments[2],16))/pow(10,decimals) AS amount,

(livequery.utils.udf_hex_to_int(RIGHT(payload:arguments[2],16))/pow(10,decimals)) * price AS amount_usd,

split(payload:type_arguments[0],'::')[2] AS asset

FROM aptos.core.fact_transactions

LIMIT 10