warriorDaily NFT swap volume
Updated 2022-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with swap_overtime as (select
date_trunc('day', BLOCK_TIMESTAMP) as swapdate
,sum(replace(split(ATTRIBUTE_VALUE::string,'/')[0],'ibc','')/pow(10,6)) as quantity
from osmosis.core.fact_msg_attributes
where
MSG_TYPE='token_swapped'
and ATTRIBUTE_VALUE like '%987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4%'
and swapdate >= '2022-03-20'
group by 1 )
,swap_friday as (select
hour(BLOCK_TIMESTAMP) as swaphour
,sum(replace(split(ATTRIBUTE_VALUE::string,'/')[0],'ibc','')/pow(10,6)) as quantity
from osmosis.core.fact_msg_attributes
where
MSG_TYPE='token_swapped'
and ATTRIBUTE_VALUE like '%987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4%'
and date_trunc('day', BLOCK_TIMESTAMP)
in ('2022-03-25','2022-04-01','2022-04-08','2022-04-15','2022-04-22','2022-04-29','2022-05-06','2022-05-13','2022-05-20')
group by 1)
select * from swap_overtime
Run a query to Download Data