flipside

    USDC Balance Over Time
    RayyykUSDC Balance Over Time
    Updated 1 day ago
    with date_range as (select min(date_trunc('week', date_day)) as start_week,
    max(date_trunc('week', date_day)) as end_week
    from optimism.core.dim_dates),

    weeks as (select start_week as week
    from date_range
    union all
    select dateadd(week, 1, week)
    from weeks
    join date_range on weeks.week < date_range.end_week),

    assets AS (select distinct symbol,
    contract_address
    from (select symbol, contract_address from gnosis.core.ez_token_transfers
    where to_address = '0xb0e3175341794d1dc8e5f02a02f9d26989ebedb3'
    and symbol not ilike 'Visit%'
    and symbol not ilike 'Earn%'
    and symbol not ilike 'Claim%'
    union
    select symbol, contract_address
    from gnosis.core.ez_token_transfers
    where from_address = '0xb0e3175341794d1dc8e5f02a02f9d26989ebedb3'
    and symbol not ilike 'Visit%'
    and symbol not ilike 'Earn%'
    and symbol not ilike 'Claim%'
    union
    select 'XDAI' as symbol, null as contract_address) all_assets),

    complete_weeks_assets AS (select week,
    symbol,
    contract_address
    from weeks b
    cross join assets a),

    inflow_tokens as (select date_trunc('week', block_timestamp) as week,
    symbol,
    Last run: 1 day agoAuto-refreshes every 24 hours
    WEEK
    USDC_AMOUNT
    PREVIOUS_WEEK_AMOUNT
    USDC_AMOUNT_CHANGE
    AMOUNT_CHANGE_PERCENT
    % in Amount Change
    START_DATE
    END_DATE
    1
    		2025-04-07 00:00:00.0000.0060.0029970.003003100.200200210001/01/20242025-04-10 00:00:00.000
    2
    		2025-03-31 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    3
    		2025-03-24 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    4
    		2025-03-17 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    5
    		2025-03-10 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    6
    		2025-03-03 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    7
    		2025-02-24 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    8
    		2025-02-17 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    9
    		2025-02-10 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    10
    		2025-02-03 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    11
    		2025-01-27 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    12
    		2025-01-20 00:00:00.0000.0029970.00299700001/01/20242025-04-10 00:00:00.000
    13
    		2025-01-13 00:00:00.0000.00299700.0029970001/01/20242025-04-10 00:00:00.000
    14
    		2025-01-06 00:00:00.000034475.857675-34475.857675-100-10001/01/20242025-04-10 00:00:00.000
    15
    		2024-12-30 00:00:00.00034475.85767534475.85767500001/01/20242025-04-10 00:00:00.000
    16
    		2024-12-23 00:00:00.00034475.85767534475.85767500001/01/20242025-04-10 00:00:00.000
    17
    		2024-12-16 00:00:00.00034475.85767534475.848740.0089349999980.000025916693350.0000259166933501/01/20242025-04-10 00:00:00.000
    18
    		2024-12-09 00:00:00.00034475.84874257.20360434218.64513613304.10795332410001/01/20242025-04-10 00:00:00.000
    19
    		2024-12-02 00:00:00.000257.203604257.20360400001/01/20242025-04-10 00:00:00.000
    20
    		2024-11-25 00:00:00.000257.203604257.20360400001/01/20242025-04-10 00:00:00.000
    67
    6KB
    10s