TOTAL_EXPECTED_PAYMENT_IN_USD | TOTAL_RECEIVED_PAYMENT_IN_USD | BALANCE_OWED_IN_USD | |
|---|---|---|---|
1 | 1490 | 1330 | 160 |
defi__joshAjia's payments to 0x4...482d (Summary)
Updated 2025-03-20
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 addy AS
(
SELECT
BLOCK_TIMESTAMP,
SYMBOL,
AMOUNT
FROM ethereum.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS in (
lower ('0xdAC17F958D2ee523a2206206994597C13D831ec7'), ---USDT ERC20 CA
lower ('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') ---USDC ERC20 CA
)
and
ORIGIN_FROM_ADDRESS = lower('0xEa070D40D6B802C547D929fF216549e429aEfd2A')
and
BLOCK_TIMESTAMP :: date >= '2024-09-01'
and
TO_ADDRESS = lower ('0x4fd8cd9cf58ce8fd6ebde594ab60b195395a482d') ---- addy
union all
select
BLOCK_TIMESTAMP,
SYMBOL,
AMOUNT
from bsc.core.ez_token_transfers
where
CONTRACT_ADDRESS in (
lower ('0x55d398326f99059fF775485246999027B3197955'), ---USDT BEP20 CA
lower ('0x8AC76a51cc950d9822D68b83fE1Ad97B32Cd580d') ---USDC BEP20 CA
)
and
FROM_ADDRESS = lower ('0xEa070D40D6B802C547D929fF216549e429aEfd2A')
and
TO_ADDRESS = lower ('0x4fd8cd9cf58ce8fd6ebde594ab60b195395a482d')
and
Last run: 19 days ago
1
17B
10s