mz0111redux 8
Updated 2022-11-02
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc(month,BLOCK_TIMESTAMP) as date ,
count (DISTINCT tx_hash) " bridge count",
sum (AMOUNT_USD) "USD amount",
sum ("USD amount") over (order by date ) "cumulative USD amount",
symbol,
count(distinct ORIGIN_FROM_ADDRESS ) as "number of unique bridgers"
from ethereum.core.ez_token_transfers
where SYMBOL in ('USDC', 'sUSD' , 'DAI','USDT' )
and to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
group by 1, 5
Run a query to Download Data