roketa18
Updated 2022-12-01
9
1
2
3
4
5
6
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/e0c597d4-2b05-43c4-af52-11264246bfb8
select count(distinct SENDER) , count(distinct RECEIVER) , sum(AMOUNT/pow(10,6)) , avg(AMOUNT/pow(10,6)) ,trunc(block_timestamp, 'DAY')
from osmosis.core.fact_transfers inner join osmosis.core.dim_labels
on CURRENCY=osmosis.core.dim_labels.address
where PROJECT_NAME ='AXL'
group by 5
Run a query to Download Data