elsina2024-10-05: daily activity per user
    Updated 2024-12-21
    with users as (
    SELECT
    date_trunc('day', block_timestamp) as date,
    from_address,
    count(DISTINCT tx_id) as tx_count,
    sum(from_amount_usd) as total_vol,
    FROM
    thorchain.defi.fact_swaps
    WHERE
    date between '2024-01-01' and '2024-12-31'
    GROUP BY
    date, from_address
    )

    select
    date,
    avg(tx_count) as avg_tx_count_per_user,
    avg(total_vol) as avg_tot_vol_per_user,
    from
    users
    group by
    date
    order by
    date asc




    Last run: about 2 months ago
    DATE
    AVG_TX_COUNT_PER_USER
    AVG_TOT_VOL_PER_USER
    1
    2024-01-01 00:00:00.00020.0631488455.554841004
    2
    2024-01-02 00:00:00.00024.131082136155.461812055
    3
    2024-01-03 00:00:00.00035.812332196242.55684383
    4
    2024-01-04 00:00:00.00020.23877682282.805003259
    5
    2024-01-05 00:00:00.00021.47141882898.2022715
    6
    2024-01-06 00:00:00.00022.784019120922.12492756
    7
    2024-01-07 00:00:00.00024.222425122579.304827167
    8
    2024-01-08 00:00:00.00042.643093252758.221240242
    9
    2024-01-09 00:00:00.00027.640695124851.414555296
    10
    2024-01-10 00:00:00.00030.775888162772.483036485
    11
    2024-01-11 00:00:00.00025.982684128370.358523044
    12
    2024-01-12 00:00:00.00032.981602161680.426381557
    13
    2024-01-13 00:00:00.00032.005727177063.170373753
    14
    2024-01-14 00:00:00.00027.993805134336.003720543
    15
    2024-01-15 00:00:00.00022.56671874431.824740159
    16
    2024-01-16 00:00:00.00023.8747984612.121853265
    17
    2024-01-17 00:00:00.00023.20371995091.874990276
    18
    2024-01-18 00:00:00.00032.798673123096.300852763
    19
    2024-01-19 00:00:00.00037.097243185838.361079356
    20
    2024-01-20 00:00:00.00019.63246492564.506788753
    ...
    356
    19KB
    7s