nitsSwaps to THOR
Updated 2022-05-31
9
1
2
3
4
5
6
7
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,avg(total_txs) over (order by day) as avg_txs,
sum(to_amount) as vol,avg(vol) over (order by day) as avg_vol,
sum(to_amount_usd) as vol_usd,avg(vol_usd) over (order by day) as avg_vol_usd
from thorchain.swaps
where to_asset = 'ETH.THOR-0XA5F2211B9B8170F694421F2046281775E8468044' and block_timestamp >= '2022-04-01'
GROUP by 1
limit 100
Run a query to Download Data