Aggregate historical transaction data: Total addresses and amounts transacting from Ethererum mainnet to zksync up to 60 days ago

potmoAggregate historical transaction data: Total addresses and amounts transacting from Ethererum mainnet to zksync up to 60 days ago

Updated 2022-06-17

select count(distinct eth_from_address) as total_distinct_addresses,

sum(amount) as total_eth_sent,

sum(amount_usd) as total_usd_sent

from ethereum.core.ez_eth_transfers

where ETH_TO_ADDRESS = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')

and block_timestamp::date > current_date - 60

and amount_usd > 1

Run a query to Download Data

flipside