Abbas_ra21Users by Depsoit Amount
Updated 2024-02-25
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
›
⌄
-- forked from TVL by Symbol @ https://flipsidecrypto.xyz/edit/queries/3308cdac-2722-44de-b3eb-7f232cef21f5
with main AS (select
Block_timestamp,
TX_HASH,
case
when to_address = '0x80d40e32fad8be8da5c6a42b8af1e181984d137c' then 'Deposit'
else 'Withdraw'
end AS Action,
'Arbitrum' AS Chain,
case
when to_address = '0x80d40e32fad8be8da5c6a42b8af1e181984d137c' then from_address
else to_address end AS user,
symbol,
Amount,
Amount_USD
from
arbitrum.core.ez_token_transfers
where
(to_address = '0x80d40e32fad8be8da5c6a42b8af1e181984d137c'
or from_address = '0x80d40e32fad8be8da5c6a42b8af1e181984d137c') and symbol in ('USDC','WETH','USDT','WBTC')
union
ALL
select
Block_timestamp,
TX_HASH,
case
when to_address = '0xfff4a34925301d231ddf42b871c3b199c1e80584' then 'Deposit'
else 'Withdraw'
end AS Action,
'optimism' AS Chain,
case
when to_address = '0xfff4a34925301d231ddf42b871c3b199c1e80584' then from_address
else to_address end AS user,
symbol,
Amount,
QueryRunArchived: QueryRun has been archived