warriorgem7
Updated 2023-06-09
9
1
2
3
4
5
›
⌄
select count(distinct TRADER) , sum(FROM_AMOUNT/pow(10,6)) , avg(FROM_AMOUNT/pow(10,6)),trunc(block_timestamp, 'DAY')
from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
on FROM_CURRENCY=osmosis.core.dim_labels.address
where PROJECT_NAME ='ATOM'
group by 4
Run a query to Download Data