select sum(ct) from ( select count(distinct origin_from_address) ct from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-21' union all select count(distinct origin_from_address) ct from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-21' ) ; -- Total volume select sum(usd) from ( sum(amount_usd) usd from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' -- and block_timestamp < '2024-02-22' and token_address = '0x0000000000000000000000000000000000001010' and amount > 0 union all select sum(amount_usd) usd from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' -- and block_timestamp < '2024-02-22' and amount > 0 ) ; -- Total volume select sum(usd) from ( select sum(amount_usd) usd from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and amount > 0 union all select sum(amount_usd) usd from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and contract_address = lower('0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270') and amount > 0 union all select sum(amount_usd) usd from ethereum.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and contract_address = lower('0x7c9f4C87d911613Fe9ca58b579f737911AAD2D43') and amount > 0 union all select sum(amount_usd) usd from bsc.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and contract_address = lower('0xc836d8dC361E44DbE64c4862D55BA041F88Ddd39') and amount > 0 ) ; select count(distinct address) from ( select DISTINCT from_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_number <= 41978358 and amount > 0 union all select DISTINCT to_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_number <= 41978358 and amount > 0 union all select DISTINCT from_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_number <= 41978358 and contract_address = lower('0x7c9f4C87d911613Fe9ca58b579f737911AAD2D43') and amount > 0 union all select DISTINCT to_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_number <= 41978358 and contract_address = lower('0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7') and amount > 0 ) ; select count(distinct address) from ( select DISTINCT from_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and amount > 0 union all select DISTINCT to_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and amount > 0 union all select DISTINCT from_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and amount > 0 union all select DISTINCT to_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-13' and block_timestamp < '2024-02-22' and amount > 0 ) ; select max (block_number) from avalanche.core.ez_native_transfers; select sum(usd) from ( select sum(amount_usd) usd from avalanche.core.ez_native_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 union all select sum(amount_usd) usd from avalanche.core.ez_token_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 ) ; -- Find transactions with the highest usd value select tx_hash, sum(usd) from ( select tx_hash, sum(amount_usd) usd from avalanche.core.ez_native_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 group by tx_hash union all select tx_hash, sum(amount_usd) usd from avalanche.core.ez_token_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 group by tx_hash ) group by tx_hash order by sum(usd) desc nulls last limit 10 ; -- Search by specific transaction select * from ( select tx_hash, tx_position, amount_usd from avalanche.core.ez_native_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 and tx_hash = '0x882f3cb1584c6c61fe3cabf2d2cd99519f120956e345161a53e486a4296083c7' union all select tx_hash, event_index, amount_usd from avalanche.core.ez_token_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 and tx_hash = '0x882f3cb1584c6c61fe3cabf2d2cd99519f120956e345161a53e486a4296083c7' ) ;

Query	Creator	Created
2024-02-21 11:38 AM polygon evm	rachel_crypto	Feb 21, 2024
2024-05-08 10:31 AM polygon evm	rachel_crypto	May 8, 2024
2024-03-06 09:46 AM polygon evm	rachel_crypto	Mar 6, 2024
Getting Started	rachel_crypto	Feb 21, 2024

rachel_crypto