defi__joshAjia (Ceramic Souls) transactions
Updated 2025-03-04
999
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 Abbie_money as
(
SELECT *
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 ('0x7f2ed73ce25c28ad75be2dedd83b79bc45c7795d')
union all
select
*
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 ('0x7f2ed73ce25c28ad75be2dedd83b79bc45c7795d')
and
BLOCK_TIMESTAMP :: date > '2024-09-01'
QueryRunArchived: QueryRun has been archived