-- forked from Sei transfer in @ https://flipsidecrypto.xyz/edit/queries/08f694d3-69a0-4148-98b3-4e523524bdb7

-- forked from Sei total @ https://flipsidecrypto.xyz/edit/queries/67424a90-5928-4cb6-a598-b36384a70339

-- forked from Sei daily @ https://flipsidecrypto.xyz/edit/queries/434baa2a-bf45-4869-8d24-0bf622b53eed

-- forked from Sei STPM @ https://flipsidecrypto.xyz/edit/queries/26ea51e2-c36e-4787-9959-150d1449ee8a

select date_trunc('hour', block_timestamp) as date,

-- sum(amount/1e6) as sei_amount,

count(distinct tx_id) as tx_count,

count(distinct receiver) as hourly_receivers,

count(distinct sender) as hourly_senders,

sum(tx_count) over (order by date) as cumu_tx

-- sum(sei_amount) over (order by date) as cumu_sei

-- sum(receiver_count) over (partition by from_chain order by date) as cumu_receiver

from sei.core.fact_transfers

where block_timestamp::date >= CURRENT_DATE - 2

and transfer_type = 'SEI'

and tx_succeeded = TRUE

group by 1