with a as (

select distinct tx_id

from sei.core.fact_msg_attributes

where (MSG_TYPE = 'wasm' and attribute_key='action' and attribute_value = 'claim')

),

tx_id as (

select distinct tx_id

from sei.core.fact_msg_attributes

where tx_id in (select tx_id from a)

and (attribute_key = 'amount' and msg_type = 'transfer' and right(ATTRIBUTE_VALUE,3) = 'sei')

select hour, sei_claimed,

sum(sei_claimed) over (order by hour) as cumulative_claimed,

claimers,

sum(claimers) over (order by hour) as cumulative_claimers

from (

select date_trunc('hour',block_timestamp) as hour, sum(cast(attribute_value as double)/1e6) as sei_claimed, count(*) as claimers

from sei.core.fact_msg_attributes

where tx_id in (select tx_id from tx_id)

and attribute_key = 'amount'

and msg_type = 'wasm'

group by 1)a

order by 1 desc