lukecannon727IKB p and L
Updated 2024-06-03
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 txns as (
select FROM_ADDRESS as wallet
, - AMOUNT as net_deposits_withdrawals
from blast.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = '0x4300000000000000000000000000000000000003'
AND
(TO_ADDRESS = lower('0x472f4cfc2a7527D708AcdaF7d38B179e649E234a')
OR TO_ADDRESS = lower('0x61fccfC0279B09c387608efF56Fd9187e61D2874'))
UNION ALL
select to_address as wallet
, AMOUNT as net_deposits_withdrawals
from blast.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = '0x4300000000000000000000000000000000000003'
AND
(from_address = lower('0x472f4cfc2a7527D708AcdaF7d38B179e649E234a')
OR from_address = lower('0x61fccfC0279B09c387608efF56Fd9187e61D2874'))
UNION ALL
select FROM_ADDRESS as wallet
, - AMOUNT as net_deposits_withdrawals
from base.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = lower('0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913')
AND
(TO_ADDRESS = lower('0x1423230edE01F82c1247F580fe91D608D62F0b61')
OR TO_ADDRESS = lower('0x61fccfC0279B09c387608efF56Fd9187e61D2874'))
UNION ALL
select to_address as wallet
, AMOUNT as net_deposits_withdrawals
from base.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = lower('0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913')
QueryRunArchived: QueryRun has been archived