SELECT

block_timestamp,

tx_hash

FROM

polygon.core.fact_transactions

WHERE

LOWER(from_address) = LOWER('0x8a1E7a12663B18B7f4257936824c89fdFCcDA82e')

ORDER BY

block_timestamp DESC

),

to_addresses AS (

SELECT

tx_hash,

to_address

FROM

polygon.core.fact_token_transfers

WHERE

tx_hash IN (

SELECT tx_hash

FROM initial_transactions

)

AND to_address IS NOT NULL

SELECT

it.block_timestamp,

it.tx_hash,

ta.to_address

FROM

initial_transactions AS it

LEFT JOIN

to_addresses AS ta

ON

it.tx_hash = ta.tx_hash

ORDER BY

it.block_timestamp DESC;