SocioCryptoThorchain
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_trunc('day',block_timestamp) as date,
count(DISTINCT tx_id) as n_swaps,
COUNT(DISTINCT from_address) as n_swappers,
avg(from_amount_usd) as avg_amnt_usd,
sum(from_amount_usd) as amnt_usd,
count(DISTINCT pool_name) as n_active_pools
FROM thorchain.core.fact_swaps
WHERE date between CURRENT_DATE-366 AND CURRENT_DATE-1
GROUP BY date
ORDER BY date DESC
Run a query to Download Data