Sandeshnumber of swaps before after
Updated 2022-10-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
block_timestamp::date as "date",
count(distinct tx_id) as number_of_transactions,
case
when "date" < '2022-09-26' then 'before cosmoverse'
else 'after cosmerverse'
end as event
from osmosis.core.fact_swaps
where 1=1
and "date" > '2022-09-12'
and (to_currency='ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4'
or from_currency='ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4' )
group by "date"
Run a query to Download Data