DAY | SENDERS | RECEIVERS | |
|---|---|---|---|
1 | 2024-01-02 00:00:00.000 | 396 | 440 |
2 | 2024-01-03 00:00:00.000 | 386 | 456 |
3 | 2024-01-04 00:00:00.000 | 347 | 423 |
4 | 2024-01-05 00:00:00.000 | 311 | 353 |
5 | 2024-01-06 00:00:00.000 | 259 | 339 |
6 | 2024-01-07 00:00:00.000 | 254 | 318 |
7 | 2024-01-08 00:00:00.000 | 354 | 468 |
8 | 2024-01-09 00:00:00.000 | 288 | 323 |
9 | 2024-01-10 00:00:00.000 | 316 | 463 |
10 | 2024-01-11 00:00:00.000 | 369 | 405 |
11 | 2024-01-12 00:00:00.000 | 339 | 488 |
12 | 2024-01-13 00:00:00.000 | 268 | 414 |
13 | 2024-01-14 00:00:00.000 | 268 | 351 |
14 | 2024-01-15 00:00:00.000 | 310 | 369 |
15 | 2024-01-16 00:00:00.000 | 260 | 359 |
16 | 2024-01-17 00:00:00.000 | 324 | 328 |
17 | 2024-01-18 00:00:00.000 | 513 | 521 |
18 | 2024-01-19 00:00:00.000 | 328 | 429 |
19 | 2024-01-20 00:00:00.000 | 305 | 346 |
20 | 2024-01-21 00:00:00.000 | 267 | 317 |
omer93thorchain users
Updated 2024-02-02
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc('day',_INSERTED_TIMESTAMP) as day,
count(distinct from_address) as senders,
count(distinct to_address) as receivers
from thorchain.core.fact_transfer_events
where _INSERTED_TIMESTAMP>=current_date-INTERVAL '1 MONTH'
and _INSERTED_TIMESTAMP<current_date
group by 1 order by 1 asc
Last run: about 1 year ago
31
1KB
2s