-- forked from Sei transfer Out @ https://flipsidecrypto.xyz/edit/queries/c9c79ec7-0f37-4375-a385-8c5dbec0a65b

-- 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

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

case when amount/1e6 < 100 then 'SEI < 100'

when amount/1e6 < 1000 then '100 < SEI < 1k'

when amount/1e6 < 10000 then '1k < SEI < 10k'

when amount/1e6 < 100000 then '10k < SEI < 100k'

when amount/1e6 >= 100000 then 'SEI > 100k'

end as type,

sum(amount/1e6) as sei_amount,

count(distinct tx_id) as tx_count

-- count(distinct receiver) as receiver_count,

-- 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

order by tx_count desc