MLDZMNstars 2
Updated 2022-05-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc('hour',BLOCK_TIMESTAMP) as hour,
count(distinct tx_id) as no_swaps
from osmosis.core.fact_msg_attributes
where MSG_TYPE='token_swapped'
and ATTRIBUTE_VALUE ilike '%ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4%'
and BLOCK_TIMESTAMP>='2022-05-20'
and (ATTRIBUTE_KEY='tokens_in' or ATTRIBUTE_KEY='tokens_out')
group by 1
Run a query to Download Data