DAY | SENDERS | RECEIVERS | |
|---|---|---|---|
1 | 2023-10-25 00:00:00.000 | 320 | 345 |
2 | 2023-10-26 00:00:00.000 | 435 | 476 |
3 | 2023-10-27 00:00:00.000 | 380 | 423 |
4 | 2023-10-28 00:00:00.000 | 390 | 397 |
5 | 2023-10-29 00:00:00.000 | 361 | 327 |
6 | 2023-10-30 00:00:00.000 | 438 | 443 |
7 | 2023-10-31 00:00:00.000 | 612 | 521 |
8 | 2023-11-01 00:00:00.000 | 562 | 526 |
9 | 2023-11-02 00:00:00.000 | 384 | 393 |
10 | 2023-11-03 00:00:00.000 | 551 | 546 |
11 | 2023-11-04 00:00:00.000 | 555 | 612 |
12 | 2023-11-05 00:00:00.000 | 486 | 461 |
13 | 2023-11-06 00:00:00.000 | 475 | 517 |
14 | 2023-11-07 00:00:00.000 | 455 | 456 |
15 | 2023-11-08 00:00:00.000 | 437 | 455 |
16 | 2023-11-09 00:00:00.000 | 797 | 695 |
17 | 2023-11-10 00:00:00.000 | 653 | 673 |
18 | 2023-11-11 00:00:00.000 | 1029 | 881 |
19 | 2023-11-12 00:00:00.000 | 1542 | 1268 |
20 | 2023-11-13 00:00:00.000 | 943 | 852 |
theericstonethorchain users copy
Updated 2024-01-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- forked from omer93 / thorchain users @ https://flipsidecrypto.xyz/omer93/q/usJjpkWAIYac/thorchain-users
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 '3 MONTHS'
group by 1 order by 1 asc
Last run: over 1 year ago
93
3KB
2s