week | money paid in USD | |
|---|---|---|
1 | 2024-09-16 | 70 |
2 | 2024-09-23 | 70 |
3 | 2024-09-30 | 70 |
4 | 2024-10-07 | 0 |
5 | 2024-10-14 | 70 |
6 | 2024-10-21 | 70 |
7 | 2024-10-28 | 140 |
8 | 2024-11-04 | 0 |
9 | 2024-11-11 | 140 |
10 | 2024-11-18 | 70 |
11 | 2024-11-25 | 0 |
12 | 2024-12-02 | 70 |
13 | 2024-12-09 | 140 |
14 | 2024-12-16 | 0 |
15 | 2024-12-23 | 70 |
16 | 2024-12-30 | 0 |
17 | 2025-01-06 | 0 |
18 | 2025-01-13 | 50 |
19 | 2025-01-20 | 0 |
20 | 2025-01-27 | 0 |
defi__joshAll Mr A's payments to 0x4fd8cd9cf58ce8fd6ebde594ab60b195395a482d (Weekly report)
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')
Last run: about 1 month ago
27
478B
11s