warriorDaily NFT swap volume
    Updated 2022-05-28
    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