mz0111inflow outflow 4
    Updated 2023-01-13
    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