permaryyammering-blue
Updated 2025-02-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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