flipside

    Asset Balance Over Time (Excluding FOX)
    RayyykAsset Balance Over Time (Excluding FOX)
    Updated 11 hours 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 arbitrum.core.ez_token_transfers
    where to_address = '0x38276553f8fbf2a027d901f8be45f00373d8dd48'
    and symbol not ilike 'Visit%'
    and symbol not ilike 'Earn%'
    and symbol not ilike 'Claim%'
    union
    select symbol, contract_address
    from arbitrum.core.ez_token_transfers
    where from_address = '0x38276553f8fbf2a027d901f8be45f00373d8dd48'
    and symbol not ilike 'Visit%'
    and symbol not ilike 'Earn%'
    and symbol not ilike 'Claim%'
    union
    select 'ETH' 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: about 11 hours agoAuto-refreshes every 24 hours
    DATE
    SYMBOL
    CONTRACT_ADDRESS
    ASSET_BALANCE
    BALANCE_USD
    RN
    START_DATE
    END_DATE
    TOTAL_WITHOUT_FOX
    1
    		2025-04-28 00:00:00.000USDC0xaf88d065e77c8cc2239327c5edb3a432268e583194295.06823294285.544430109101/01/20242025-04-28 00:00:00.00099670.862020397
    2
    		2025-04-28 00:00:00.000ARB0x912ce59144191c1204e64559fe8253a0e49e654813186.9558521244490.72550675101/01/20242025-04-28 00:00:00.00099670.862020397
    3
    		2025-04-28 00:00:00.000ETH0.1859861604334.358479732101/01/20242025-04-28 00:00:00.00099670.862020397
    4
    		2025-04-28 00:00:00.000MOR0x092baadb7def4c3981454dd9c0a0d7ff07bcfc8627.173092332186.950875242101/01/20242025-04-28 00:00:00.00099670.862020397
    5
    		2025-04-28 00:00:00.000USDGLO0x4f604735c1cf31399c6e711d5962b2b3e0225ad3129.89130.01989101/01/20242025-04-28 00:00:00.00099670.862020397
    6
    		2025-04-28 00:00:00.000ANT0xa78d8321b20c4ef90ecd72f2588aa985a4bdb6841042.395167731103.721446375101/01/20242025-04-28 00:00:00.00099670.862020397
    7
    		2025-04-28 00:00:00.000WBTC0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f0.0007870774.59534632101/01/20242025-04-28 00:00:00.00099670.862020397
    8
    		2025-04-28 00:00:00.000USDT0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb924.56237824.562378101/01/20242025-04-28 00:00:00.00099670.862020397
    9
    		2025-04-28 00:00:00.000LPT0x289ba1701c2f088cf0faf8b3705246331cb8a8393.47736540618.117073767101/01/20242025-04-28 00:00:00.00099670.862020397
    10
    		2025-04-28 00:00:00.000PENDLE0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e82.7449252459.30529658101/01/20242025-04-28 00:00:00.00099670.862020397
    11
    		2025-04-28 00:00:00.000WETH0x82af49447d8a07e3bd95bd0d56f35241523fbab10.0042158752877.577361288101/01/20242025-04-28 00:00:00.00099670.862020397
    12
    		2025-04-28 00:00:00.000USDC0xff970a61a04b1ca14834a43f5de4533ebddb5cc83.2027623.2011382101/01/20242025-04-28 00:00:00.00099670.862020397
    13
    		2025-04-28 00:00:00.000DeFAI0x13ad3f1150db0e1e05fd32bdeeb7c110ee023de6347.86881.907642925101/01/20242025-04-28 00:00:00.00099670.862020397
    14
    		2025-04-28 00:00:00.000LINK0xf97f4df75117a78c1a5a0dbb814af92458539fb40.014249970440.2131795578101/01/20242025-04-28 00:00:00.00099670.862020397
    15
    		2025-04-28 00:00:00.000DAI0xda10009cbd5d07dd0cecc66161fc93d7c9000da10.032904614350.03293751896101/01/20242025-04-28 00:00:00.00099670.862020397
    16
    		2025-04-28 00:00:00.000KUJI0x3a18dcc9745edcd1ef33ecb93b0b6eba5671e7ca0.0885260.02358872649101/01/20242025-04-28 00:00:00.00099670.862020397
    17
    		2025-04-28 00:00:00.000UNI0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f00.00093172403270.005096530459101/01/20242025-04-28 00:00:00.00099670.862020397
    18
    		2025-04-28 00:00:00.000BAL0x040d1edc9569d4bab2d15287dc5a4f10f56a56b80.00031240739280.0002976283363101/01/20242025-04-28 00:00:00.00099670.862020397
    19
    		2025-04-28 00:00:00.000DMT0x8b0e6f19ee57089f7649a455d89d7bc6314d04e80.0000071442788050.00005015283721101/01/20242025-04-28 00:00:00.00099670.862020397
    20
    		2025-04-28 00:00:00.000FTW0x306fd3e7b169aa4ee19412323e1a5995b8c1a1f410000.000003137101/01/20242025-04-28 00:00:00.00099670.862020397
    ...
    837
    131KB
    23s