mz0111redux 13
Updated 2022-11-03
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc(day,BLOCK_TIMESTAMP) as date ,
count (DISTINCT tx_hash) as "op bridge count" ,
sum (amount ) volume ,
sum (AMOUNT_USD) AS "USD amount" ,
sum ("USD amount") over ( order by date ) as "cumulative USD amount",
count(distinct ORIGIN_FROM_ADDRESS) as "number of unique bridgers"
from ethereum.core.ez_eth_transfers
where ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
group by 1
Run a query to Download Data