Afonso_DiazAnomaly Detection
    Updated 2025-02-14
    with main as (
    select
    tx_hash,
    amount_usd
    from ronin.core.ez_token_transfers
    where origin_to_address = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'
    ),
    stats as (
    select
    avg(amount_usd) as avg_usd,
    stddev(amount_usd) as stddev_usd
    from main
    )
    select
    tx_hash,
    amount_usd
    from main, stats
    where amount_usd > avg_usd + 3 * stddev_usd
    order by amount_usd desc
    QueryRunArchived: QueryRun has been archived