Afonso_Diazswaps overtime
    Updated 2023-12-31
    with t as (
    select
    tx_hash,
    block_timestamp,
    iff(block_timestamp::date >= '2023-08-27', 'Bull Market', 'Bear Market') as timespan,
    sender as user,
    abs(amount0_usd) as amount_usd
    from
    ethereum.uniswapv3.ez_swaps
    where amount_usd < 1e7
    ),
    t2 as (
    select
    date_trunc('month', min_date) as month,
    count(distinct user) as new_user
    from
    (
    select
    user,
    min(block_timestamp) as min_date
    from
    t
    group by
    1
    )
    group by
    1
    ),
    t3 as (
    select
    date_trunc('month', block_timestamp) as month,
    timespan,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users,
    sum(amount_usd) as volume,
    avg(amount_usd) as avg_volume
    QueryRunArchived: QueryRun has been archived