articoloquintoAggregators Volume in The Last 6 Months
Updated 2024-12-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select (select 'Metamask') as "platform", sum(AMOUNT_USD) as "volume (USD)" from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c') and BLOCK_TIMESTAMP >= DATEADD(month, -6, GETDATE()) and ORIGIN_FUNCTION_SIGNATURE != '0x' and TO_ADDRESS = ORIGIN_FROM_ADDRESS and CONTRACT_ADDRESS != lower('0x8B3192f5eEBD8579568A2Ed41E6FEB402f93f73F') and CONTRACT_ADDRESS != lower('0x3F7Aff0EF20AA2E646290DfA4E67611B2220C597') and CONTRACT_ADDRESS != lower('0x6ADb2E268de2aA1aBF6578E4a8119b960E02928F') and CONTRACT_ADDRESS != lower('0x3063C77C4ef5C1DE185321AE2BC5675e17344f7F') and CONTRACT_ADDRESS != lower('0xab167E816E4d76089119900e941BEfdfA37d6b32') and CONTRACT_ADDRESS != lower('0xFD957F21bd95E723645C07C48a2d8ACB8Ffb3794')
union ALL
select (select 'Matcha') as "platform", sum(AMOUNT_USD) as "volume (USD)" from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = lower('0xDef1C0ded9bec7F1a1670819833240f027b25EfF') and BLOCK_TIMESTAMP >= DATEADD(month, -6, GETDATE()) and ORIGIN_FUNCTION_SIGNATURE != '0x' and TO_ADDRESS = ORIGIN_FROM_ADDRESS and CONTRACT_ADDRESS != lower('0x8B3192f5eEBD8579568A2Ed41E6FEB402f93f73F') and CONTRACT_ADDRESS != lower('0x3F7Aff0EF20AA2E646290DfA4E67611B2220C597') and CONTRACT_ADDRESS != lower('0x6ADb2E268de2aA1aBF6578E4a8119b960E02928F') and CONTRACT_ADDRESS != lower('0x3063C77C4ef5C1DE185321AE2BC5675e17344f7F') and CONTRACT_ADDRESS != lower('0xab167E816E4d76089119900e941BEfdfA37d6b32') and CONTRACT_ADDRESS != lower('0xFD957F21bd95E723645C07C48a2d8ACB8Ffb3794')
union ALL
select (select '1inch') as "platform", sum(AMOUNT_USD) as "volume (USD)" from ethereum.core.ez_token_transfers
where (ORIGIN_TO_ADDRESS = lower('0x11111112542d85b3ef69ae05771c2dccff4faa26') or ORIGIN_TO_ADDRESS = lower('0x1111111254fb6c44bac0bed2854e76f90643097d')) and BLOCK_TIMESTAMP >= DATEADD(month, -6, GETDATE()) and ORIGIN_FUNCTION_SIGNATURE != '0x' and TO_ADDRESS = ORIGIN_FROM_ADDRESS and CONTRACT_ADDRESS != lower('0x8B3192f5eEBD8579568A2Ed41E6FEB402f93f73F') and CONTRACT_ADDRESS != lower('0x3F7Aff0EF20AA2E646290DfA4E67611B2220C597') and CONTRACT_ADDRESS != lower('0x6ADb2E268de2aA1aBF6578E4a8119b960E02928F') and CONTRACT_ADDRESS != lower('0x3063C77C4ef5C1DE185321AE2BC5675e17344f7F') and CONTRACT_ADDRESS != lower('0xab167E816E4d76089119900e941BEfdfA37d6b32') and CONTRACT_ADDRESS != lower('0xFD957F21bd95E723645C07C48a2d8ACB8Ffb3794')
union ALL
select (select 'Paraswap') as "platform", sum(AMOUNT_USD) as "volume (USD)" from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = lower('0xdef171fe48cf0115b1d80b88dc8eab59176fee57') and BLOCK_TIMESTAMP >= DATEADD(month, -6, GETDATE()) and ORIGIN_FUNCTION_SIGNATURE != '0x' and TO_ADDRESS = ORIGIN_FROM_ADDRESS and CONTRACT_ADDRESS != lower('0x8B3192f5eEBD8579568A2Ed41E6FEB402f93f73F') and CONTRACT_ADDRESS != lower('0x3F7Aff0EF20AA2E646290DfA4E67611B2220C597') and CONTRACT_ADDRESS != lower('0x6ADb2E268de2aA1aBF6578E4a8119b960E02928F') and CONTRACT_ADDRESS != lower('0x3063C77C4ef5C1DE185321AE2BC5675e17344f7F') and CONTRACT_ADDRESS != lower('0xab167E816E4d76089119900e941BEfdfA37d6b32') and CONTRACT_ADDRESS != lower('0xFD957F21bd95E723645C07C48a2d8ACB8Ffb3794')
QueryRunArchived: QueryRun has been archived