ramishoowUntitled Query
    Updated 2022-11-16
    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