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.

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
\
-
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.
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%.
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.
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.
\
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.