freemartianDaily Stablecoins - Mainnet >>> Optimism
    Updated 2022-09-13
    select
    sum(amount_usd) as stablecoin_volume,
    count(distinct origin_from_address) as bridgoors_count,
    count(distinct tx_hash) as bridge_count,
    date_trunc('day', block_timestamp::date) as TIME,
    sum(stablecoin_volume) over (order by TIME) as cumulative_volume,
    sum(bridgoors_count) over (order by TIME) as cumulative_bridgoors_count,
    sum(bridge_count) over (order by TIME) as cumulative_bridge_count,
    symbol
    from ethereum.core.ez_token_transfers
    where origin_to_address in ('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1', '0x10e6593cdda8c58a1d0f14c5164b376352a55f2f')
    and block_timestamp > CURRENT_DATE - 120
    and symbol in ('USDC','USDT', 'DAI')
    group by TIME, symbol
    Run a query to Download Data