MostlyData_TVL by Active User
    Updated 2025-05-30
    with solana_daily_users as(
    select
    date_trunc('day', block_timestamp) as dt,
    'Solana' as tag,
    count(distinct signers[0]) as n_users

    from solana.core.fact_transactions

    where
    block_timestamp >= current_date() - interval '30 days'
    and block_timestamp < current_date()

    group by 1
    )

    ,ethereum_daily_users as(
    select
    date_trunc('day', block_timestamp) as dt,
    'Ethereum' as tag,
    count(distinct from_address) as n_users

    from ethereum.core.fact_transactions

    where
    block_timestamp >= current_date() - interval '30 days'
    and block_timestamp < current_date()

    group by 1,2
    )

    ,active_users as(
    select * from solana_daily_users
    union all
    select * from ethereum_daily_users
    )

    Last run: 10 days ago
    DT
    CHAIN
    TVL per Active User [USD]
    1
    2025-05-22 00:00:00.000Ethereum303712.12978
    2
    2025-05-21 00:00:00.000Ethereum283543.24081
    3
    2025-05-03 00:00:00.000Ethereum305972.457423
    4
    2025-05-28 00:00:00.000Ethereum306867.247123
    5
    2025-05-15 00:00:00.000Ethereum282904.214672
    6
    2025-05-24 00:00:00.000Ethereum342194.651234
    7
    2025-05-27 00:00:00.000Ethereum309478.421091
    8
    2025-05-07 00:00:00.000Ethereum256351.521023
    9
    2025-05-12 00:00:00.000Ethereum308121.939883
    10
    2025-05-26 00:00:00.000Ethereum313217.21045
    11
    2025-05-13 00:00:00.000Ethereum288476.215323
    12
    2025-05-08 00:00:00.000Ethereum219635.026722
    13
    2025-05-02 00:00:00.000Ethereum270329.353177
    14
    2025-05-06 00:00:00.000Ethereum259635.433135
    15
    2025-05-16 00:00:00.000Ethereum283655.889024
    16
    2025-05-29 00:00:00.000Ethereum309446.483691
    17
    2025-05-10 00:00:00.000Ethereum313915.181364
    18
    2025-05-17 00:00:00.000Ethereum253677.18108
    19
    2025-05-01 00:00:00.000Ethereum262966.317943
    20
    2025-05-25 00:00:00.000Ethereum363532.233475
    60
    3KB
    453s