roketa10
Updated 2022-12-01
9
1
2
3
4
5
6
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/0de71a5d-f9bf-4e8a-8e1c-e9862ab76560
select count(distinct TRADER) , sum(TO_AMOUNT/pow(10,6)) , avg(TO_AMOUNT/pow(10,6)),trunc(block_timestamp, 'DAY')
from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
on TO_CURRENCY=osmosis.core.dim_labels.address
where PROJECT_NAME ='AXL'
group by 4
Run a query to Download Data