DATE | COUNT(DISTINCT DESTINATION) | |
|---|---|---|
1 | 2024-10-23 00:00:00.000 | 813678 |
2 | 2024-10-14 00:00:00.000 | 871493 |
3 | 2024-06-25 00:00:00.000 | 365321 |
4 | 2024-12-07 00:00:00.000 | 480112 |
5 | 2024-04-26 00:00:00.000 | 149334 |
6 | 2024-03-11 00:00:00.000 | 46473 |
7 | 2024-04-20 00:00:00.000 | 145320 |
8 | 2024-01-01 00:00:00.000 | 16158 |
9 | 2024-10-26 00:00:00.000 | 828684 |
10 | 2025-03-12 00:00:00.000 | 194561 |
11 | 2024-12-29 00:00:00.000 | 332132 |
12 | 2024-12-24 00:00:00.000 | 436510 |
13 | 2025-02-21 00:00:00.000 | 202265 |
14 | 2025-02-03 00:00:00.000 | 334507 |
15 | 2024-03-29 00:00:00.000 | 216949 |
16 | 2024-03-10 00:00:00.000 | 44957 |
17 | 2024-10-30 00:00:00.000 | 699329 |
18 | 2024-10-09 00:00:00.000 | 626403 |
19 | 2024-09-14 00:00:00.000 | 1292642 |
20 | 2024-12-26 00:00:00.000 | 523393 |
SajjadiiiQuery another Query (Dune) copy
Updated 2025-04-21
9
1
2
3
4
5
6
7
8
9
›
⌄
select block_timestamp::Date as date ,
count(distinct DESTINATION)
from ton.core.fact_messages
where SOURCE is null
group by 1
--DESTINATION = upper('0:d937ed8d5a2ca41f78402f8d8271cb39fb8a63cfcdf213f56eca9048e5059193')
Last run: about 2 months ago
...
476
16KB
58s