SocioCryptoBalance
Updated 2023-06-01
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 flow in-out @ https://flipsidecrypto.xyz/edit/queries/13564020-7d8a-4b33-9271-e7e4fac3d784
/*
1 0xdbd08d75a614567ff03f50e75b2a72ff9af35700
2 0xe3dde4c065e2ddd2ba9c9499fb130d21ca02a44c
3 0x22a2c3f538fa945bbca3c35b685c1b8a136c7a62
4 0x4aefa39caeadd662ae31ab0ce7c8c2c9c0a013e8
5 0x989536719a72cfd50348ccd5521256c7eb41a999
6 0xf89d7b9c864f589bbf53a82105107622b35eaa40
7 0xd464ecbd0c16169c098abd367124c3e4ee46a9f5
8 0x9b2cc8e6a2bbb56d6be4682891a91b0e48633c72
9 0xbbf693b3d4efbbedb9e33daae4901d418f4dda15
10 0xe6422a0e59082831f6bf70da68bfa3c81b35f945
11 0x40e832c3df9562dfae5a86a4849f27f687a9b46b
12 0x013b646fe54562a3ff6e3469fcc8c4efc2337656
13 0xe195b82df6a797551eb1acd506e892531824af27
14 0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701
15 0x46f80018211d5cbbc988e853a8683501fca4ee9b
*/
-- 233609007.38246
SELECT 'Ethereum' as blochchain,
sum(CASE when to_address ='{{whale_address}}' then amount_usd end) as volume_in,
-1*sum(CASE when from_address ='{{whale_address}}' then amount_usd end) as volume_out,
volume_in-volume_out as total_volume_usd,
volume_in+volume_out as net_volume_usd
FROM ethereum.core.ez_token_transfers
--WHERE block_timestamp > current_date-30
UNION
SELECT 'Arbitrum' as blochchain,
sum(CASE when to_address ='{{whale_address}}' then amount_usd end) as volume_in,
-1*sum(CASE when from_address ='{{whale_address}}' then amount_usd end) as volume_out,
volume_in-volume_out as total_volume_usd,
volume_in+volume_out as net_volume_usd
FROM arbitrum.core.ez_token_transfers
--WHERE block_timestamp > current_date-30
Run a query to Download Data