Top hashtags of the day (by rewards) - YESTERDAY (29th October 2021) [ENG-ESP]

over 3 years ago (Edited)

I had some extra time today to play a bit more with @hivesql data. I am always curious about what are the most used hashtags when it comes to the most upvoted posts during a day. So I went to discover it from the data.

Creo que este es mi primer post en español - un poco random pero vale la pena! Ayer estuve jugando un poco más con los datos de @hivesql. Desde que empecé a bloggear en Hive, he tenido la curiosidad de saber cuáles son los hashtags más utilizados por los post que más votos generan. Así que dediqué un poco de tiempo a descubir la respuesta.

The idea was actually fairly simple. I just calculated the most used hashtags among the top 100 upvoted posts of the day. In the graph below you can see the most used hashtags. I didn't want to calculate the most used ones of all time as I don't think they bring that much value to the table as the most recent ones.

La idea es bastante simple. Lo único que hice fue calcular los hashtags más utilizados por los cien posts más votados de ayer. En el gráfico de abajo se puede observar el resultado. No quise calcular los más utilizados de todo el tiempo porque me parece que los de día a día generan más valor.

Do you use them on a daily basis? I don't really use some of these hashtags on a daily basis but I think they give also an understanding of the most rewarded posts out there as of today.

¿Los usas a diario? La verdad es que yo no. Pero creo que te dan una idea de cuáles son los tópicos más usados del día y porqué se llevan los votos.

If you want to try it by yourself, here is the code:

Si quieres probarlo por ti mismo, aquí está el código:

SELECT TOP 10 value, COUNT(value) AS total
FROM (
      SELECT TOP (100) Comments.author AS author,
             LEN(Comments.active_votes) AS votes,
             Comments.created AS created,
             STRING_AGG(ISNULL(Tags.tag, ' '), ',') AS tags
      FROM [DBHive].[dbo].[Tags]
      INNER JOIN Comments ON Tags.comment_id = Comments.ID
      WHERE created > '2021-10-28 23:59:59.000' AND created < '2021-10-29 23:59:59.000'
      GROUP BY author, created, Comments.active_votes
      ORDER BY votes DESC 
      ) first_query
CROSS APPLY STRING_SPLIT(first_query.tags, ',')
GROUP BY value
ORDER BY total DESC;

I love sharing data knowledge as much as possible. Do you like these type of insights? Leave a comment below and let me know what you think 😉

Me gusta compartir conocimientos de datos. ¿Te. interesará saber más sobre este tipo de análisis? Deja un comentario y házmelo saber 😉

#palnet, #proofofbrain, #creativecoin, #neoxian, #spanish, #photography, #art, #archon, #ocd, #photofeed

spanish proofofbrain creativecoin blog sql stem python palnet

0.000

1 comments

@hivebuzz 74

over 3 years ago

Congratulations @aicoding! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

	You received more than 4750 upvotes. Your next target is to reach 5000 upvotes.
	You distributed more than 500 upvotes. Your next target is to reach 600 upvotes.

_{You can view your badges on your board and compare yourself to others in the Ranking}
_{If you no longer want to receive notifications, reply to this comment with the word STOP}

To support your work, I also upvoted your post!

Check out the last post from @hivebuzz:

	Hive Power Up Day - November 1st 2021 - Hive Power Delegation
	Bee ready for the 2nd Hive Power Up Month challenge!
	Trick or Treat - Share your scariest story and get your Halloween badge

Support the HiveBuzz project. Vote for our proposal!

0.000