Updated 2022-11-13
9
1
2
3
4
›
⌄
select count(*), sum(AMOUNT/DECIMAL) , count(distinct SENDER) , count(distinct RECEIVER) ,to_date(block_timestamp) from osmosis.core.fact_transfers
where TX_STATUS='SUCCEEDED' and to_date(block_timestamp) > '2022-11-01' and to_date(block_timestamp)!=CURRENT_DATE
group by to_date(block_timestamp)
Run a query to Download Data