Seasons in the City

    It’s autumn in the Northern Hemisphere. What season is it in the City of NEAR? Pick one of the districts from the NEAR Tournament and review how activity there has changed over the past 90 days. What has changed? What trends can you spot? Is it truly “winter” in your chosen “district” or area (NFTs, DeFi, etc.)?

    What Is Near Protocol and How Does It Work?

    Near Protocol is a layer 1 blockchain network. It provides a platform on which developers can build decentralized applications (dapps). The most successful layer 1 blockchain is Ethereum, so protocols like Near are seen as challengers.

    The key yardsticks for layer 1 networks are transaction costs, speed and the ability to maintain those features as transaction volumes grow. These factors are the focus for layer 1s like Near to improve upon Ethereum, which has encountered issues with costs and speed over the last few years.

    Near Protocol is faster and cheaper than Ethereum. More importantly, it promises to be faster than some of the other largest challengers. When fully implemented, Near is expected to be able to process up to around 100,000 transactions per second (TPS). Ethereum’s largest rival, Solana, averages less than 3,000 transactions per second, according to its own blockchain explorer. Ethereum averages double-digit transactions per second. Bitcoin does less than 10.

    Source

    db_img

    Methodology

     block_timestamp::date as date , 
      count(distinct trader) as total_swapper ,
        sum(total_swapper) over (order by date asc) as cumulative_swapper,
      platform
      from near.core.ez_dex_swaps
      where date > CURRENT_DATE - 90
    
     count(distinct tx_hash) as total_transaction,
      sum(total_transaction) over (order by date asc) as cumulative_transaction,
      count(distinct tx_signer) as total_user,
        sum(total_user) over (order by date asc) as cumulative_user
      from 
      near.core.fact_transactions
    
    tx_receiver in ('v2.perp.spin-fi.near','spot.spin-fi.near','boostfarm.ref-labs.near','staking.v1.pembrock.near',
      'token.v2.ref-finance.near','near','meta-pool.near','contract.main.burrow.near','v1.jumbo_exchange.near','claiming-v1.jumbo_exchange.near',
      'linear-protocol.near','token.jumbo_exchange.near','farming-v1.jumbo_exchange.near','v2-nearx.stader-labs.near',
      'nearx.stader-labs.near','v1.pembrock.near','rewards.v1.pembrock.near','v3.oin_finance.near','ref-finance.sputnik-dao.near','nearx-price-feed.stader-labs.near','xtoken.ref-finance.near')
    

    Total Swapper

    Conclusion

    • The highest number of swapper was 30 on July 25th and July 30th.
    • The highest number of transaction was 1.9M on August 20th.
    • The highest number of user was 183K on September 14th.
    • The most Stake Amount was 2.704371102307271e+31 on August 31st.
    • The most unstake Amount was 4.620427054940975e+30 on August 17th.
    • The highest number of wallet was 5.7M on October 4th.
    • claiming-v1.jumbo_exchange.near with about 8.1K users was the first DEX and consisted of 39.8%.

    Twitter : hadi3_bgh

    Discord : hadiseb#1688

    Loading...
    Loading...
    Loading...
    Loading...

    \

    • The highest number of swapper was 30 on July 25th and July 30th.

    • .The lowest number of swapper was 16 on October 9th.

    • The highest number of swapper on v1 was 6 on August 23rd

      and August 25th.

    • The highest number of swapper on v2 was 25 on July 25th.

    • The total number of swapper on V1 was 6 and consisted of 87.2%.

    • The total number of swapper on V2 was 22 and consisted of 12.8%.

    Total Transaction

    • The highest number of transaction was 1.9M on August 20th.
    • The total number of transaction had huge growth on August 20th.
    • In the second place, The highest number of transaction was 1.5M on August 21st.
    • The lowest number of transaction was 225K on July 21st.
    Loading...
    Loading...

    Top DEX based on use

    • claiming-v1.jumbo_exchange.near with about 8.1K users was in the first place and consisted of 39.8%.
    • boostfarm.ref-labs.near was in the second place with about 5.4K users and consisted of 26.7%.
    • ref-finance.sputnik-dao.near with only 51 users was in the last place and consisted 0.2%.
    Loading...
    Loading...

    Total Near User

    • The highest number of user was 183K on September 14th.
    • The total number of user had huge growth on September 13th.
    • In the second place, The highest number of user was 142K September 13th.
    • The lowest number of user was 8.1K on August 28th.
    Loading...
    Loading...

    Total Stake Amount

    • The most Stake Amount was 2.704371102307271e+31 on August 31st.

    • The total stake amount had huge growth on August 31st.

    • In the second place, The most Stake Amount was 6.031618525585463e+30 October 7th.

      \

    Loading...
    Loading...
    Loading...
    Loading...

    Total Stake Amount

    • The most unstake Amount was 4.620427054940975e+30 on August 17th.

    • The total stake amount had huge growth on August 17th.

    • In the second place, The most Stake Amount was 2.0024358678679305e+30 September 15th.

      \

    Active wallet on Near

    • The highest number of wallet was 5.7M on October 4th.
    • The total number of wallet had huge growth on October 2nd and October 3rd.
    • In the second place, The highest number of wallet was 5.5M October 6th.
    • The lowest number of wallet was 71 on October 19th.
    Loading...
    Loading...