SELECT

tx_id,

value:"pubkey"::string AS address,

'native_token' AS contract_address,

post_balances[flattened_data.index]::float / pow(10, 9) AS amount,

9 AS decimals,

post_balances[flattened_data.index]::float AS amount_unadj,

flattened_data.index::string AS index,

block_timestamp,

ROW_NUMBER() OVER (

PARTITION BY value:"pubkey"::string

ORDER BY block_timestamp DESC

) AS row_num

FROM eclipse.core.fact_transactions,

LATERAL FLATTEN(input => account_keys) AS flattened_data

WHERE succeeded = 'TRUE'

AND value:"pubkey"::string IN (

'GasssK1zRZJ378zkkTuqP7J8ExwmRVuoXSnewcFaW5S3'

)

SELECT *

FROM ranked_transactions

WHERE row_num = 1

ORDER BY block_timestamp DESC;