Introduction

What is Near Social?

Near Social is Decentralized Composable Frontends and Social Data Protocol for NEAR. The platform enables users to create profiles, follow and interact with other users, create and join communities, and share content such as text, images, and videos.

In essence, NEAR Social offers a new platform for innovation, with widgets that can be combined, forked and created by anyone. Users own their data and developers can easily access public data to create their own apps.

Method

The dashboard includes 3 sections Social, Swap and Balance.

There are date range parameters that the user can select, the time period of the new near.social users and it affects these 3 sections.

I got the new users from table 'near.social.fact_addkey_events' based on the min date.

From 'near.social.fact_decoded_actions' and 'near.social.fact_profile_changes' tables, I obtained the number and type of activities of new users in the selected time period.

From table 'near.core.ez_dex_swaps', I obtained new near.social users swaps based on token type and number of swaps.

I analyzed the distribution balance Near in Y new near.social users wallets from table 'near.core.fact_transfers'.