30 Days Volume $ | 7 Days Volume $ | 24 Hours Volume $ | |
|---|---|---|---|
1 | 3198703326.10783 | 588174973.501206 | 132700353.008443 |
BlockTrackeroverview
Updated 2025-06-13
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
30
31
32
33
34
›
⌄
with one_month_volume as (
select
sum(case when from_amount_usd < to_amount_usd then from_amount_usd else to_amount_usd end) as one_month_volume
from thorchain.defi.fact_swaps
where block_timestamp::date > current_date - interval '1 month'
)
,
sevent_days_volume as (
select
sum(case when from_amount_usd < to_amount_usd then from_amount_usd else to_amount_usd end) as one_week_volume
from thorchain.defi.fact_swaps
where block_timestamp::date > current_date - interval '1 week'
)
,
one_day_volume as (
select
sum(case when from_amount_usd < to_amount_usd then from_amount_usd else to_amount_usd end) as one_day_volume
from thorchain.defi.fact_swaps
where block_timestamp > current_timestamp - interval '24 Hours'
-- and block_timestamp::date > current_date - interval '1 day'
)
select
one_month_volume as "30 Days Volume $",
one_week_volume as "7 Days Volume $",
one_day_volume as "24 Hours Volume $"
from one_month_volume a
left join sevent_days_volume b ON TRUE
left join one_day_volume c ON TRUE
Last run: 17 days ago
1
54B
4s