flipside

    Total Balance by Asset Over Time
    RayyykTotal Balance by Asset Over Time
    Updated 9 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 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: about 9 hours agoAuto-refreshes every 24 hours
    DATE
    SYMBOL
    CONTRACT_ADDRESS
    ASSET_BALANCE
    BALANCE_USD
    RN
    CURRENT_TOTAL
    FOX_TOTAL
    START_DATE
    END_DATE
    1
    		2025-04-21 00:00:00.000FOX0x21a42669643f45bc0e086b8fc2ed70c23d67509d503656.6157239715060.853853126127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    2
    		2025-04-21 00:00:00.000GIV0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e753986232.8852012710429.699307827127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    3
    		2025-04-21 00:00:00.000WXDAI0xe91d153e0b41518a2ce8dd3d7944fa863463a97d20001998.788127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    4
    		2025-04-21 00:00:00.000USDT0x4ecaba5870353805a9f068101a40e0f32ed605c60.0248230.024847823127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    5
    		2025-04-21 00:00:00.000LINK0xe2e73a1c69ecf83f464efce6a5be353a37ca09b20.0012264999270.01810313892127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    6
    		2025-04-21 00:00:00.000USDC0xddafbb505ad214d7b80b1f830fccc89b60fb7a830.0060.005994114127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    7
    		2025-04-21 00:00:00.000XDAI0.000020999999830.00002098727383127489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    8
    		2025-04-14 00:00:00.000FOX0x21a42669643f45bc0e086b8fc2ed70c23d67509d503656.29044335215581.906778094827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    9
    		2025-04-14 00:00:00.000GIV0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e753986232.885201279915.754301938827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    10
    		2025-04-14 00:00:00.000WXDAI0xe91d153e0b41518a2ce8dd3d7944fa863463a97d20001998.09827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    11
    		2025-04-14 00:00:00.000USDT0x4ecaba5870353805a9f068101a40e0f32ed605c60.0248230.02480984381827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    12
    		2025-04-14 00:00:00.000LINK0xe2e73a1c69ecf83f464efce6a5be353a37ca09b20.0012264999270.01641056902827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    13
    		2025-04-14 00:00:00.000USDC0xddafbb505ad214d7b80b1f830fccc89b60fb7a830.0060.005994732827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    14
    		2025-04-14 00:00:00.000XDAI0.000020999999830.00002097994483827489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    15
    		2025-04-07 00:00:00.000WXDAI0xe91d153e0b41518a2ce8dd3d7944fa863463a97d20001996.6481527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    16
    		2025-04-07 00:00:00.000FOX0x21a42669643f45bc0e086b8fc2ed70c23d67509d64159.9992747121424.22173911527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    17
    		2025-04-07 00:00:00.000GIV0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e75721717.882571281527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    18
    		2025-04-07 00:00:00.000USDT0x4ecaba5870353805a9f068101a40e0f32ed605c60.0248230.024814609831527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    19
    		2025-04-07 00:00:00.000LINK0xe2e73a1c69ecf83f464efce6a5be353a37ca09b20.0012264999270.015404839081527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    20
    		2025-04-07 00:00:00.000USDC0xddafbb505ad214d7b80b1f830fccc89b60fb7a830.0060.0059918161527489.39012701715060.85385312601/01/20242025-04-27 00:00:00.000
    ...
    512
    86KB
    334s