-- 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'

ajalalniya