VOLUME | AVG | SWAPPERS | SWAPS | |
|---|---|---|---|---|
1 | 773856.816370483 | 304.5481371 | 719 | 1728 |
0-MIDtotal
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select --BLOCK_TIMESTAMP::date as day
sum(FROM_AMOUNT_USD) as volume
,avg(FROM_AMOUNT_USD) as avg
,count(distinct FROM_ADDRESS) as swappers
,count(distinct TX_ID) as swaps
from thorchain.defi.fact_swaps
where AFFILIATE_ADDRESS='t'
and BLOCK_TIMESTAMP::date>=current_date-30
--group by 1
Last run: 6 days ago
1
41B
29s