tx_id,

value:"pubkey"::string as address,

'native_token' as contract_address,

post_balances[index]::float / pow(10, 9) as amount,

9 as decimals,

post_balances[index]::float as amount_unadj,

index::string as index,

block_timestamp

FROM solana.core.fact_transactions,

LATERAL FLATTEN(input => account_keys)

AND to_date(block_timestamp) < to_date(current_timestamp)

AND post_balances[index] <> pre_balances[index]

AND value:"pubkey"::string IN (

'CrfbABN2sSvmoZLu9eDDfXpaC2nHg42R7AXbHs9eg4S9'

AND block_timestamp >= DATEADD('day', -1, CURRENT_TIMESTAMP)

ORDER BY block_timestamp DESC;