-- forked from Aztec total 1 @ https://flipsidecrypto.xyz/edit/queries/ab708199-a0d1-420a-89a6-9b435e4ded7a -- forked from Aztec total 0 @ https://flipsidecrypto.xyz/edit/queries/cd2ee473-c739-4831-983c-21eca1b508e8 with x as (SELECT BLOCK_TIMESTAMP::date as date, 'ETH' as SYMBOL, AMOUNT, AMOUNT_USD, TX_HASH, ORIGIN_FROM_ADDRESS as user, 'Aztec Private Rollup' as version from ethereum.core.ez_eth_transfers where ORIGIN_FUNCTION_SIGNATURE = '0xd1d2d95e' and ORIGIN_TO_ADDRESS = '0x737901bea3eeb88459df9ef1be8ff3ae1b42a2ba' and BLOCK_TIMESTAMP::date <= ' 2023-03-21' --sunset date union SELECT BLOCK_TIMESTAMP::date as date, SYMBOL, AMOUNT, AMOUNT_USD, TX_HASH , ORIGIN_FROM_ADDRESS as user, 'Aztec Private Rollup' as version from ethereum.core.ez_token_transfers where ORIGIN_TO_ADDRESS in ('0x737901bea3eeb88459df9ef1be8ff3ae1b42a2ba') and ORIGIN_FUNCTION_SIGNATURE in ('0xd1d2d95e') and BLOCK_TIMESTAMP::date <= ' 2023-03-21' --sunset date union SELECT BLOCK_TIMESTAMP::date as date, 'ETH' as SYMBOL, AMOUNT, AMOUNT_USD, TX_HASH, ORIGIN_FROM_ADDRESS as user, 'Aztec connect' as version from ethereum.core.ez_eth_transfers where ORIGIN_TO_ADDRESS in ('0xff1f2b4adb9df6fc8eafecdcbf96a2b351680455') and ORIGIN_FUNCTION_SIGNATURE in ('0x7ff48afb') and BLOCK_TIMESTAMP::date <= ' 2023-03-21' --sunset date union SELECT BLOCK_TIMESTAMP::date as date, SYMBOL, AMOUNT, AMOUNT_USD, TX_HASH , ORIGIN_FROM_ADDRESS as user, 'Aztec connect' as version from ethereum.core.ez_token_transfers where ORIGIN_TO_ADDRESS in ('0xff1f2b4adb9df6fc8eafecdcbf96a2b351680455') and ORIGIN_FUNCTION_SIGNATURE in ('0x7ff48afb') and BLOCK_TIMESTAMP::date <=' 2023-03-21' --sunset date ) , t1 as (SELECT DISTINCT user , count(DISTINCT tx_hash) as times, round(sum(AMOUNT_USD)) as volume from x group by 1 ) SELECT count(DISTINCT user ) as users, --case when swaps = 1 then 'A) Only 1 swap' --when swaps > 1 and swaps < 11 then 'B) Between 2~10 swaps' --when swaps > 10 and swaps < 51 then 'C) Between 11~50 swaps' --when swaps > 50 and swaps < 101 then 'D) Between 51~100 swaps' --when swaps > 100 then 'E) More than 100 swaps' end as "Swap level"--, case when volume < 10 then 'A. Less than $10' when volume > 9 and volume < 51 then 'B. Between $10~$50' when volume > 50 and volume < 101 then 'C. Between $51~$100' when volume > 100 and volume < 501 then 'D. Between $101~$500' when volume > 500 then 'E. More than $500' end as "Volume level" from t1 group by 2 having "Volume level" is not null

Aztec- Ethereum, encrypted