Moe--
    Updated 2025-06-30
    WITH raw_tb as (
    select
    BLOCK_TIMESTAMP,
    AMOUNT_USD,
    TX_HASH,
    TRADER as proposer
    from
    arbitrum.vertex.ez_perp_trades
    where is_taker = TRUE
    union
    all
    select
    BLOCK_TIMESTAMP,
    AMOUNT_USD,
    TX_HASH,
    TRADER as proposer
    from
    arbitrum.vertex.ez_spot_trades
    where is_taker = TRUE
    ),
    daus as (
    SELECT
    distinct proposer as users,
    trunc(block_timestamp, 'week') as weeks,
    count(distinct trunc(block_timestamp, 'day')) as active_days
    from
    raw_tb
    group by
    1,
    2
    having
    active_days >= 4
    ),
    active_users as (
    SELECT
    trunc(block_timestamp, 'week') as date,
    Last run: 14 days ago
    DATE
    TYPE
    USD_AMT
    AVG_USD_AMT
    N_USERS
    TXS
    TX_PER_USER
    1
    2023-03-06 00:00:00.000Other569.825885924189.941961975221
    2
    2023-03-06 00:00:00.000DAU11144.997913519218.529370853231.5
    3
    2023-03-20 00:00:00.000DAU523.6432354174.547745133111
    4
    2023-03-20 00:00:00.000Other182.371469294182.371469294111
    5
    2023-04-03 00:00:00.000Other1194.671110783238.934222157221
    6
    2023-04-03 00:00:00.000DAU1190.510937739238.102187548341.333333
    7
    2023-04-10 00:00:00.000DAU2408635.47683205775.977924237591612.728814
    8
    2023-04-10 00:00:00.000Other385694.882700681603.591365729791351.708861
    9
    2023-04-17 00:00:00.000DAU417371.2857299491084.08126163618663.666667
    10
    2023-04-17 00:00:00.000Other33700.237464484612.73159026329361.241379
    11
    2023-04-24 00:00:00.000DAU51607413.4552093122.6122983731058057.666667
    12
    2023-04-24 00:00:00.000Other22527119.19810615177.4578713182324882.103448
    13
    2023-05-01 00:00:00.000Other25372763.47296134134.3919623531663922.361446
    14
    2023-05-01 00:00:00.000DAU119114363.2717354210.6247400661257085.664
    15
    2023-05-08 00:00:00.000DAU217412372.3163563298.675026421142156311.007042
    16
    2023-05-08 00:00:00.000Other16510590.30096484165.1337792541123393.026786
    17
    2023-05-15 00:00:00.000Other47419868.05746895271.2169917153267522.306748
    18
    2023-05-15 00:00:00.000DAU158712108.2247775224.23002714915515349.896774
    19
    2023-05-22 00:00:00.000Other12373358.77572643593.7725169122415722.373444
    20
    2023-05-22 00:00:00.000DAU263496675.9136846265.37654350618416328.869565
    ...
    240
    20KB
    48s