Solana Received Over 1400 Orders For The Saga Web3 Smartphone

Solana has recently announced they are are working on a new Web3 mobile phone named Saga. They are working collaboration with crypto asset management OSOM and it is currently available for pre-order online. More about the Solana web3 phone mobile here.

According to Dune user aa007zz’s query on crypto analytics platform “Dune”, Solana has already registered over 1400 Smart Phone orders in just over 18 hours from when the announcement was made.

We can see that the line has already curbed and seems to be leveling out, unless media hype will add more fuel to this fire.

Here is the source code written by user aa007zz:

with data as (
    SELECT
        date_trunc('hour', block_time) as hour,
        count(case when array_contains(account_keys, '781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy') then id else null end) as SMS_orders
    FROM 
        solana.transactions
    WHERE 
        block_time > TIMESTAMP("2022-06-23") 
    AND 
        error is NULL
    AND 
        array_contains(account_keys, 'Vote111111111111111111111111111111111111111') = false 
    GROUP BY 1
)
SELECT
  hour,
  sum(SMS_orders) over (order by hour asc rows between unbounded preceding and current row) as orders
FROM 
  data