AI stands for Artificial Intelligence, a branch of computer science that focuses on developing intelligent machines that can perform tasks that typically require human-like intelligence. AI involves using algorithms, data, and statistical models to make predictions, learn from data, and improve performance over time.

In the context of cryptocurrency, AI can be used in several ways:

1. Price Prediction: AI can analyze historical cryptocurrency price data and other relevant data sources to predict future price movements. This can help traders make more informed decisions about when to buy and sell cryptocurrencies.
2. Fraud Detection: AI can be used to detect fraudulent activities in cryptocurrency transactions, such as fake ICOs or Ponzi schemes.
3. Portfolio Optimization: AI can help investors optimize their cryptocurrency portfolio by analyzing various factors such as risk, volatility, and correlation between different cryptocurrencies.
4. Sentiment Analysis: AI can analyze social media and news sources to gauge public sentiment about specific cryptocurrencies. This can help traders make decisions based on market sentiment.

Overall, AI can be a valuable tool for investors and traders in the cryptocurrency market, as it can provide insights and analysis that are difficult or impossible to obtain through traditional methods.

This dashboard retrieves data from the near.core.fact_prices table for the cryptocurrency wNEAR. It selects data only for timestamps on or after 2023-02-06. The timestamp is truncated to the nearest day using the trunc(TIMESTAMP, 'day') function, and the resulting day is used to group the data. For each group, the average price of wNEAR is calculated using the avg(price_usd) function.

The case statement creates a new column called type, which is used to distinguish between "daily" data points and a special "AI Tweet" data point. The "AI Tweet" data point is calculated only for 2023-02-08, and all other data points are considered "daily" data points.

The resulting data is grouped by the truncated day and the type column. The resulting output includes the truncated day, the type column, and the average price of wNEAR for each group.

Price Changes

According to the information provided, the price of NEAR cryptocurrency experienced a significant increase following a tweet from the official Near Twitter account about AI. Specifically, the price increased from $2.35 to $2.61 USD immediately after the tweet. However, the following day the price of NEAR decreased to $2.47 USD.

Daily Overview

Stake and Unstake

Transfer

Based on the provided information, it appears that the highest number of transactions for NEAR cryptocurrency occurred on February 8th, which coincided with a tweet from the official Near Twitter account about AI. On this day, the total number of transactions was approximately 475k. The total number of transactions on February 7th, the day before the AI tweet, was 407.9k, while on the day after the tweet, February 9th, the total number of transactions was 437.5k. Overall, the average number of transactions was highest on the day of the AI tweet, with approximately 475.2k transactions. Before the AI tweet, the average number of transactions was around 399k, and after the AI tweet, the average number of transactions was around 386k.

The highest number of users who had transactions on NEAR cryptocurrency occurred on February 13th, which is after the AI tweet. On this day, the total number of users was approximately 79.5k. On the day of the AI tweet, the total number of users who had transactions was 73.4k.

Overall, the average number of users who had transactions on NEAR cryptocurrency was highest on the day of the AI tweet, with approximately 73.4k users. Before the AI tweet, the average number of users was around 61.6k, and after the AI tweet, the average number of users was around 64.3k.

According to the information provided, NEAR users used the highest number of contracts on February 16th, with a total of 34.95k contracts. This indicates that there was a significant increase in the usage of NEAR contracts on this day.

Moreover, the average number of contracts used during the AI tweet was the highest, with approximately 27.45k contracts. This suggests that the announcement of the AI tweet may have played a role in increasing the usage of NEAR contracts.

Transactions count

Users count

Contracts count

Senders count

Transactions count

The highest amount of NEAR tokens transferred by users was on February 8th, which coincides with the day of the AI tweet, with a total of 31.2 million NEAR tokens being transferred. Additionally, the average amount of NEAR tokens transferred by users on this day was also the highest, further indicating a significant increase in token transfer activity during this period.

Near amount

Based on the provided information, it appears that the total number of transfer transactions on NEAR cryptocurrency was the highest on February 8th, which was the day of the AI tweet. Specifically, the total number of transfer transactions on that day was 464.7k, indicating a significant increase from the previous day's number of 399.3k. Although the number of transactions on the day after the tweet was still high at 428.7k, it was lower than the number of transactions on the AI tweet day.

Moreover, the average number of transfer transactions on NEAR cryptocurrency was the highest during the AI tweet day, which further suggests that the announcement of the AI tweet may have played a role in increasing the number of transfer transactions on NEAR.

Based on the provided information, it appears that the highest number of senders on NEAR cryptocurrency was on February 13th, with a total of 76.5k users having transfer transactions. On the day of the AI tweet, the number of senders was slightly lower at 69.8k users having transfer transactions.

The highest number of stake and unstake transactions on the NEAR cryptocurrency occurred on February 21, with a total of 580 transactions. On the day of the AI tweet, the number of stake and unstake transactions was 442.

Additionally, the average number of stake transactions was the most during the period before the AI tweet, with an average of 444.3 transactions. On the other hand, the average number of unstake transactions was the most on the AI tweet day, with an average of 233 transactions.

The highest amount of Near used to make stake and unstake transactions was on February 18th, with a total of 29.7 million Near tokens. Additionally, the average amount of Near that had been staked was the most during the period after the AI tweet, while the average amount of Near that had been unstaked was the most during the AI tweet day (February 8th).

\n

Based on the data provided, it appears that the AI tweet from Near's official Twitter account on February 8th had a significant impact on various aspects of the NEAR cryptocurrency ecosystem.

On the day of the tweet, there was a noticeable increase in the number of transactions, number of users, and Near amounts transferred. However, it's worth noting that other factors, such as market conditions and general interest in cryptocurrencies, could also have influenced these metrics.

Additionally, the data suggests that different metrics had their highest values at different times. For example, the highest number of transfer transactions occurred on February 8th, while the highest number of senders and Near amounts transferred occurred on February 13th.

AI is a trend these days due to advancements in technology, availability of big data, automation benefits, personalization capabilities, business advantages, and growing interest from individuals and organizations. AI has the potential to transform industries and improve our daily lives, which is driving the trend.

So I chose this as a topic for my Insight of the week dashboard.