mz0111Untitled Query
Updated 2023-01-14
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 ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
and date >= CURRENT_DATE - 30
group by 1, 5
Run a query to Download Data