GolosCloud

Here are a bunch of quick reports you can run with ruby by accessing golos.cloud (database by @arcange) from the command line.

First, do the install. This assumes you already have ruby and bundler (if not, check out the Install Ruby section here):

$ git clone https://github.com/inertia186/golos_cloud.git
$ cd golos_cloud
$ bundle install

When you've done this, here are the rake tasks you can use:

rake apps[app,days_ago]                         # Lists apps grouped by date, app/version
rake crosscheck:powerdowns[account]             # List of accounts grouped by powerdown sums crosschecked by given account
rake crosscheck:powerups[account]               # List of accounts grouped by powerup sums crosschecked by given account
rake crosscheck:transfers[account]              # List of accounts grouped by transfer count crosschecked by memo of given account
rake crosscheck:vesting_from[account]           # List of accounts grouped by vesting transfers from a given account
rake crosscheck:vesting_to[account]             # List of accounts grouped by vesting transfers to a given account
rake proxied[days_ago]                          # Lists proxied grouped by month
rake rewards:author[symbol,days_ago]            # Lists author rewards grouped by date
rake rewards:curation[symbol,days_ago]          # Lists curation rewards grouped by date
rake transfers[minimum_amount,symbol,days_ago]  # Lists sum of transfers grouped by date, from, and to

rake apps - Lists apps grouped by date, app/version

$ rake apps[piston-lib]
Daily app matching "piston-lib" count since 2017-11-24 17:32:06 UTC ...
{
    [ Sat, 25 Nov 2017, "piston-lib/0.5.6" ] => 12,
    [ Sat, 25 Nov 2017, "piston-lib/0.5.7" ] => 1,
    [ Sun, 26 Nov 2017, "piston-lib/0.5.6" ] => 33,
    [ Sun, 26 Nov 2017, "piston-lib/0.5.7" ] => 1,
    [ Mon, 27 Nov 2017, "piston-lib/0.5.6" ] => 26,
    [ Mon, 27 Nov 2017, "piston-lib/0.5.7" ] => 1,
    [ Tue, 28 Nov 2017, "piston-lib/0.5.6" ] => 36,
    [ Tue, 28 Nov 2017, "piston-lib/0.5.7" ] => 1,
    [ Wed, 29 Nov 2017, "piston-lib/0.5.6" ] => 35,
    [ Wed, 29 Nov 2017, "piston-lib/0.5.7" ] => 1,
    [ Thu, 30 Nov 2017, "piston-lib/0.5.6" ] => 34,
    [ Thu, 30 Nov 2017, "piston-lib/0.5.7" ] => 2,
    [ Fri, 01 Dec 2017, "piston-lib/0.5.6" ] => 33,
    [ Fri, 01 Dec 2017, "piston-lib/0.5.7" ] => 1
}

rake crosscheck:powerdowns - List of accounts grouped by powerdown sums crosschecked by given account

$ rake crosscheck:powerdowns[walmart]
Powerdowns grouped by sum from walmart ...
{
    "alice" => 18867.51612800002
}

rake crosscheck:powerups[account] - List of accounts grouped by powerup sums crosschecked by given account

$ rake crosscheck:powerups[alice]
Powerups grouped by sum to alice ...
{
             "zvezda" => 3868.450721,
             "xiaomi" => 5639.46842,
            "xyligun" => 5990.378690000002,
              "xerox" => 7400.685073000001,
              "banki" => 8170.645968000001,
                "wtf" => 9862.514272000002,
         "world.news" => 11628.154487000002,
             "wilson" => 13033.434881,
            "whisper" => 17727.222964000015,
            "walmart" => 18867.516128,
            "w1nd0w5" => 22265.855752000014,
              "vtb24" => 25300.074653999996,
              "vovka" => 29058.34360800001,
              "volga" => 32460.93229500001,
              "vital" => 33963.06866300001,
     "veni-vidi-vici" => 39990.38963599999,
              "vasil" => 43798.46049000002,
               "ursa" => 48697.96059899999,
              "troll" => 48708.40308700002,
            "trinity" => 52843.260539,
             "toyota" => 57030.949726000006,
         "topinambur" => 59286.71690900001,
             "tomcat" => 61168.931498999984,
          "the.thing" => 62307.35362499998,
              "tele2" => 64947.39367,
           "svidetel" => 67212.47111499998,
             "stepan" => 71006.876998,
             "stalin" => 74429.056749,
               "soul" => 75925.013833,
              "snuff" => 78941.010496,
               "snow" => 81596.57937400001,
               "snob" => 83100.69212699999,
             "sn1per" => 85735.51043000002,
                "sms" => 86869.865492,
            "shepard" => 88761.00338800004,
                "seo" => 89506.86634499999,
              "se7en" => 91023.53305099996,
            "samocat" => 91776.37445100001,
    "rospotrebnadzor" => 92533.70253399997,
             "ripley" => 93286.73591399999,
        "renaissance" => 93661.65912600004,
              "pwn3d" => 94430.669034,
             "psycho" => 95576.24087200005,
              "porno" => 101885.36821200003,
              "pluto" => 102635.69434199994,
              "pizda" => 104523.500176,
            "physics" => 105283.978074,
            "pelevin" => 106043.38679200003,
         "per-aspera" => 106782.99681399998,
          "ostankino" => 106804.59194400003,
                "ort" => 107939.23853600006,
             "forbes" => 109056.43532699998,
             "excurs" => 109435.33667199998,
            "euribor" => 109799.60029199999,
          "evolution" => 109810.08757899998,
              "ololo" => 110967.68789200005,
           "harrison" => 113983.38514600003,
             "nvidia" => 113990.65745899997,
              "ether" => 118975.44748500004,
             "dexter" => 121164.121246,
              "nugos" => 123806.42008999999,
                "ntv" => 126079.61939000004,
           "discours" => 130021.01504500007,
               "noob" => 133252.426493,
               "niva" => 135517.00613499997,
                "mvd" => 137781.96110200003,
           "murmolka" => 138906.530928,
             "monroe" => 139287.66807600003,
             "diesel" => 139951.93534,
            "minolta" => 140055.06161099998,
             "minoga" => 140797.11587300003,
             "milana" => 141553.534369,
             "memory" => 141921.56389000002,
             "matrix" => 141931.66420399997,
          "leningrad" => 141964.019118,
         "mastercard" => 142324.44789200003,
                "m31" => 143081.43413099996,
              "lenin" => 143452.26355899996,
              "massa" => 143452.79877599998,
             "mantis" => 143834.61892799998,
          "kulinarik" => 144190.80744800004,
             "kakvse" => 144943.44796500003,
            "jackson" => 144946.866569,
             "larsen" => 144955.07685200006,
              "inbox" => 145335.560033,
              "kazak" => 145703.771317,
               "l33t" => 145704.63725999993,
             "koresh" => 145717.612568,
               "july" => 146077.51238599993,
              "iddqd" => 146078.08854100006,
           "knecht33" => 146082.734312,
             "hoover" => 146865.22409299994,
              "idiod" => 147216.158024,
             "hutzpa" => 147986.47816600002,
              "grant" => 149503.5492239999,
              "gorod" => 150279.03075200005,
             "gazeta" => 153663.7354609999,
           "fukusima" => 156695.37383300008,
          "freelance" => 160876.11936499993,
             "fr0zen" => 166145.318648,
        "formulatrix" => 169573.46705099996,
              "forex" => 170314.94180500004,
               "ford" => 174850.53940600008,
            "flatron" => 191867.62781999994,
             "expert" => 199827.53571999993,
          "cryptocat" => 207871.233717,
             "dating" => 340988.21761700005,
             "danila" => 359113.3918480003,
                "amd" => 418296.2959899999,
            "chevron" => 424137.3357919999,
          "chemistry" => 443030.73027800024,
          "ded.moroz" => 444575.0208839999,
               "bush" => 452112.7937850001,
          "barbarian" => 477037.55914399994,
              "danet" => 521993.94136100024,
               "d00m" => 565611.1276000002,
              "cre8r" => 698330.8595579998,
            "classic" => 824358.1740820003,
        "deserteagle" => 2775089.305503,
           "colberge" => 2798017.2086100006,
             "batman" => 2815156.2370110033,
           "die.hard" => 3288852.7700840007
}

rake crosscheck:transfers[account] List of accounts grouped by transfer count crosschecked by memo of given account

$ rake crosscheck:transfers[now]
Accounts grouped by transfer count using commom memos as now on common exchanges ...
{
    "livecoin" => 1,
      "lokkie" => 23,
         "now" => 29
}

rake crosscheck:vesting_from[account] List of accounts grouped by vesting transfers from a given account

$ rake crosscheck:vesting_from[now]
Accounts grouped by vesting transfer count from now ...
{
    "dobryj.kit" => 1,
           "now" => 56
}

rake crosscheck:vesting_to[account] - List of accounts grouped by vesting transfers to a given account

$ rake crosscheck:vesting_to[now]
Accounts grouped by vesting transfer count to now ...
{
      "lokkie" => 1,
    "dobrobot" => 247
}

rake proxied[days_ago] - Lists proxied grouped by month

$ rake proxied
Daily proxied grouped by month since 2017-11-24 17:46:33 UTC ...
{
    [ "2017-11", "arcange" ] => 3,
    [ "2017-11", "igrinov" ] => 12
}

rake rewards:author[symbol,days_ago] - Lists author rewards grouped by date

$ rake rewards:author
Daily author reward GBG sum grouped by date since 2017-11-24 17:47:08 UTC ...
{
    Fri, 24 Nov 2017 => 12223.479,
    Sat, 25 Nov 2017 => 31629.192,
    Sun, 26 Nov 2017 => 29126.725,
    Mon, 27 Nov 2017 => 39929.398,
    Tue, 28 Nov 2017 => 38960.713,
    Wed, 29 Nov 2017 => 39523.095,
    Thu, 30 Nov 2017 => 46537.17,
    Fri, 01 Dec 2017 => 32379.821
}

rake rewards:curation[symbol,days_ago] - Lists curation rewards grouped by date

$ rake rewards:curation
Daily curation reward MGESTS sum grouped by date since 2017-11-24 17:47:45 UTC ...
{
    Fri, 24 Nov 2017 => 5.307491531580986,
    Sat, 25 Nov 2017 => 14.703734329701046,
    Sun, 26 Nov 2017 => 13.433774871548964,
    Mon, 27 Nov 2017 => 17.111570373559953,
    Tue, 28 Nov 2017 => 16.70896271278902,
    Wed, 29 Nov 2017 => 14.052009413312064,
    Thu, 30 Nov 2017 => 16.829675909154886,
    Fri, 01 Dec 2017 => 10.903355409061012
}

rake transfers[minimum_amount,symbol,days_ago] - Lists sum of transfers grouped by date, from, and to

$ rake transfers[10000,GBG]
Daily transfer sum over 10000.000 GBG since 2017-11-01 17:48:38 UTC ...
{
    [ Sun, 05 Nov 2017, "bittrex", "openledger-dex" ] => 39499.99,
           [ Tue, 07 Nov 2017, "arcange", "bittrex" ] => 22605.0,
             [ Tue, 07 Nov 2017, "sxiii", "bittrex" ] => 45600.0,
          [ Sun, 12 Nov 2017, "golos.loto", "kazna" ] => 21372.717,
               [ Tue, 14 Nov 2017, "bittrex", "now" ] => 24999.99,
             [ Thu, 16 Nov 2017, "ropox", "bittrex" ] => 19000.0,
           [ Fri, 17 Nov 2017, "arcange", "bittrex" ] => 15000.0,
            [ Mon, 20 Nov 2017, "golosmedia", "eee" ] => 11918.174,
           [ Sat, 25 Nov 2017, "inertia", "bittrex" ] => 11816.606,
               [ Sat, 25 Nov 2017, "now", "bittrex" ] => 20000.0,
              [ Fri, 01 Dec 2017, "urri", "bittrex" ] => 18000.0
}