DATE | NEW_CONTRACTS | TOTAL_CONTRACTS | |
|---|---|---|---|
1 | 2025-04-06 00:00:00.000 | 56 | 24619 |
2 | 2025-04-05 00:00:00.000 | 239 | 24563 |
3 | 2025-04-04 00:00:00.000 | 203 | 24324 |
4 | 2025-04-03 00:00:00.000 | 327 | 24121 |
5 | 2025-04-02 00:00:00.000 | 412 | 23794 |
6 | 2025-04-01 00:00:00.000 | 824 | 23382 |
7 | 2025-03-31 00:00:00.000 | 723 | 22558 |
8 | 2025-03-30 00:00:00.000 | 502 | 21835 |
9 | 2025-03-29 00:00:00.000 | 66 | 21333 |
10 | 2025-03-28 00:00:00.000 | 73 | 21267 |
11 | 2025-03-27 00:00:00.000 | 127 | 21194 |
12 | 2025-03-26 00:00:00.000 | 125 | 21067 |
13 | 2025-03-25 00:00:00.000 | 65 | 20942 |
14 | 2025-03-24 00:00:00.000 | 58 | 20877 |
15 | 2025-03-23 00:00:00.000 | 61 | 20819 |
16 | 2025-03-22 00:00:00.000 | 27 | 20758 |
17 | 2025-03-21 00:00:00.000 | 49 | 20731 |
18 | 2025-03-20 00:00:00.000 | 68 | 20682 |
19 | 2025-03-19 00:00:00.000 | 59 | 20614 |
20 | 2025-03-18 00:00:00.000 | 65 | 20555 |
maybeyonasnew_contracts
Updated 8 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- forked from new_wallet @ https://flipsidecrypto.xyz/studio/queries/cd4c8520-3c96-447c-8f1f-577bf0127405
with
first_time as (
select
to_address,
min(block_timestamp) as first_time
from swell.core.fact_traces
group by 1
),
daily_new as (
select
date_trunc('day', first_time) as date,
count(distinct to_address) as new_contracts,
sum(new_contracts) over(order by date) as total_contracts
from first_time
group by 1
)
select * from daily_new
order by 1 desc
Last run: about 8 hours ago
...
129
5KB
1s