freemartianSymbiotic Mellow Deposits
Updated 2024-08-20
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 mellow_deposit AS (
SELECT
*
-- block_timestamp,
-- tx_hash,
-- from_address,
-- symbol,
-- amount,
-- amount_usd
FROM ethereum.core.ez_token_transfers
WHERE
-- tx_hash = '0x10b9a06296a38f8e904c53c2c864493d7c17d123ed02c1743639db14004753f7'
-- AND
from_address IN (
-- mellow
'0x5e362eb2c0706bd1d134689ec75176018385430b',
'0x7f43fde12a40de708d908fb3b9bfb8540d9ce444',
'0x3a828c183b3f382d030136c824844ea30145b4c7',
'0x64047dd3288276d70a4f8b5df54668c8403f877f',
'0x7b31f008c48efb65da78ea0f255ee424af855249',
'0x5fd13359ba15a84b76f7f87568309040176167cd',
'0x7a4effd87c2f3c55ca251080b1343b605f327e3a',
'0x8c9532a60e0e7c6bbd2b2c1303f63ace1c3e9811',
'0xbeef69ac7870777598a04b2bd4771c71212e6abc',
'0x84631c0d0081fde56deb72f6de77abbbf6a9f93a',
'0x82f5104b23ff2fa54c2345f821dac9369e9e0b26',
'0xc65433845ecd16688eda196497fa9130d6c47bd8',
'0xd6e09a5e6d719d1c881579c9c8670a210437931b',
'0x49cd586dd9ba227be9654c735a659a1db08232a9',
'0x82dc3260f599f4fc4307209a1122b6eaa007163b'
)
AND
to_address IN (
-- symbiotic
'0xc329400492c6ff2438472d4651ad17389fcb843a',
'0xb26ff591f44b04e78de18f43b46f8b70c6676984',
QueryRunArchived: QueryRun has been archived