permaryyammering-blue
    Updated 2025-02-22
    WITH cex_operations AS (
    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,
    QueryRunArchived: QueryRun has been archived