j-hackworthwallet_breakdown
Updated 2022-11-23
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 temp_table as (SELECT
address,
'Ethereum' as networks,
COUNT(amount) as no_transactions,
SUM(amount) as total_amount_of_USDC
FROM (SELECT
amount * -1 as amount,
from_address as address
FROM ethereum.core.ez_token_transfers
WHERE symbol = 'USDC'
and contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
and 'Ethereum' = '{{Network}}'
UNION ALL
SELECT
amount as amount,
to_address as address
FROM ethereum.core.ez_token_transfers
WHERE symbol = 'USDC'
and contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
and 'Ethereum' = '{{Network}}')
WHERE address != '0x60e669577474eede81b7ab21e38b85918ec29a29'
GROUP BY address
UNION ALL
SELECT
address,
'Optimism' as networks,
COUNT(amount) as no_transactions,
SUM(amount) as total_amount_of_USDC
FROM (SELECT
from_address as address,
raw_amount / POWER(10,6) * -1 as amount
Run a query to Download Data