-- forked from EVM addresses in total @ https://flipsidecrypto.xyz/edit/queries/1431a6dd-5359-45e6-bb18-6ac32a5c6749 -- forked from EVM addresses over time @ https://flipsidecrypto.xyz/edit/queries/6a0dfcb7-cbd4-4f19-8a57-f18ce097ddc3 with userTb as ( SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM polygon.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x488863d609f3a673875a914fbee7508a1de45ec6' -- Polygon ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Polygon ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM arbitrum.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x1b896893dfc86bb67cf57767298b9073d2c1ba2c' -- Arbitrum ,'0x1bacc2205312534375c8d1801c27d28370656cff' -- Arbitrum ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Arbitrum ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM avalanche.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0xa5972eee0c9b5bbb89a5b16d1d65f94c9ef25166' -- avalanche ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- avalanche ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM base.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x3055913c90fcc1a6ce9a358911721eeb942013a1' -- Base ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM bsc.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x2762409baa1804d94d8c0bcff8400b78bf915d5b' -- BSC ,'0xb274202daba6ae180c665b4fbe59857b7c3a8091' -- BSC ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- BSC ,'0x6e906fc1d75c9559e4e8b0f1fa002c4a9724988f' -- BSC ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM ethereum.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x6dd7d2c0f078617313576111b025e2fc505b7c39' -- Ethereum ,'0xe1c0998311f7ef84116e98f32d45503272f57ae8' -- Ethereum ,'0xdac061057d404262ae78968964ffecad97331f78' -- Ethereum ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Ethereum ,'0x50002cdfe7ccb0c41f519c6eb0653158d11cd907' -- Ethereum ) UNION all SELECT BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD FROM optimism.core.ez_token_transfers WHERE ORIGIN_TO_ADDRESS in ( '0x86bb63148d17d445ed5398ef26aa05bf76dd5b59' -- Optimism ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Optimism ) ) , usersTb as ( SELECT ORIGIN_FROM_ADDRESS, round(sum(AMOUNT_USD),2) as bridged_vol_usd, count(*) as n_transfer FROM userTb GROUP by 1 HAVING bridged_vol_usd > 0 ORDER by 2 DESC ) SELECT CASE when bridged_vol_usd < 10 then '< $10' when bridged_vol_usd < 100 then '< $100' when bridged_vol_usd < 1000 then '< $1000' when bridged_vol_usd < 10000 then '< $10k' when bridged_vol_usd < 50000 then '< $50k' when bridged_vol_usd < 100000 then '< $100k' when bridged_vol_usd < 500000 then '< $500k' when bridged_vol_usd >= 500000 then '>= $500k' end as vol_distribution, CASE when n_transfer < 2 then '< 2 Txs' when n_transfer < 5 then '< 5 Txs' when n_transfer < 10 then '< 10 Txs' when n_transfer < 20 then '< 20 Txs' when n_transfer < 50 then '< 50 Txs' when n_transfer >= 50 then '>= 50 Txs' end as tx_distribution, count(DISTINCT ORIGIN_FROM_ADDRESS) as n_evm_senders FROM usersTb -- WHERE bridged_vol_usd > 0 GROUP by 1,2 ORDER by 3 DESC

Apt🌐s || Layerzero Bridge[Past 30D]🌉