ramishoowUntitled Query
Updated 2022-11-16
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day', block_timestamp)as "time",'swaps' , count(1) , count(distinct trader) from osmosis.core.fact_swaps
where date_trunc('day', block_timestamp) > current_date - interval '15 days' group by 1
UNION select date_trunc('day', block_timestamp)as "time",'transfer' , count(1) , count(distinct SENDER) from osmosis.core.fact_transfers
--UNION select date_trunc('day', block_timestamp)as "time",'transfer' , count(1) , count(distinct SENDER) from osmosis.core.fact_transfers
where date_trunc('day', block_timestamp) > current_date - interval '15 days' group by 1 UNION
select date_trunc('day', block_timestamp)as "time",'staking' , count(1) , count(distinct DELEGATOR_ADDRESS) from osmosis.core.fact_staking
where date_trunc('day', block_timestamp) > current_date - interval '15 days' and action in ('delegate','redelegate') group by 1
UNION select date_trunc('day', block_timestamp)as "time",'Unstaking' , count(1) , count(distinct DELEGATOR_ADDRESS) from osmosis.core.fact_staking
where date_trunc('day', block_timestamp) > current_date - interval '15 days' and action='undelegate' group by 1
Run a query to Download Data