mz0111inflow outflow 4
Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc(day,BLOCK_TIMESTAMP) as date ,
count (DISTINCT tx_hash) " bridge count",
sum (AMOUNT_USD) "USD amount",
sum ("USD amount") over (partition by symbol 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', 'USDT' )
and to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and date >= CURRENT_DATE - 30
group by 1, 5
Run a query to Download Data