flipside

    Stablecoins: USDC
    matejchiStablecoins: USDC
    Updated 2025-04-12
    with supply_arbitrum as
    (
    select
    'Arbitrum' as chain,
    date_trunc('day', block_timestamp::date) as day,
    sum(case
    when from_address = '0x0000000000000000000000000000000000000000' then amount
    when to_address = '0x0000000000000000000000000000000000000000' then - amount
    end) as daily_supply_change
    from arbitrum.core.ez_token_transfers
    where contract_address = lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831') -- USDC
    group by day
    ),
    supply_base as
    (
    select
    'Base' as chain,
    date_trunc('day', block_timestamp::date) as day,
    sum(case
    when from_address = '0x0000000000000000000000000000000000000000' then amount
    when to_address = '0x0000000000000000000000000000000000000000' then - amount
    end) as daily_supply_change
    from base.core.ez_token_transfers
    where contract_address = lower('0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913') -- USDC
    group by day
    ),
    supply_optimism as
    (
    select
    'Optimism' as chain,
    date_trunc('day', block_timestamp::date) as day,
    sum(case
    when from_address = '0x0000000000000000000000000000000000000000' then amount
    when to_address = '0x0000000000000000000000000000000000000000' then - amount
    end) as daily_supply_change
    from optimism.core.ez_token_transfers
    Last run: 14 days ago
    CHAIN
    DAY
    BALANCE
    1
    		Arbitrum2022-11-01 00:00:00.000139.03
    2
    		Arbitrum2022-11-02 00:00:00.000139.03
    3
    		Arbitrum2022-11-03 00:00:00.000139.03
    4
    		Arbitrum2022-11-09 00:00:00.000139.03
    5
    		Arbitrum2022-11-10 00:00:00.000139.03
    6
    		Optimism2022-11-15 00:00:00.000113.01
    7
    		Arbitrum2022-11-15 00:00:00.000213.16
    8
    		Optimism2022-11-16 00:00:00.000113.01
    9
    		Optimism2022-11-17 00:00:00.000122.4
    10
    		Optimism2022-11-18 00:00:00.0002086028.19
    11
    		Optimism2022-11-20 00:00:00.0001383045.76
    12
    		Optimism2022-11-21 00:00:00.0001456138.41
    13
    		Optimism2022-11-22 00:00:00.000122.41
    14
    		Arbitrum2022-11-22 00:00:00.000213.18
    15
    		Arbitrum2022-11-23 00:00:00.000213.18
    16
    		Arbitrum2022-11-24 00:00:00.000213.19
    17
    		Arbitrum2022-11-25 00:00:00.000213.17
    18
    		Optimism2022-11-28 00:00:00.000133.58
    19
    		Arbitrum2023-03-14 00:00:00.000213.17
    20
    		Optimism2023-03-14 00:00:00.000133.58
    ...
    1914
    101KB
    44s