DATE | VOLUME | AFFILIATE_VOLUME | N_SWAPS | AVG_VOLUME_PER_TXNS | N_SWAPPERS | AVG_VOLUME_PER_WALLET | AVG_DAILY_VOLUME | LIQUIDITY_FEE | AFFILIATE_FEE | N_NEW_USER | Bond Earning | Pool & Dev Earning | VOLUME_GROWTH | AFFILIATE_VOLUME_GROWTH | AFFILIATE_FEE_GROWTH | SWAPS_GROWTH | SWAPPERS_GROWTH | LIQUIDITY_FEE_GROWTH | NEW_USER_GROWTH | BOND_EARING_GROWTH | POOLS_EARING_GROWTH | AVG_VOLUME_PER_TXNS_GROWTH | AVG_VOLUME_PER_WALLET_GROWTH | AVG_DAILY_VOLUME_GROWTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | 55182284424.2347 | 5279211073.39546 | 10285202 | 5365.211536364 | 367841 | 150016.676836554 | 151184340.888314 | 30597028.7579634 | 19669173.3120764 | 350137 | 39902162 | 42544151 | 205.334834629 | 204.079566661 | 745.552078689 | 48.18474 | 63.816891 | 120.912104091 | 62.377858 | 151.469152551 | 103.097691868 | 106.050119793 | 86.387882555 | 205.334834629 |
BlockTrackertotal
Updated 2025-05-07
999
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
35
36
›
⌄
with main as (
select
date_trunc('year', block_timestamp) as date,
sum(coalesce(from_amount_usd, to_amount_usd)) as volume,
count(DISTINCT tx_id) as n_swaps,
count(DISTINCT from_address) as n_swappers ,
sum(liq_fee_rune_usd) as liquidity_fee
from thorchain.defi.fact_swaps
where tx_id not in (select tx_id from thorchain.defi.fact_refund_events)
group by 1
)
,
new_wallet as (
select
date_trunc('year', first_tx) as date,
count(DISTINCT from_address) as n_new_user
from (
select
from_address,
min(block_timestamp) as first_tx
from thorchain.defi.fact_swaps
group by 1
)
group by 1
)
,
affiliate_volume as (
with pools_count as (
select
tx_id,
count(DISTINCT pool_name) as n_pools
from thorchain.defi.fact_swaps
where tx_id not in (select tx_id from thorchain.defi.fact_refund_events)
group by 1
)
select
Last run: about 1 month ago
1
341B
93s