Transfer 1

Updated 2024-09-25

-- forked from Sei transfer @ https://flipsidecrypto.xyz/edit/queries/6b8f32b6-208f-4395-96c8-9aee675bf97c

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

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

count(distinct sender) as sender_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 - 30

and transfer_type = 'SEI'

and tx_succeeded = TRUE

-- group by 1

QueryRunArchived: QueryRun has been archived