{
  "block": 67796522,
  "op": [
    "comment",
    {
      "author": "crokkon",
      "body": ".",
      "json_metadata": "{\"app\": \"\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "puu3w4",
      "permlink": "puucmr",
      "title": "."
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-09-18T12:47:09",
  "trx_id": "76c3d41e623687fc0aed072681e7f533b5907490",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 67796520,
  "op": [
    "comment",
    {
      "author": "crokkon",
      "body": ".",
      "json_metadata": "{\"app\": \"\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "puuecr",
      "title": "."
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-09-18T12:47:03",
  "trx_id": "1aea67bd7164ebfb9cdac872fea9c0f36fff6bf8",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 50810040,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "15.047 STEEM",
      "from_account": "a-data-scientist",
      "to_account": "a-data-scientist",
      "withdrawn": "28595.184614 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-31T14:39:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 3
}

{
  "block": 50610712,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "15.035 STEEM",
      "from_account": "a-data-scientist",
      "to_account": "a-data-scientist",
      "withdrawn": "28595.184614 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-24T14:39:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 2
}

{
  "block": 50411376,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "15.023 STEEM",
      "from_account": "a-data-scientist",
      "to_account": "a-data-scientist",
      "withdrawn": "28595.184614 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-17T14:39:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 2
}

{
  "block": 50212096,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "15.011 STEEM",
      "from_account": "a-data-scientist",
      "to_account": "a-data-scientist",
      "withdrawn": "28595.184614 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-10T14:39:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 35
}

{
  "block": 50164236,
  "op": [
    "fill_order",
    {
      "current_orderid": 1610144313,
      "current_owner": "fenrir78",
      "current_pays": "318.546 STEEM",
      "open_orderid": 1610143680,
      "open_owner": "a-data-scientist",
      "open_pays": "20.164 SBD"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-08T22:18:36",
  "trx_id": "d243729750899996e1aae78636a8b220e7fb2774",
  "trx_in_block": 2,
  "virtual_op": 3
}

{
  "block": 50164076,
  "op": [
    "transfer",
    {
      "amount": "486.553 STEEM",
      "from": "a-data-scientist",
      "memo": "102114375",
      "to": "deepcrypto8"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-08T22:10:27",
  "trx_id": "53214c757240a426d74dfa39c4aeb992b223cf3c",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 50164031,
  "op": [
    "limit_order_create",
    {
      "amount_to_sell": "50.962 SBD",
      "expiration": "2021-02-04T22:07:43",
      "fill_or_kill": false,
      "min_to_receive": "805.086 STEEM",
      "orderid": 1610143680,
      "owner": "a-data-scientist"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-08T22:08:06",
  "trx_id": "0596de2d94ec4f8eee601e1feec67ba792bfc19b",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 50164031,
  "op": [
    "fill_order",
    {
      "current_orderid": 1610143680,
      "current_owner": "a-data-scientist",
      "current_pays": "30.000 SBD",
      "open_orderid": 1610141157,
      "open_owner": "fenrir78",
      "open_pays": "473.934 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-08T22:08:06",
  "trx_id": "0596de2d94ec4f8eee601e1feec67ba792bfc19b",
  "trx_in_block": 2,
  "virtual_op": 2
}

{
  "block": 50164031,
  "op": [
    "fill_order",
    {
      "current_orderid": 1610143680,
      "current_owner": "a-data-scientist",
      "current_pays": "0.798 SBD",
      "open_orderid": 1610141001,
      "open_owner": "fenrir78",
      "open_pays": "12.619 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-08T22:08:06",
  "trx_id": "0596de2d94ec4f8eee601e1feec67ba792bfc19b",
  "trx_in_block": 2,
  "virtual_op": 1
}

{
  "block": 50014264,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609689177,
      "current_owner": "lawns",
      "current_pays": "6.098 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "101.581 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:52:45",
  "trx_id": "4901b0a37fe0a8e435edb8eea4952e7a0f722ff8",
  "trx_in_block": 3,
  "virtual_op": 1
}

{
  "block": 50014150,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609688825,
      "current_owner": "tambi",
      "current_pays": "2.597 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "43.259 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:46:57",
  "trx_id": "0459381ed8729170367d318a97bd980af07cf46f",
  "trx_in_block": 2,
  "virtual_op": 1
}

{
  "block": 50013787,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609687729,
      "current_owner": "endemikas",
      "current_pays": "1.798 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "29.950 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:28:39",
  "trx_id": "bf910ed910a5a44f6abf9d8a2b238a332623cc99",
  "trx_in_block": 2,
  "virtual_op": 1
}

{
  "block": 50013719,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609687511,
      "current_owner": "offgridlife",
      "current_pays": "0.006 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "0.099 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:25:15",
  "trx_id": "54c21aefa79f2355339dd865b4873d61f477e239",
  "trx_in_block": 6,
  "virtual_op": 1
}

{
  "block": 50013688,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609687419,
      "current_owner": "vallesleoruther",
      "current_pays": "0.105 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "1.749 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:23:42",
  "trx_id": "9a6483be1b1c93081c39fae72ebbbb914db14237",
  "trx_in_block": 6,
  "virtual_op": 1
}

{
  "block": 50013469,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609686736,
      "current_owner": "nigelmarkdias",
      "current_pays": "0.080 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "1.332 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:12:36",
  "trx_id": "ef263ef694553e4db254b94aa1c6e489ed0d0691",
  "trx_in_block": 7,
  "virtual_op": 1
}

{
  "block": 50013344,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609688018,
      "current_owner": "slwzl",
      "current_pays": "0.578 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "9.628 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T15:06:21",
  "trx_id": "7c0d4e2c8196c36944f4a7a372addf3e67e7329a",
  "trx_in_block": 6,
  "virtual_op": 1
}

{
  "block": 50013211,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609685972,
      "current_owner": "kstop1",
      "current_pays": "0.069 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "1.149 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T14:59:36",
  "trx_id": "20387b84715b9e0d03d08f8f8f0300d78056b028",
  "trx_in_block": 8,
  "virtual_op": 1
}

{
  "block": 50013055,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609685498,
      "current_owner": "ronaldoavelino",
      "current_pays": "3.182 SBD",
      "open_orderid": 1609684930,
      "open_owner": "a-data-scientist",
      "open_pays": "53.004 STEEM"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T14:51:45",
  "trx_id": "2a236def192a1a5d2c24beb5eb0e22b0bf1682c5",
  "trx_in_block": 2,
  "virtual_op": 1
}

{
  "block": 50012869,
  "op": [
    "limit_order_create",
    {
      "amount_to_sell": "242.917 STEEM",
      "expiration": "2021-01-30T14:39:59",
      "fill_or_kill": false,
      "min_to_receive": "14.583 SBD",
      "orderid": 1609684930,
      "owner": "a-data-scientist"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T14:42:15",
  "trx_id": "bdbfe5f1b84d74df27901025a75c6bbd0e4c412b",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 50012869,
  "op": [
    "fill_order",
    {
      "current_orderid": 1609684930,
      "current_owner": "a-data-scientist",
      "current_pays": "1.166 STEEM",
      "open_orderid": 1609684611,
      "open_owner": "yameen",
      "open_pays": "0.070 SBD"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T14:42:15",
  "trx_id": "bdbfe5f1b84d74df27901025a75c6bbd0e4c412b",
  "trx_in_block": 0,
  "virtual_op": 1
}

{
  "block": 50012812,
  "op": [
    "withdraw_vesting",
    {
      "account": "a-data-scientist",
      "vesting_shares": "114380.738456 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-01-03T14:39:21",
  "trx_id": "345035ab0b140e11da74f814bdd895da8f90534a",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 40595537,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @a-data-scientist! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@a-data-scientist/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@a-data-scientist) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=a-data-scientist)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemitboard/@steemitboard/steemitboard-ranking-update-a-better-rich-list-comparator\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmfRVpHQhLDhnjDtqck8GPv9NPvNKPfMsDaAFDE1D9Er2Z/header_ranking.png\"></a></td><td><a href=\"https://steemit.com/steemitboard/@steemitboard/steemitboard-ranking-update-a-better-rich-list-comparator\">SteemitBoard Ranking update - A better rich list comparator</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "steemitboard-notify-a-data-scientist-20200206t234615000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-02-06T23:46:15",
  "trx_id": "98ef9d064bec408413dea456480651fca539bc52",
  "trx_in_block": 18,
  "virtual_op": 0
}

{
  "block": 34921421,
  "op": [
    "claim_reward_balance",
    {
      "account": "a-data-scientist",
      "reward_sbd": "2.319 SBD",
      "reward_steem": "12.917 STEEM",
      "reward_vests": "44240.268631 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-23T18:54:45",
  "trx_id": "dfe632b2e94e6c1f2463f8d9465920efd7cdfe28",
  "trx_in_block": 55,
  "virtual_op": 0
}

{
  "block": 34920906,
  "op": [
    "author_reward",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "sbd_payout": "2.319 SBD",
      "steem_payout": "12.917 STEEM",
      "vesting_payout": "44240.268631 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-23T18:28:57",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 28
}

{
  "block": 34910905,
  "op": [
    "comment",
    {
      "author": "a-data-scientist",
      "body": "<i>Hi @a-data-scientist, welcome to Steem and we're glad your first post is an Utopian analysis contribution. Great start! :)</i>\n\nThanks :) \n\n<i>I'm surprised to see steemhunt that low in your engagement metric - how did you calculate the numbers? I think only the number of children to root posts should go in this metric, otherwise this would be biased by voted comments with no further replies.</i>\n\nI counted all the comments that were made on the posts upvoted by Steemhunt and then divided it to the total number of posts. \n\n<i>Steemhunt is also special in a way that it ranks all posts/comments from a period of 24h and then starts a voting round. This is why you found most of their votes at around the same time of the day.</i>\n\nNow I got it! \n\n<i>The daily/monthly upvote graphs per app are a bit hard to compare since the bins are ordered by value instead of all by day/month.</i>\n\nYes, this is what I realized too after posting this analysis, will take care of it next time. \n\n<i>Looking forward to more analyses from you! :D</i>\n\nThanks a lot, @crokkon :)",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"users\":[\"a-data-scientist\",\"crokkon\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "crokkon",
      "parent_permlink": "puuecr",
      "permlink": "pv3aua",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-23T10:08:27",
  "trx_id": "69fa09fc08a6eb4152c5d319b386e14d44f79ad8",
  "trx_in_block": 31,
  "virtual_op": 0
}

{
  "block": 34910804,
  "op": [
    "vote",
    {
      "author": "utopian-io",
      "permlink": "re-analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019-20190719t022243z",
      "voter": "a-data-scientist",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-23T10:03:24",
  "trx_id": "a3e8ca14c28d93c37c356ed78d6dbd54314e98b6",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 34910802,
  "op": [
    "vote",
    {
      "author": "crokkon",
      "permlink": "puuecr",
      "voter": "a-data-scientist",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-23T10:03:18",
  "trx_id": "c261d5f689ef5c71170565b31cf749f4017fca31",
  "trx_in_block": 12,
  "virtual_op": 0
}

{
  "block": 34793175,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "grzesiekb",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T07:54:12",
  "trx_id": "b95976bd6beb0d09110c2c02f4f58bfd20d200ab",
  "trx_in_block": 20,
  "virtual_op": 0
}

{
  "block": 34786559,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "cyprianj",
      "weight": 2120
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:23:06",
  "trx_id": "e87ba2414066e6513c7dd2e40fb6dd3dada14d11",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 34786559,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "dicetime",
      "weight": 2120
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:23:06",
  "trx_id": "2016fc74645e6b033f705ff8c2ab20227cb07da4",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 34786559,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "cryptouno",
      "weight": 500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:23:06",
  "trx_id": "22fa1934ec5569eb1460b798542cf01cae73d670",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 34786559,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "jga",
      "weight": 2120
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:23:06",
  "trx_id": "a4807a37ec307fa7cbb310232958f02a0b4619fe",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 34786559,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "tombstone",
      "weight": 1696
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:23:06",
  "trx_id": "9debef60248dbb1d229782fad0d8d3b67848f246",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 34786552,
  "op": [
    "comment",
    {
      "author": "utopian-io",
      "body": "Hey, @a-data-scientist!\n\n**Thanks for contributing on Utopian**.\nWe’re already looking forward to your next contribution!\n\n**Get higher incentives and support Utopian.io!**\n Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via [SteemPlus](https://chrome.google.com/webstore/detail/steemplus/mjbkjgcplmaneajhcbegoffkedeankaj?hl=en) or [Steeditor](https://steeditor.app)).\n\n**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**\n\n<a href='https://steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>",
      "json_metadata": "{\"app\": \"beem/0.20.17\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "re-analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019-20190719t022243z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:22:45",
  "trx_id": "73518a19127106eb4317d171bb755fd31561f6d2",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 34786551,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "utopian-io",
      "weight": 4241
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-19T02:22:42",
  "trx_id": "29de78f0882492a96db71fa836930534f081c6dd",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 34773030,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "sargoon",
      "weight": 450
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T15:06:00",
  "trx_id": "185c3ba0fe971c2825db0be5ec130da442c1029f",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 34773030,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "newsrx",
      "weight": 900
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T15:06:00",
  "trx_id": "8afda93121ccd95c3f9593c771a4954e0541e2cc",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 34773028,
  "op": [
    "comment",
    {
      "author": "steem-ua",
      "body": "#### Hi @a-data-scientist!\n\nYour post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!\nYour post is eligible for our upvote, thanks to our collaboration with @utopian-io!\n**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**",
      "json_metadata": "{\"app\": \"beem/0.20.19\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "re-analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019-20190718t150552z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T15:05:54",
  "trx_id": "6be4246c1773c5ac90baaef048ea6621b1292f1f",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 34773023,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "steem-ua",
      "weight": 900
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T15:05:39",
  "trx_id": "9575a1440b84a093fb6057cae6526acb97ea9706",
  "trx_in_block": 27,
  "virtual_op": 0
}

{
  "block": 34772739,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "mcfarhat",
      "weight": 1615
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:51:27",
  "trx_id": "998c7769169c805c4a2468948c7a706bd25baff0",
  "trx_in_block": 34,
  "virtual_op": 0
}

{
  "block": 34772678,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "jinger",
      "weight": 6462
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:48:24",
  "trx_id": "4b4987b0cf66f368f946cf46de0a96bef47f2ac4",
  "trx_in_block": 29,
  "virtual_op": 0
}

{
  "block": 34772677,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "buckydurddle",
      "weight": 5250
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:48:21",
  "trx_id": "0db5b2ffc0121ac13adff0dc41d2a39c32b1c763",
  "trx_in_block": 25,
  "virtual_op": 0
}

{
  "block": 34772657,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "codingdefined",
      "weight": 4039
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:47:21",
  "trx_id": "22b7917019ad14262d5ec13ee71a61a34f6764ea",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 34772644,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "jaff8",
      "weight": 4039
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:46:42",
  "trx_id": "8e9a1a3bf048e3a11e837ed975f5f0b82a8a3e4a",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 34772643,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "rufans",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:46:39",
  "trx_id": "1754b1f9172f6632df08cb70f80686b325c64035",
  "trx_in_block": 49,
  "virtual_op": 0
}

{
  "block": 34772643,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "helo",
      "weight": 4039
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:46:39",
  "trx_id": "bcea61ead17a077e2d8587e0156379925b922c92",
  "trx_in_block": 48,
  "virtual_op": 0
}

{
  "block": 34772643,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "asaj",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:46:39",
  "trx_id": "e6fb5caf0115805892142dab07d5ecdabb82f413",
  "trx_in_block": 46,
  "virtual_op": 0
}

{
  "block": 34772636,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "amosbastian",
      "weight": 4039
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:46:18",
  "trx_id": "df6487a1461571cd19671e093ea29eeb84c2dfb0",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 34772627,
  "op": [
    "comment",
    {
      "author": "crokkon",
      "body": "Hi @a-data-scientist, welcome to Steem and we're glad your first post is an Utopian analysis contribution. Great start! :)\nThe distribution of the number of upvotes nicely shows the different approaches of the apps. Most of them manage their available VP quite well over the day. This means that with higher vote percentages, only a lower number of votes can be cast, and vice versa. Steemhunt is certainly an example for lots of votes with rather small vote percentages. By numbers, the votes are mainly on comments as you also discovered.\nI'm surprised to see steemhunt that low in your engagement metric - how did you calculate the numbers? I think only the number of children to root posts should go in this metric, otherwise this would be biased by voted comments with no further replies.\nSteemhunt is also special in a way that it ranks all posts/comments from a period of 24h and then starts a voting round. This is why you found most of their votes at around the same time of the day.\nThe daily/monthly upvote graphs per app are a bit hard to compare since the bins are ordered by value instead of all by day/month.\nAnother aspect is the vote value from the different apps, which may play a strong role in the vote distribution policy. Steemhunt with 1.4M SP may have a different approach than dsound with 100k SP.\n\nLooking forward to more analyses from you! :D\n\nYour contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category.\n\nTo view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/0/2-2-2-2-1-1-3-).\n\n---- \nNeed help? Chat with us on [Discord](https://discord.gg/uTyJkNm).\n\n[[utopian-moderator]](https://join.utopian.io/)",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"users\":[\"a-data-scientist\"],\"links\":[\"https://join.utopian.io/guidelines\",\"https://review.utopian.io/result/0/2-2-2-2-1-1-3-\",\"https://discord.gg/uTyJkNm\",\"https://join.utopian.io/\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "puuecr",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:45:51",
  "trx_id": "243821e79d51f5f0174c5cbf3e594c4a7b089ea4",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 34771883,
  "op": [
    "comment",
    {
      "author": "crokkon",
      "body": "Hi, awesome! :)\nSorry for the troubles with discord - please try this invite link: https://discord.gg/YCvEWzR\nYour contribution is in the Utopian review queue.",
      "json_metadata": "{\"tags\":[\"dpoll\"],\"links\":[\"https://discord.gg/YCvEWzR\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "puu3w4",
      "permlink": "puucmr",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T14:08:39",
  "trx_id": "fc7790b51822763d483823fa5bede80d1616542c",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 34771659,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "crokkon",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T13:57:24",
  "trx_id": "fbabfbcf0731ab5d93c6eead3f78a376b3711fe5",
  "trx_in_block": 36,
  "virtual_op": 0
}

{
  "block": 34768115,
  "op": [
    "comment",
    {
      "author": "a-data-scientist",
      "body": "Hi @crokkon\n\nHow can I join the Utopin Discord group? It says Invite Invalid when I click on this link: <b>\"Join us on Discord https://discord.gg/h52nFrV</b>\n\nJust wanna submit my analysis <a href=\"https://steemit.com/utopian-io/@a-data-scientist/analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019\">contribution</a>",
      "json_metadata": "{\"tags\":[\"dpoll\"],\"users\":[\"crokkon\"],\"links\":[\"https://discord.gg/h52nFrV\",\"https://steemit.com/utopian-io/@a-data-scientist/analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "crokkon",
      "parent_permlink": "pur3j4",
      "permlink": "puu3w4",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T10:59:57",
  "trx_id": "5ea0f90c314cb0eca60d74407f79bab34549c06d",
  "trx_in_block": 19,
  "virtual_op": 0
}

{
  "block": 34765749,
  "op": [
    "comment",
    {
      "author": "lanmower",
      "body": "Hey there @a-data-scientist, welcome to STEEM. If you join @schoolofminnows, you can receive votes for free.\n            1. Your post will appear in post-promotion on the discord.\n            2. Your posts will also get featured on the school of minnows account on steem\n            https://steemit.com/@schoolofminnows\n            3. You get votes from other members.\n            4. The whole thing is FREE.\n            To join follow this link:\n            https://steem.host/connect/steempunks",
      "json_metadata": "{}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019-sominvite",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T09:01:33",
  "trx_id": "cb040f8c5679a8481692a8fc0ba856fe5509abff",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 34765319,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "ryuna.siege",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T08:40:00",
  "trx_id": "4c47ff338bf89cbbdc7caf0ad4176d82e2dc0e02",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 34763083,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "tdre",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T06:48:03",
  "trx_id": "e1f44e569ac60b30191b849e99133ae37ac2b45f",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 34762282,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "jjay",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-18T06:08:00",
  "trx_id": "0c23eb22de6f722639bb79d08ba3894d9a9f0759",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 34723923,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @a-data-scientist! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :\n\n<table><tr><td><img src=\"https://steemitimages.com/60x60/http://steemitboard.com/img/notifications/firstpost.png\"></td><td>You published your First Post</td></tr>\n<tr><td><img src=\"https://steemitimages.com/60x60/http://steemitboard.com/img/notifications/firstvoted.png\"></td><td>You got a First Vote</td></tr>\n</table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@a-data-scientist) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=a-data-scientist)_</sub>\n<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>\n\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "steemitboard-notify-a-data-scientist-20190716t220835000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T22:08:33",
  "trx_id": "731a52bd94af32f40d58c6b670c736f39e6480f0",
  "trx_in_block": 36,
  "virtual_op": 0
}

{
  "block": 34719815,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "espoem",
      "weight": 500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:42:51",
  "trx_id": "a3cc8c6ee20dc92cd4a9827abfc8f47d520ae223",
  "trx_in_block": 26,
  "virtual_op": 0
}

{
  "block": 34719724,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "primeradue",
      "weight": 1000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:38:18",
  "trx_id": "700ff7b204f3a2ddec525d9f8b206e7184f933cb",
  "trx_in_block": 27,
  "virtual_op": 0
}

{
  "block": 34719724,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "fego",
      "weight": 2000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:38:18",
  "trx_id": "96b2459ee22ba2745a7b690d58d93605a7786e02",
  "trx_in_block": 26,
  "virtual_op": 0
}

{
  "block": 34719718,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "mightypanda",
      "weight": 2000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:38:00",
  "trx_id": "66456de3fe22f2fa845c626f173d4442913186a1",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 34719659,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "pixelfan",
      "weight": 200
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:35:03",
  "trx_id": "8f8776e7a5d4b4ecbe956012ddc79b48361b9717",
  "trx_in_block": 19,
  "virtual_op": 0
}

{
  "block": 34719656,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "pixresteemer",
      "weight": 900
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:34:54",
  "trx_id": "83718e74a5478a59e8dcd42ed0bffe67a85c5b46",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 34719652,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "randomvoter",
      "weight": 700
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:34:42",
  "trx_id": "36daed5f8f64147802ac1202f9d4d34c437cf227",
  "trx_in_block": 42,
  "virtual_op": 0
}

{
  "block": 34719649,
  "op": [
    "vote",
    {
      "author": "a-data-scientist",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "voter": "anonyvoter",
      "weight": 1150
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:34:33",
  "trx_id": "17151420ce8272226bf2c2998900aac0031d4315",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 34719590,
  "op": [
    "comment",
    {
      "author": "esteemapp",
      "body": "Thanks for mentioning eSteem app. Kindly join our [Discord](https://discord.gg/UkUCWG8) or [Telegram](https://t.me/esteemapp) channel for more benefits and offers on [eSteem](https://esteem.app), don't miss our amazing updates.<br>Follow @esteemapp as well!",
      "json_metadata": "{\"tags\":[\"esteem\"],\"app\":\"esteem/2.0-welcome\",\"format\":\"markdown+html\",\"community\":\"esteem.app\"}",
      "parent_author": "a-data-scientist",
      "parent_permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "permlink": "re-2019716t203136120z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:31:36",
  "trx_id": "8c3aff4c1240b2be66ed4f59bde8e37212ec9143",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 34719537,
  "op": [
    "comment",
    {
      "author": "a-data-scientist",
      "body": "<h3>Repository</h3>\n<p>https://github.com/steemit/steem</p>\n\n<p>The aim of this analysis is to get an idea about the upvoting behavior of different Steem applications for the last six months. I chose the applications that I think are the most popular among Steem users like @steemhunt, @actifit, @partiko, @busy, @esteemapp, @fundition, @steempress-io, @dtube, and @dsound. Along with the number of upvotes each application gave to its users, you will find some interesting information about their upvoting behavior like the number of upvotes given on posts and comments, average and standard deviations of upvotes, monthwise, daywise and hourwise performance and the distribution of upvotes for each application</p>\n\n<h3>Data Collection</h3>\n<p>All the data was extracted from Steem SQL Database (Paid subscription service held and managed by @arcange). The data was taken from 1-01-2019 to 06-30-2019 and all the calculations were made on Power BI using DAX. SQL query that was used to extract the data can be found at the end of this post.</p>\n\n<h3>Total Number of Upvotes on Posts & Comments</h3>\n\nhttps://i.postimg.cc/NGrJ5qDJ/1-Total-number-of-upvotes.png\n<br>\n\n<p>@steemhunt has the highest percentage when we compare the number of upvotes given with other Steem applications, however, the unique number of authors who were given upvotes by @steemhunt were only 519. @dtube and @dsound tend to be at the bottom when it comes to the number of upvotes given compared with other Steem applications. On the right side of the image, you can see the number of unique users who were given upvotes by each application. Another interesting thing would be to calculate the number of unique user ratio who were given upvotes by each application.</p>\n<br>\nhttps://i.postimg.cc/CxjzcN0H/new.png\n<br>\n<p>@partiko is on top when it comes to unique user ratio (Giving an upvote to a unique user). Though @steemhunt is on top with the number of upvotes given, however, at the same time, it has the lowest unique user ratio. @dtube and @dsound gave the lowest number of upvotes, but @dtube's unique user ratio is far better than @dsound.</p>\n\n<p>Let's separate the number of upvotes given on comments and posts.</p> \n\n<br>\n\nhttps://i.postimg.cc/7Lf1d0Qs/4-Upvotes-on-Comments.png\n<br>\n<p>Interesting!</p> \n<p>You can see that @steemhunt and @fundition were the only applications that gave a fair amount of upvotes on comments with a percentage of 78% and 9.32% respectively. Did a little research and found that @steemhunt rewards those users as well who comment on @steemhunt posts which is a great idea to increase the engagement rate.</p>\n\n<p>So my next question is, what's the engagement rate for each application? (Comments on posts)</p>\n<br>\n\nhttps://i.postimg.cc/T2m0Tj2B/2-Total-comments.png\n\n<p><p>@busy and @dtube have the highest engagement rates with 11.37 and 7.52 comments per post respectively. Surprisingly, @steemhunt's engagement rate is at the bottom with 1.52 comments per post. </p></p>\n\n<br>\n\n<h3>Average and Standard Deviations</h3>\n<p>@dsound and @dtube have the highest averages, though the number of upvotes they gave was quite low, their average upvote weight is quite outstanding. On the other hand, @dsound has the highest standard deviation that means that their upvote weight had a greater variation compared to others. @steemhunt has the lowest average upvote weight and @busy has the lowest standard deviation.</p>\n<p>Did you notice @partiko? Their average upvote weight is 2.48 but the standard deviation is 11.74 which is quite high.</p>\n\n<br>\n\n<h3>Monthly Upvote Analysis</h3>\n\n<p>Here, you can see the upvotes given by each application from January to June. </p> \nhttps://i.postimg.cc/hjqq3wF4/5-Monthwise-1.png\nhttps://i.postimg.cc/wTBYPLrN/6-Monthwise-2.png\nhttps://i.postimg.cc/fbN24hbP/7-Monthwise-3.png\n<br>\n\n<h3>Daily Upvote Analysis</h3>\n\n<p>What day of the week each application gave the most upvotes?</p>\n\nhttps://i.postimg.cc/yxmhyDmY/8-Daywise-1.png\nhttps://i.postimg.cc/x1TGLTcn/9-Daywise-2.png\nhttps://i.postimg.cc/L53fZrSJ/10-Daywise-3.png\n<br>\n\n<h3>Hourly Upvote Analysis</h3>\n\n<p>And at what hour most upvotes were given by these applications?</p>\nhttps://i.postimg.cc/5Ntj3Hq7/11-Hourwise-1.png\nhttps://i.postimg.cc/Y9ptCVdn/12-Hourwise-2.png\nhttps://i.postimg.cc/K8DGhxNk/13-Hourwise-3.png\n\n<p>Dod you notice something weird? @steemhunt almost gave every upvote between 3:00 PM to 500 PM.</p>\n<br>\n\n<h3>Distribution of Upvotes</h3>\nhttps://i.postimg.cc/c4Qg6qhZ/14-Distribution1.png\nhttps://i.postimg.cc/MGGvsnSK/15-Distribution-2.png\nhttps://i.postimg.cc/DZJmTR09/16-Distribution-3.png\n<br>\n\n<p>You can see that the upvote weight for most of the application lies between 0 - 10, however, @dtube and @dsound did different from all other applications and we can see a few tall bars for other ranges as well. The weight of most of the upvotes that @busy gave was between 0 - 2.9.</p>\n<h3>Relationship Between Comments & Upvotes</h3>\n<br>\nhttps://i.postimg.cc/G3K6R9w1/17-Scatterplot.png\n<br>\n\n<p>I wanted to see if there is any correlation between the upvote weight and comments but there was none. The coefficient of correlation is 0.0384 between the upvote weight and comments.</p>\n\n<h3>Conclusion</h3>\n\n<p>Steem applications play a vital role in attracting the outside world towards this platform, so their upvoting behavior is crucial for the success of this platform. From the above analysis, we can see that a lot of applications are giving a fair amount of upvotes to its users with a low upvote weight which I think is a perfect way to attract new users,  however, the unique user ratio should be improved in order to spread the number of upvotes to more users.</p>\n\n<h3>SQL Query</h3>\n<code>SELECT\nTxVotes.ID,\nTxVotes.voter,\nTxVotes.author,\nCAST(TxVotes.\"weight\" AS INT)/100 AS upvote_weight,\nTxVotes.\"timestamp\",\nCASE\nWHEN Comments.depth = 0 THEN 'Post'\nELSE 'Comment'\nEND AS post_type,\nComments.depth,\nComments.url,\nComments.children AS comments\nFROM TxVotes\nJOIN Comments\nON TxVotes.permlink = Comments.permlink AND Txvotes.author = Comments.author \nWHERE TxVotes.voter IN ('dtube', 'dsound', 'esteemapp', 'busy.pay', 'steempress-io', 'steemhunt', 'fundition', 'actifit','partiko')\nAND TXVotes.\"timestamp\" Between '2019-01-01' AND '2019-06-30'\n</code>",
      "json_metadata": "{\"tags\":[\"utopian-io\",\"analysis\",\"steem\",\"applications\",\"blockchain\"],\"users\":[\"steemhunt\",\"actifit\",\"partiko\",\"busy\",\"esteemapp\",\"fundition\",\"steempress-io\",\"dtube\",\"dsound\",\"arcange\"],\"image\":[\"https://i.postimg.cc/NGrJ5qDJ/1-Total-number-of-upvotes.png\",\"https://i.postimg.cc/CxjzcN0H/new.png\",\"https://i.postimg.cc/7Lf1d0Qs/4-Upvotes-on-Comments.png\",\"https://i.postimg.cc/T2m0Tj2B/2-Total-comments.png\",\"https://i.postimg.cc/hjqq3wF4/5-Monthwise-1.png\",\"https://i.postimg.cc/wTBYPLrN/6-Monthwise-2.png\",\"https://i.postimg.cc/fbN24hbP/7-Monthwise-3.png\",\"https://i.postimg.cc/yxmhyDmY/8-Daywise-1.png\",\"https://i.postimg.cc/x1TGLTcn/9-Daywise-2.png\",\"https://i.postimg.cc/L53fZrSJ/10-Daywise-3.png\",\"https://i.postimg.cc/5Ntj3Hq7/11-Hourwise-1.png\",\"https://i.postimg.cc/Y9ptCVdn/12-Hourwise-2.png\",\"https://i.postimg.cc/K8DGhxNk/13-Hourwise-3.png\",\"https://i.postimg.cc/c4Qg6qhZ/14-Distribution1.png\",\"https://i.postimg.cc/MGGvsnSK/15-Distribution-2.png\",\"https://i.postimg.cc/DZJmTR09/16-Distribution-3.png\",\"https://i.postimg.cc/G3K6R9w1/17-Scatterplot.png\"],\"links\":[\"https://github.com/steemit/steem\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "analyzing-upvote-behavior-of-steem-applications-from-1-01-2019-to-06-30-2019",
      "title": "Analyzing Upvote Behavior of Steem Applications -  From 1-01-2019 to 06-30-2019"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-07-16T18:28:57",
  "trx_id": "1409902b8d674a95643c6ce132a66310de51c23a",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 31863001,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"ned\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:41:39",
  "trx_id": "6e46a51f57dd784e00c4b0591009b8fa555c655a",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 31862998,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"arcange\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:41:30",
  "trx_id": "6c644bf4d7f16d836f5c2250ff0624c4478a1cd7",
  "trx_in_block": 24,
  "virtual_op": 0
}

{
  "block": 31862993,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"teamsteem\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:41:15",
  "trx_id": "390b4eb57528afd12ed020c24d8ce4d6b7b1a5cc",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 31862990,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"blocktrades\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:41:06",
  "trx_id": "c0ec7c867457b7da810c7b5e183978632e382e1d",
  "trx_in_block": 38,
  "virtual_op": 0
}

{
  "block": 31862985,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"lukestokes\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:40:51",
  "trx_id": "981508472da3f5867e533107291d546d6734c798",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 31862974,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"a-data-scientist\",\"following\":\"fulltimegeek\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "a-data-scientist"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-08T10:40:18",
  "trx_id": "e77133c7b49dfd1a046853a8d7976bfe51668c76",
  "trx_in_block": 16,
  "virtual_op": 0
}