USERS | AMOUNT | TXS | MIN_DATE | MAX_DATE | |
|---|---|---|---|---|---|
1 | 16748 | 1005609.949053 | 32535 | 2024-12-08 08:04:34.000 | 2025-01-17 08:02:54.000 |
mamad-5XN3k3Astrol
Updated 2025-01-17
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
25
26
27
28
29
›
⌄
select
count(distinct user) as users,
sum(am) as amount,
count(distinct hash) as txs,
min(date) as min_date,
max(date) as max_date
from(
select
TX_TO as user,
-1*AMOUNT/pow(10,6) as am,
TX_ID as hash,
BLOCK_TIMESTAMP as date
from eclipse.core.fact_transfers
where TX_FROM = 'JBUYTVaQAvp61GKnbgooEEzyTsevG1x5fYDnGoDD2soT'
and SUCCEEDED = 'TRUE'
UNION
select
TX_FROM as user,
AMOUNT/pow(10,6) as am,
TX_ID as hash,
BLOCK_TIMESTAMP as date
from eclipse.core.fact_transfers
where TX_TO = 'JBUYTVaQAvp61GKnbgooEEzyTsevG1x5fYDnGoDD2soT'
and SUCCEEDED = 'TRUE'
--or TX_FROM = 'GkqE1ys4HAciAZK2y66eDkBGpqCZqbm8niy5v3m3GrKE'
)
group by 1
Last run: about 2 months ago
1
82B
4s