-- SELECT * from arbitrum.core.ez_token_transfers WHERE (CONTRACT_ADDRESS = '0x912ce59144191c1204e64559fe8253a0e49e6548' or CONTRACT_ADDRESS = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1') and (ORIGIN_TO_ADDRESS = '0x6352a56caadc4f1e25cd6c75970fa768a3304e64' or ORIGIN_FROM_ADDRESS = '0x6352a56caadc4f1e25cd6c75970fa768a3304e64') AND BLOCK_TIMESTAMP >= DATEADD(day, -1, GETDATE()) -- AND BLOCK_TIMESTAMP <= GETDATE(); -- SELECT COUNT(*) AS result_count ,SUM(AMOUNT_IN_USD) As Volume -- FROM arbitrum.defi.ez_dex_swaps -- WHERE ORIGIN_TO_ADDRESS = '0x6352a56caadc4f1e25cd6c75970fa768a3304e64' -- --AND TOKEN_IN = '0x912CE59144191C1204E64559FE8253a0e49E6548' -- --AND TOKEN_OUT = '0xEeeeeEeeeEeEeeEeEeEeeEEEeeeeEeeeeeeeEEeE' -- AND ((SYMBOL_IN = 'ARB' -- AND SYMBOL_OUT = 'WETH') OR (SYMBOL_IN = 'WETH' -- AND SYMBOL_OUT = 'ARB')) -- AND BLOCK_TIMESTAMP >= DATEADD(day, -30, GETDATE()) -- AND BLOCK_TIMESTAMP <= GETDATE(); -- SELECT TX_HASH FROM arbitrum.core.ez_token_transfers where CONTRACT_ADDRESS ILIKE '0xc6Fe68056110402515e3Bf36178dEF952bacD42A' -- AND TO_ADDRESS ILIKE '0xF8be5dD7701955e172a2FCe8DE5a07f33612d129' -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-06' -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-25' -- GROUP BY TX_HASH; -- WITH FilteredData AS ( -- SELECT TX_HASH -- FROM polygon.core.ez_token_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xb7278f16b8c6bfc5b448fb2dad7d0a55fd238b9e' -- AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS -- AND ORIGIN_To_ADDRESS = To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-06' -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-25' -- GROUP BY TX_HASH; -- ) -- SELECT SUM(AMOUNT_USD) AS TotalAmountUSD, COUNT(*) AS RowCount -- FROM FilteredData; -- SELECT TX_HASH -- FROM polygon.core.ez_matic_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xb7278f16b8c6bfc5b448fb2dad7d0a55fd238b9e' -- AND ORIGIN_FROM_ADDRESS = MATIC_FROM_ADDRESS -- AND ORIGIN_To_ADDRESS = MATIC_To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-06' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-25' -- Replace with your end time -- GROUP BY TX_HASH; -- SELECT * -- FROM bsc.core.ez_bnb_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xd4560c06db2bAe0b06E9243896aD48e4bD14cdb2' -- AND ORIGIN_FROM_ADDRESS != BNB_To_ADDRESS -- AND ORIGIN_To_ADDRESS = BNB_FROM_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-10' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end time -- SELECT TX_HASH FROM polygon.core.ez_token_transfers -- WHERE ORIGIN_TO_ADDRESS ilike '0xBBc607D84eE5836C802B8b98392C8EAd8B9cDa5D' -- -- AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS -- -- AND ORIGIN_To_ADDRESS = To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-22' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end -- GROUP BY TX_HASH -- WITH FilteredData AS ( -- SELECT * -- FROM polygon.core.ez_matic_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xBBc607D84eE5836C802B8b98392C8EAd8B9cDa5D' -- AND ORIGIN_FROM_ADDRESS != MATIC_To_ADDRESS -- AND ORIGIN_To_ADDRESS = MATIC_FROM_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-22' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end time -- ) -- SELECT SUM(AMOUNT_USD) AS TotalAmountUSD, COUNT(*) AS RowCount -- FROM FilteredData; -- WITH FilteredData AS ( -- SELECT * -- FROM polygon.core.ez_token_transfers -- WHERE ORIGIN_TO_ADDRESS ilike '0xBBc607D84eE5836C802B8b98392C8EAd8B9cDa5D' -- AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS -- AND ORIGIN_To_ADDRESS = To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-22' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end -- ) -- SELECT SUM(AMOUNT_USD) AS TotalAmountUSD, COUNT(*) AS RowCount -- FROM FilteredData; -- WITH FilteredData AS ( -- SELECT * -- FROM polygon.core.ez_token_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xb7278f16b8c6bfc5b448fb2dad7d0a55fd238b9e' -- AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS -- AND ORIGIN_To_ADDRESS = To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-25' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end time -- ) -- SELECT SUM(AMOUNT_USD) AS TotalAmountUSD, COUNT(*) AS RowCount -- FROM FilteredData; -- WITH FilteredData AS ( -- SELECT * -- FROM polygon.core.ez_matic_transfers -- WHERE ORIGIN_TO_ADDRESS ILIKE '0xb7278f16b8c6bfc5b448fb2dad7d0a55fd238b9e' -- AND ORIGIN_FROM_ADDRESS = MATIC_FROM_ADDRESS -- AND ORIGIN_To_ADDRESS = MATIC_To_ADDRESS -- AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-25' -- Replace with your start time -- AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-29' -- Replace with your end time -- ) -- SELECT SUM(AMOUNT_USD) AS TotalAmountUSD, COUNT(*) AS RowCount -- FROM FilteredData; SELECT SUM(AMOUNT) FROM bsc.core.ez_token_transfers where CONTRACT_ADDRESS ILIKE '0xa39dde5723C8007Ee4065Ba1D9b1E98E182b87db' AND TO_ADDRESS ILIKE '0x7d11E3496bA992Ef93162EcDc4BcA7225697035E' AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-10-15' AND BLOCK_TIMESTAMP <= TIMESTAMP '2023-10-30'

Query	Creator	Created
Untitled Query bsc ethereum polygon evm binance	ajalalniya	Aug 9, 2022
Copy of Untitled Query copy	ajalalniya	Jul 13, 2023
Copy of Untitled Query uniswap kyberswap woofi hashflow dodo	ajalalniya	Nov 15, 2022

ajalalniya