flipside

    polygon new users
    messaripolygon new users
    Updated 2024-02-15
    select
    date(block_timestamp) as date,
    count(*) as tots,
    count(DISTINCT from_address) as senders
    from
    polygon.core.fact_transactions
    where
    nonce = 0
    and date >= date('2020-05-30')
    and date <= date('2020-11-12')
    group by
    1
    order by
    date desc
    limit
    100;
    Last run: about 1 year ago
    DATE
    TOTS
    SENDERS
    1
    		2020-11-12 00:00:00.00019772
    2
    		2020-11-11 00:00:00.00021275
    3
    		2020-11-10 00:00:00.000357157
    4
    		2020-11-09 00:00:00.000409229
    5
    		2020-11-08 00:00:00.000299160
    6
    		2020-11-07 00:00:00.00019460
    7
    		2020-11-06 00:00:00.00029769
    8
    		2020-11-05 00:00:00.00032384
    9
    		2020-11-04 00:00:00.000517102
    10
    		2020-11-03 00:00:00.000487122
    11
    		2020-11-02 00:00:00.000332117
    12
    		2020-11-01 00:00:00.000264104
    13
    		2020-10-31 00:00:00.00022695
    14
    		2020-10-30 00:00:00.000326118
    15
    		2020-10-29 00:00:00.000238104
    16
    		2020-10-28 00:00:00.000266106
    17
    		2020-10-27 00:00:00.000309166
    18
    		2020-10-26 00:00:00.00020488
    19
    		2020-10-25 00:00:00.000255123
    20
    		2020-10-24 00:00:00.000255122
    100
    3KB
    1s