AmiRNew swappers
    Updated 2024-10-16
    with t1 as
    (SELECT ORIGIN_FROM_ADDRESS as swapper,
    min(block_timestamp::date) as date
    from blast.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP>=current_date-60 and platform='thruster-v3'
    GROUP by 1)
    SELECT date,
    count(DISTINCT swapper) as New_swappers
    from t1
    where date >= current_date - 60
    group by 1 ORDER by 1


    Last run: 3 months ago
    DATE
    NEW_SWAPPERS
    1
    2024-08-17 00:00:00.0001287
    2
    2024-08-18 00:00:00.000950
    3
    2024-08-19 00:00:00.000925
    4
    2024-08-20 00:00:00.000888
    5
    2024-08-21 00:00:00.000832
    6
    2024-08-22 00:00:00.0001459
    7
    2024-08-23 00:00:00.000855
    8
    2024-08-24 00:00:00.000747
    9
    2024-08-25 00:00:00.000708
    10
    2024-08-26 00:00:00.000885
    11
    2024-08-27 00:00:00.000641
    12
    2024-08-28 00:00:00.000685
    13
    2024-08-29 00:00:00.000602
    14
    2024-08-30 00:00:00.000530
    15
    2024-08-31 00:00:00.000737
    16
    2024-09-01 00:00:00.000484
    17
    2024-09-02 00:00:00.000578
    18
    2024-09-03 00:00:00.000514
    19
    2024-09-04 00:00:00.000604
    20
    2024-09-05 00:00:00.000509
    61
    2KB
    10s