SELECT

t.transaction_hash,

t.closed_at,

LOWER(o.from_account) AS source_account,

LOWER(o.to_account) AS destination_account,

o.asset_code,

o.amount

FROM stellar.core.fact_operations o

JOIN stellar.core.fact_transactions t

ON o.transaction_id = t.id

WHERE

t.closed_at >= DATEADD('day', -30, CURRENT_TIMESTAMP())

AND (

LOWER(o.from_account) IN (

LOWER('GAY4G3PY3TPOVOSHDD2PZ4PIKA533VBBKEEJ5ASTOMPZOHAVKEWZ3ADS'), -- Withdrawals

LOWER('GAV6J5L473K4H6226IFNCAL7E5A2PR63YRCZDYJPTQH3S35YODXUUADV'),

LOWER('GA3CINHTGMUMRVPJPVHYJWQJ2EF7EX2PCRAFN4H4ZPO77WB6RHXEHMJT'),

LOWER('GDUQXQAR4ECNAYCTGZAS4TH4KJJIZDLXPR5V2YYRFRGGQ3LTXBFTBVW6'),

LOWER('GCRJROYL4MFGCGFC3VB7NNQ7QQMOAXUWHCV7IJYTDZHQWII5GN7D4J6F'), -- Cold Wallets

LOWER('GBCEYVPTL6BFCEIAVTSWVLEKCLVKEPSBXXM6BMHCN5A6VFANO4KWCVZI'),

LOWER('GAU5RIRH2V4OQZMUWZ64WCZD4KHJ5RJ2NGTYGDVPUVKRRVXDSZU3IFTL'),

LOWER('GDGCDU5OLMJ3PT2HSDACJRHMLUWPTLUERWHX7TOR7DTO3IMI5GBZSMYL'),

LOWER('GCTQR4WHN4VDLBZIN7NWAOEGLQZVU4EASCXZLKN7VKBYDXQY4IAP3XW5')

)

OR

LOWER(o.to_account) IN (

LOWER('GDQP2KPQGKIHYJGXNUIYOMHARUARCA7DJT5FO2FFOOKY3B2WSQHG4W37') -- Deposits

)

)

SELECT

closed_at,

transaction_hash,

source_account AS sender,