mz0111Untitled Query
    Updated 2023-01-14
    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